how to DTS, import and export, Database migration in sql server.

Posted by Dn2010 under Sql Server on 2/14/2011 | Points: 10 | Views : 1172 | Status : [Member] | Replies : 3
hi friends,

how to DTS, import and export, Database migration in sql server.

please give in detail.

thanks.




Responses

Posted by: Karthikanbarasan on: 2/14/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25
Posted by: Madhu.b.rokkam on: 2/15/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
You can right click on the Data Transformation Services under your SQL2000 server then click on Open Package select the package from file and then save in.

To Export you can open the package and goto file menu and use saveas option from file menu.


Thanks and Regards
Madhu

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

Posted by: Prabhakar on: 2/15/2011 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hi dn2010

u want to Data migration in Sql 2010 so check this link .it's a help full for u

http://database.ittoolbox.com/documents/sql-server-2000-database-migrationcopy-18042

Best Regard's
Prabhakar

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

Login to post response