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
- 4568 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are the pros and cons of creating extended stored procedures?
What do you mean by an execution plan? Why is it used? How would you view it?
What is molap and its advantage? : sql server analysis services, ssas
what protocol both networks use? : Sql server database administration
In what sequence sql statement is processed?
How to determine the service pack currently installed on SQL Server?
What is similarity and difference between truncate and delete in sql?
What is 2nf in normalization?
what is maximum size of temp db?
Explain left outer join and right outer join?
How to run queries with sql server management studio express?
How can you see what type of locks used?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
