<p>The university I work at uses Oracle for the database system. We currently have programs we run at night to download what we need into some local Access tables for our testing needs. Access is getting to small for this now and we need something bigger. Also, the nightly jobs require constant maintance to keep working (because of network issues, table changes, bad code :) ) and I would like to eliminate them to free us up for more important things.</p>

<p>I am most familiar with MySQL so I setup a test MySQL server. What is the best way to automate copying the needed tables from Oracle to MySQL?</p>

<p>Edit: I accepted the answer. I don't like the answer but it seems to be correct based on further research and the lack of other answers provided. Thanks to all for pondering my question and answering it.</p>

[{'answer_id': 20858, 'author': 'Preston', 'author_id': 2006, 'author_profile': 'https://Stackoverflow.com/users/2006', 'pm_score': 0, 'selected': False, 'text': '<p>Could you just copy the Oracle tables and then set them up as linked tables in MS Access? This way the front-end stays the same plus you keep everything in Oracle (less moving parts than exporting and importing).</p>\n'}, {'answer_id': 36983, 'author': 'Matthew Watson', 'author_id': 3839, 'author_profile': 'https://Stackoverflow.com/users/3839', 'pm_score': 2, 'selected': True, 'text': '<p>I don\'t think there is really anything that is going to do this. If you could setup a local Oracle database, then most likely you could as oracle has various means of keeping two databases "in sync", provided they are both Oracle.</p>\n\n<p>If you must use mysql, then likely you are going to just have to write something to sync the data, this is of course always going to run in the same problems you currently have with the access "database".</p>\n\n<p>You could setup something with HSODBC and triggers, but</p>\n\n<ol>\n<li>I\'ve found HSODBC to be very memory hungry</li>\n<li>This is only going to add more load to your DB, which you say is already heavily loaded during the day.</li>\n</ol>\n\n<p>If the main thing you are doing is wanting a local Test copy of your oracle database, you would be best to setup syncing with a local version of oracle, as far as I can tell from the licenses, oracle is free for development copies ( I have seen some posts to the contrary, but if you find that is the case, you could always use something like Oracle XE)</p>\n'}, {'answer_id': 4958323, 'author': 'reiniero', 'author_id': 316352, 'author_profile': 'https://Stackoverflow.com/users/316352', 'pm_score': 0, 'selected': False, 'text': '<p>As Kellyn said, there are lots of free tools. One of them is SQLWorkbench <a href="http://www.sql-workbench.net/" rel="nofollow">http://www.sql-workbench.net/</a>, which works with any JDBC database, so MySQL and Oracle should work.\nIt can create tables in Oracle if needed, or just only copy over the (updated) data.</p>\n'}, {'answer_id': 50299324, 'author': 'ssbh', 'author_id': 6855721, 'author_profile': 'https://Stackoverflow.com/users/6855721', 'pm_score': 0, 'selected': False, 'text': '<p>There are many tool available to migrate data from oracle to mysql if your database is not very complicated. </p>\n\n<p>You can use open source tools like  Kettle pentaho ETL tool  or paid enterprise tools like DB convert: <a href="https://dbconvert.com/oracle/mysql/" rel="nofollow noreferrer">https://dbconvert.com/oracle/mysql/</a></p>\n\n<p>Lastly you can write a script or program that migrates the data. </p>\n\n<p>Please find links related to your question: </p>\n\n<p><a href="https://dba.stackexchange.com/questions/150343/how-to-sync-a-mysql-db-with-a-oracle-db">https://dba.stackexchange.com/questions/150343/how-to-sync-a-mysql-db-with-a-oracle-db</a></p>\n\n<p><a href="https://stackoverflow.com/questions/2479500/migrate-from-oracle-to-mysql">Migrate from Oracle to MySQL</a></p>\n'}]
['https://Stackoverflow.com/questions/20811', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1340/']