What are the different ways of moving data/databases
between servers and databases in SQL Server?
Answer Posted / 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 |
Post New Answer View All Answers
What is parameterized reports in ssrs ?
Name few of the dcl commands in sql?
How to create a stored procedure with a statement block in ms sql server?
How to resolve the orphan use problem? : sql server security
Mention the differences between having and where clause.
What are different types of table joins?
Explain unique key in sql server?
What is query processing?
what is the system function to get current user's user id? : Sql server database administration
What is a sql join?
Difference between uniqe index and uniqe constraint?
What are the properties of primary key?
How do I create an extended event in sql server?
Do you know what is a with(nolock)?
What is inner join? Explain with an example?