Forum guidelines
AuthorQuestion
Moving data in Sql Server
Posted By Arjun Panwar 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 By Priya Linge 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 By Satyapriya Nayak 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 By Arjun Panwar on 15 Dec 2011  
Thanks to all

Infragistics jQuery Controls

SPONSORED BY

JetBrains ReSharper Ultimate
.NET code analysis, refactorings, navigation, unit testing, code coverage and profiling in Visual Studio, a bonus for C++ devs, bundled at 50% off.