Forum guidelines
AuthorQuestion
Moving data in Sql Server
Posted on: 14 Dec 2011
HI,

What are the different ways of moving data/databases between servers and databases in SQL Server?


Thanks

AuthorReply
Re: Moving data in Sql Server
Posted on: 15 Dec 2011  
Hi,

1.BACKUP/RESTORE, dettaching and
attaching databases, replication, DTS, BCP, logshipping,
INSERT...SELECT, SELECT...INTO, creating INSERT scripts to
generate data.

Please check below link for more inforamtion.

http://www.windowsitpro.com/article/john-savills-windows-faqs/how-do-i-transfer-data-between-sql-server-databases-across-servers-

Hope this will help you.

Thanks.

Re: Moving data in Sql Server
Posted on: 15 Dec 2011  
Hi Arjun,


There are several ways of doing

- BACKUP/RESTORE,
- Dettaching/attaching databases,
- Replication,
- DTS,
- BCP,
- logshipping,
- INSERT...SELECT,
- SELECT...INTO,
- creating INSERT scripts to generate data.



Thanks

If this post helps you mark it as answer
Thanks

Re: Moving data in Sql Server
Posted on: 15 Dec 2011  
Thanks to all

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.