I'm migrating an application from an older Mac Server onto a new Win 2008 server to be shared with sharepoint. Hence we need to migrate the DB.
I've created a test VM with same SQL 2005 config and installed MySQL with source DB.
Have been trying for a couple of days now to use SSIS to import the data but are having many problems with this.
I've just done a mysql dump using phpmyadmin and noticed / set compatibility option to MSSQL and saved it to a .sql file. I'm assuming this option is only to help minimize problems with the datatype differences such as varchar length etc..
What would be a good way to import this?
DB is about 600MB and contains ~240 tables