What are the different ways of moving data/databases
between servers and databases in SQL Server?
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 |
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?
Can an entity have two primary keys?
When we should use @@error?
What is difference between delete and truncate commands?
What is purpose of normalization?
What are the features of Embedded SQL
How can sql injection be stopped? : sql server security
what is a deadlock? : Sql server database administration
What are the components of dbms?
How can you know if the row fetched from cursor is still valid in underlying table?
What is the recursive stored procedure in sql server?
What are the general features of sql server management studio? : sql server management studio
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)