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
- 15040 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
How can delete duplicate records in cte in sql server?
Which is better statement or preparedstatement?
What are the different types of replication are there in sql server 2000?
What to perform pattern match with the like operator?
What is tabulation?
What is sql or structured query language?
Define Wed Edition in SQL Azure?
How many database files are there in sql server 2000?what are they?
What is a trace frag? Where do we use it?
Which table keeps information about stored procedures?
What is the cpu pressure?
In which tcp/ip port does sql server run? Can it be changed?
What have included columns when we talk about sql server indexing?
What is a virtual table in sql?
What are the steps you will take to improve the performance of a poor performing query?
