What are the different ways of moving data or databases between servers and da

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

Question Posted / guest

3 Answers
8508 Views
I also Faced
E-Mail Answers

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

the process of adding a cpu in sql server is called..?

2 Answers TCS,

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers

What are the different sql server versions you have worked on? : sql server DBA

0 Answers

what do you understand by flashback feature of oracle?

0 Answers Oracle,

what is incremental checkpoint?

1 Answers CTS,

what is the difference between catalog & nocatalog?

3 Answers CSC,

What the different types of replication and why are they used? : sql server DBA

0 Answers

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers

what is the use of recording information about current session?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here