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
- 15172 Views
- HCL, I also Faced
- E-Mail Answers
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
Can we use having clause without group by?
When would you prefer to have a minimum number of indexes?
How to find out the list schema name and table name for the database?
Describe the left outer join & right outer join. : sql server database administration
How do you delete a trigger?
What are the new scripting capabilities of ssms? : sql server management studio
How to list all columns in a table using odbc_columns()?
What is difference between stored procedure and user defined function?
What is standby servers? Explain types of standby servers.
How do I find the sql server version?
Can you move the resources after pausing the node? : sql server database administration
Explain user defined views?
How to get the number of affected rows?
Which are the important points to note when multilanguage data is stored in a table?
What is a livelock?
