1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What are the different ways of moving data or databases
between servers and databases in SQL Server?

Question Posted / guest

Answers were Sorted based on User's Feedback



What are the different ways of moving data or databases between servers and databases in SQL Serve..

Answer / 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

What are the different ways of moving data or databases between servers and databases in SQL Serve..

Answer / santo

export/import...attach/detach...DTS....backup/restore!

Is This Answer Correct ?    2 Yes 1 No

What are the different ways of moving data or databases between servers and databases in SQL Serve..

Answer / monal

BCP (BULK COPY PROGRAM)

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB Administration Interview Questions

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1 Answers  

How do you tell what your machine name is and what is its IP address?

4 Answers  

Which autogrowth database setting is good? : sql server DBA

1 Answers  

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?

1 Answers  

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

What are the different types of indexes available in sql server? : sql server DBA

1 Answers  

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

For more DB Administration Interview Questions Click Here
Categories