What are the different ways of moving data/databases between servers and datab

What are the different ways of moving data/databases
between servers and databases in SQL Server?

Question Posted / swapna

3 Answers
13657 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the different ways of moving data/databases between servers and databases in SQL Server?..

Answer / swapna

There are lots of options available, you have to choose
your option depending upon your requirements. Some of the
options you have are: BACKUP/RESTORE, dettaching and
attaching databases, replication, DTS, BCP, logshipping,
INSERT...SELECT, SELECT...INTO, creating INSERT scripts to
generate data.

Is This Answer Correct ?

7 Yes

3 No

What are the different ways of moving data/databases between servers and databases in SQL Server?..

Answer / javed shaikh

What are the different ways of moving data/databases
between servers and databases in SQL Server?
Answer
# 1 There are lots of options available, you have to choose
your option depending upon your requirements. Some of the
options you have are: BACKUP/RESTORE, dettaching and
attaching databases, replication, DTS, BCP, logshipping,
INSERT...SELECT, SELECT...INTO, creating INSERT scripts to
generate data.

Is This Answer Correct ?

3 Yes

0 No

What are the different ways of moving data/databases between servers and databases in SQL Server?..

Answer / venkat reddy.ravu

You can use simple backup/restore methods,attach and
detach,script based data loading,bulk DDL state ments like
select...into,insert..into,Implimenting data availability
methods like replication,log-shipping,mirroring,clusturing
etc..

Is This Answer Correct ?

0 Yes

1 No

Post New Answer