What are the different ways of moving data/databases
between servers and databases in SQL Server?
- 1 Answers
- 3728 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 is the new security features added in sql server 2016? : sql server security
What are the types of indexing?
What is the difference between a view and a stored procedure?
What is an etl file?
How to set database to be read_only in ms sql server?
How to stop log file growing too big?
Explain triggers?
What is Self Join?
What is sql server transaction log file?
Can I remove the default constraint columns in SQL SERVER?
in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
