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
- 4492 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
How to change the data type of an existing column with "alter table" statements in ms sql server?
What do you mean by subquery?
What are the differences between ms sql server & oracle?
How to access the inserted record of an event?
What are the difference between clustered and a non-clustered index?
How can a user-defined datatype be created?
What is the difference between varchar and varchar(max) datatypes?
Tell me what is the order in which the sql query is executed?
Difference between connected and disconnected database in .net with sql server?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
When would you use a before or after trigger?
How to delete exactly duplicate records from a table?
Describe in brief authentication modes in sql server.
What is the difference between a check constraint and a rule?
What do you mean by the term 'normalization'?
