What are the different ways of moving data/databases
between servers and databases in SQL Server?
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is cursor in ms sql server?
What is the partitioning method?
What is store procedure? When do you use?
What is nolock?
What are the new features are introduced in sql server 2012 reporting services?
How to provide column names in insert statements in ms sql server?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What is replication and database mirroring?
How can you manage sql azure security?
can an order by clause be used in a creation of a view?
what is unique and xaml nonclustered index
Explain what is sql server english query?
How can we delete Duplicate row in table?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.