What are the various options to move the data/databases ?

 Posted by PandianS on 10/29/2010 | Category: Sql Server Interview questions | Views: 2206 | Points: 40
Answer:

We have lots of options, we have to choose our option depending upon our requirements.

1.BACKUP/RESTORE
2.Dettaching, Moving the files and attaching databases
3.Replication
4.Mirroring
5.Logshipping
6.Implementing Linked Server and accessing the data using four / three part naning convention
7.DTS or DTSX
8.BCP
9.INSERT…SELECT or SELECT…INTO
10. Creating INSERT scripts to generate data.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response