Re: importing data from sql server
SQL dialect of SQL Server is quite different to MySQL's dialect - so you can't simply execute the same script on both servers.
If you are well versed with both databases, you might be able to manually tweak SQL file. If that SQL script is huge, that approach won't get you very far.
It probably makes most sense to run Full Convert - see
http://www.spectralcore.com/fullconvert/ - and let it connect to both servers and transfer the data for you.
Subject
Written By
Posted
Re: importing data from sql server
August 02, 2012 10:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.