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.
tutorials, tips and tricks to design a Sql Server, Cloud Service . Micrsoft Interview Question
Friday, January 21, 2011
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment