how can i import data from mysql to sqlserver

Posted by Chanti444 under ASP.NET on 12/15/2011 | Points: 10 | Views : 890 | Status : [Member] | Replies : 1
i have a database that is in mysql and would like to import it into sql server 2008 express

can this be done pls guide me step by step ...........?

<a href= >gamestop</a>, <a href= >pandora</a>, <a href= >limewire</a>



Posted by: Nilschaudhari on: 12/15/2011 [Member] Starter | Points: 25


In sql server there is option for import and export
use right click on the database and select the task option
then select Import

then one popup window is opend for import export
then select the source database and provide the connection parameter
after that choose destination server i.e. your sql server and provide connection parameter
after the you can choose the exsting tables or write the query for fetch the data from the source.

edit the table mapping and click next data transfer started

Chanti444, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response