What are the different ways of moving data/databases
between servers and databases in SQL Server?
- 3 Answers
- 15301 Views
- HCL, I also Faced
- E-Mail Answers
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 acid mean in sql server?
How do I create a trace in sql server?
What are the source of constraints?
How do I find the sql server version?
How do I find query history in sql server?
What is the difference between for xml raw and for xml auto?
Can one drop a column from a table?
What are different types of constraints?
How to remove duplicate rows from table except one?
what is the difference between openrowset and openquery?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How can we solve concurrency problems?
When should you use an instead of trigger?
What are the different subsets of sql?
How can you append an identity column to a temporary table?
