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