Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different ways of moving data/databases
between servers and databases in SQL Server?
- 3 Answers
- 15041 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
How is table type constraint applied to a table?
State a few properties of relational databases?
What are sql azure firewall rules?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How efficient you are in oracle and SQL server?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is Command line parameters in PLSQL.?
What is the use of stored procedure?
What is built-in function?
What is the exact numeric data type in sql?
Can I disable or restrict ssrs export formats (rendering formats)?
Explain few examples of stored procedure over triggers?
How to create a Master database in SQL server ?
How do you rebuild an identity column?
Please differentiate between a local and a global temporary table?
