1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are the different ways of moving data/databases
between servers and databases in SQL Server?

Question Posted / swapna


What are the different ways of moving data/databases between servers and databases in SQL Server?..

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 ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is catalog views?

0 Answers  

Explain about the command-line tool SQLCMD?

0 Answers  

Do you know the policy based administration feature of sql server 2008?

0 Answers  

Explain what is log shipping?

0 Answers  

What is transactional replication?

0 Answers  




What types of integrity are enforced by a foreign-key constraint

1 Answers  

What is database isolation in sql server? : sql server database administration

0 Answers  

How to use group functions in the select clause in ms sql server?

0 Answers  

How do I run sql server 2014?

0 Answers  

Relational calculus is what type of language?

0 Answers   HCL,

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

What is the data type of time?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories