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


Please Help Members By Posting Answers For Below Questions

What would you do with an "in-doubt" distributed transaction?

1683


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1750


What are statistics, under what circumstances they go out of date, how do you update them?

2039


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1962


What is the default fill factor value? : sql server DBA

856


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2136


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1775


when does an alert gets signaled?

804


What is replication? : sql server DBA

885


how can you communicate with operating system files from oracle?

817


what is the diffrence between core dba and apps dba?

2339


Why does Oracle not permit the use of PCTUSED with indexes?

2633


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2220


What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

785


What are the different ways you can create databases in sql server? : sql server DBA

853