What are the different ways of moving data or databases
between servers and databases in SQL Server?
Answer Posted / pandians
Moving Data :
-------------
1. Configuring Linked Server between servers and move the
data using four part naming convension
i.e: Server.Database.Schema.Table
2. Use Export and Import wizard
3. Using SSIS or DTS Package to move data to different
database or server
4. Use three part naming convension to move data to
different database within the server/instance.
5. Using BCP to move data.
Moving Database:
----------------
1. Detach...Attach
2. Backup and Restore
3. Stop the Service
3.1 Using Alter statement to relocate the database path
3.2 Copy the files into new location
3.3 Start the Service
4. But, Moving system database except Master and Resource
can follow the above way
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is the use of recording information about current session?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Can you redefine a table online?
What is a correlated sub-query? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what functionality does oracle provide to secure sensitive information?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what are the types of connection load-balancing?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how can you initialize log miner?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What purpose does the model database server? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Which autogrowth database setting is good? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?