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
- 14887 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 to create a simple user defined function in ms sql server?
can we have a nested transaction? : Sql server database administration
What is partition index in sql server?
Write a query for primary key constraint with identity key word?
between cast and convert which function would you prefer and why?
What is mscorsvw.exe - process - microsoft .net framework ngen?
What are the characteristics of modern DBMS?
Do you know what are the properties of the relational tables?
What is the temp table?
How to filter out duplications in the returning rows in ms sql server?
Does union all remove duplicates?
Explain rdbms?
What do you understand by integration services in sql server?
What is scan table/view and seek table/view when its occurs? : sql server database administration
How can you insert null values in a column while inserting the data?
