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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How use inner join in sql server?
How can a user-defined datatype be created?
What happens if null values are involved in datetime operations?
What will be the maximum number of indexes per table?
What is use of except clause? How does it differ from not in clause?
What is encryption key?
How to connect ms access to sql servers through odbc?
what are the different types of replication you can set up in sql server? : Sql server database administration
Explain the functionalities that views support?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What functions can a view be used to performed?
Explain relational data?
What is dimension table? : sql server analysis services, ssas
What is a fan-out query in SQL Azure?