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 |
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What is pivot and unpivot?
How do I install only the client tools of sql server 2000?
How can you insert values in multiple rows using one Insert statement?
0 Answers Flextronics, Thomson Reuters, Virtusa,
what's the information that can be stored inside a bit column? : Sql server database administration
Are connections to sql server encrypted?
What is dirty page?
How to use the inserted and deleted pseudo tables?
When we should use and scope of @@identity?
Explain nested trigger in sql?
What structure can you implement for the database to speed up table reads?
What are the triggers in sql?