MYSQL to Microsoft SQL

[stevomorrison]

I have a call centre reporting customer who was using MYSQL 4.1 for their call records and now it must be setup on Microsoft SQL on a different computer. I am not very familiar with SQL and need to move the records to the Microsoft SQL Server. Any help would be appreciated

 

[NoCoolHandle]

1. You could use the "import data" task for a database in management studio and specify the data is comming from an odbc datasource.. THis datasource could point to your mysql database.

2. You could set up a "linked server" that points to your mysql box and then use a select into query to populate the data. (again use the odbc drivers)

also

http://technet.microsoft.com/en-us/library/cc966396.aspx

references migrating from mysql to sql. (probably a good place to start)

HTH


Rob