June 7, 2011 at 6:00 am
Hi,
I inherited a MySQL database that I want to migrate to SQL Server 2005.
However, I have no experience with MySQL.
I've downloaded a whitepaper from MS, but that doesn't really tell me how to do it. It focusses on the differences in datatypes and functions.
Has anyone of the forum ever migrated MySQL to SQL Server 2005 who could give me some tips on how to get started?
Any help would be appreciated.
Thank you.
Vera
June 7, 2011 at 6:12 am
I know mysql has a scripting function that creates a sql server script to create the tables and insert the data.
The realy question is there how do you refactor the application to use sql server. That one may take a lot more time than moving the data.
June 7, 2011 at 6:51 am
Ninja's is referring to mysqldump. It can generate a script that contains the schema definitions as well as the data inserts necessary to build the complete database in SQL Server. There are also options and switches to have it generate a more generic ANSI-style script that may be runnable directly into SQL Server with no changes.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 6, 2011 at 8:19 am
that is fine as long as it is only tables and data. It gets more complicated if you need to migrate SPs, check-constraints, user access rights etc..
An alternative would be to link the MySQL database using the ODBC drivers.
July 6, 2011 at 9:24 am
Check constraints? How would linking to MySQL using ODBC provide any advantage over MySQL dump?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply