Possible use or import a MySQL database in SQL Server 2005?

Hi all,
I am developing a web application and the back end is MySQL database.

Now I want to shift all the data to SQL Server 2005.

Is there any method to do it?

Thanks

Tomy

Hi,

You can try to use SQL Server Integration Services to do the import/export. Please check the following link for more information

http://msdn2.microsoft.com/en-us/library/ms141026.aspx

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!