Different ways to move data or database between server and databases

Home >> Dababase Interview Questions >> Sql Server Interview Questions

Posted on February 7th , 2012 by Admin

There are many options available to move data or databases in between servers and databases in sql server so we have to choose good option depending upon our requirements. Some of the options we have are:-

(1)BACKUP/RESTORE

(2)detaching and attaching databases

(3)Replication

(4)DTS

(5)BCP

(6)logshipping

(7)INSERT...SELECT

(8)SELECT...INTO

(9)creating INSERT scripts to generate data.