Different ways of moving data from databases

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

Posted on March 4th , 2010 by Admin

There are different methods of moving data

(1)BACKUP and RESTORE

(2)detaching

(3)Attaching databases

(4)Replication

(5) DTS

(6)BCP

(7)logshipping

(8) INSERT...SELECT

(9)SELECT...INTO

(10) creating INSERT scripts to generate data.