how can i import data from mysql to sqlserver

Posted by Chanti444 under ASP.NET on 12/15/2011 | Points: 10 | Views : 1670 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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=http://www.gamestopagent.com >gamestop</a>, <a href=http://www.pandora-music.name/ >pandora</a>, <a href=http://www.limewire.name/ >limewire</a>

satya

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	hi, 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

hi,

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

Latest Posts