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
- 4498 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 Surrogate key?and wt is the diff between Primary key and Surrogate Key?
how to rest identity columns in sql server
What do you think of this implementation? Can this be implemented better?
what is sql injection in sql server?
What are the pros and cons of creating extended stored procedures?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
How do I find the sql server database version?
What are explicit and implicit transactions?
What according to you is the difference between mysql and sql server performance?
how to get the automatic backup of the database in the sql server
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Can we write a distributed query and get some data which is located on other server and oracle database?
-
Oracle (3259) - 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)
