What are the different ways of moving data/databases
between servers and databases in SQL Server?
Answer Posted / 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 |
Post New Answer View All Answers
what is the difference between a primary key and a unique key? : Sql server database administration
Write query to return all rows sql?
How to provide values to stored procedure parameters in ms sql server?
Explain what is the main purpose of having conversation group?
How many types of keys are there?
What are the indexes in sql server?
Tell me when is the update_statistics command used?
Define Joins?
What is the contrast between sql and pl/sql?
What are the tables in sql?
Can a synonym name of a table be used instead of a table name in a select statement?
How to provide login information for a new odbc dsn?
How to update muliple row in single query?
What is sql sandbox in sql server?
What is difference between rownum and row_number?