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

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

More SQL Server Interview Questions

How do you clear a log file?

0 Answers  


What is temporary stored procedure?

0 Answers  


What are the different subsets of sql?

0 Answers  


How to delete an attribute from the emp table

4 Answers  


What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,






Will the writetext statement activate a trigger?

0 Answers  


How to convert character strings into numeric values?

0 Answers  


Does hive support indexing?

0 Answers  


Can you explain what is the use of custom fields in report?

0 Answers  


Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  


How to choose all records from the table?

0 Answers  


What is GUID in sql server?

0 Answers   BirlaSoft,


Categories