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?
- 1 Answers
- 4515 Views
- 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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the core components of SSRS?
What is the chart in report?
What is the difference between drop table and truncate table?
How to achieve Paging of records in SQL SERVER?
How to get a list of columns in a view using the "sp_columns" stored procedure?
Explain how to maintain a fill factor in existing indexes?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
In which sql server version report builder introduced?
What is a linked server in sql server?
Explain an automatic checkpoint
What are the purposes and advantages stored procedure?
what is isolation level at dead lock?
Explain something about security and SQL Azure?
What are the different editions available in sql server 2000?
How to store and query spatial data?
