2012. június 21., csütörtök

Migrating MySQL to MS SQL

I got a question about the available solutions of migration from MySQL to MS SQL. Well, I have you admit I haven’t experiences of this but I found this topic very interesting. So I looked for a difficulties and possibilities.

I had a guess that I can solve parts of this task with SSIS. But perhaps this isn’t the best solution because SSIS can’t migrate right the procedures, triggers, etc.

I found two better way, both are tools designed directly to this job. One of these options is Spectral Core’s SQLTRAN that you can buy for 999 USD. This can also translate between the two SQL dialects (i.e. inside of stored procedures).

The other way is the free Microsoft migration tool, called SQL Server Migration Assistant (SSMA). This has many options and features too. On the website of this application you will find many useful links and there is a guideline to migrating that contains the most important issues and the main differences between these two databases.

Additionally, I recently read about one more solution that's called SwisSQL.

Nincsenek megjegyzések:

Megjegyzés küldése