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?
- 3 Answers
- 14886 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 ? | 7 Yes | 3 No |
Answer / javed shaikh
What are the different ways of moving data/databases
between servers and databases in SQL Server?
Answer
# 1 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 ? | 3 Yes | 0 No |
Answer / venkat reddy.ravu
You can use simple backup/restore methods,attach and
detach,script based data loading,bulk DDL state ments like
select...into,insert..into,Implimenting data availability
methods like replication,log-shipping,mirroring,clusturing
etc..
| Is This Answer Correct ? | 0 Yes | 1 No |
What is trigger explain with program?
How to insert and update data into a table with "insert" and "update" statements?
Do you know what is fill factor and pad index?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
Explain syntax for viewing, dropping and disabling triggers?
What is sql server programming?
How to join two tables in a single query in ms sql server?
What is self contained multi valued query?
Explain various data region available in ssrs with their use?
What are the essential components of sql server service broker?
How to test values returned by a subquery with the in operator?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
-
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)
