What are the different ways of moving data/databases
between servers and databases in SQL Server?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How do you clear a log file?
What is temporary stored procedure?
What are the different subsets of sql?
How to delete an attribute from the emp table
What is difference between stored procedure & function?
3 Answers CarrizalSoft Technologies, Concept Infoway, TATA,
Will the writetext statement activate a trigger?
How to convert character strings into numeric values?
Does hive support indexing?
Can you explain what is the use of custom fields in report?
Is it possible for a stored procedure to call itself or recursive stored procedure?
How to choose all records from the table?
What is GUID in sql server?