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
- 14882 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
what is the difference between openrowset and openquery?
How to use union to merge outputs from two queries together in ms sql server?
Why main is user defined function?
List all types of constraints in sql server?
What is difference between commit and rollback when used in transactions?
Can two tables have the same primary key?
What is merge?
Explain what are magic tables in sql server?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Detail about the hardware which is supported by SQL server?
Explain about Joins?
Write a query for primary key constraint with identity key word?
What is the data type of time?
How to populate a table in sql server?
What is SQL Server?
