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
8554 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

how can you create a user-defined lock?

0 Answers Oracle,

Name two files used for network connection to a database.

5 Answers

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers Oracle,

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

1 Answers

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers CSC, Logica CMG,

How can we know the exact updation date of a particular database?

2 Answers Satyam,

How to start SQL Server in minimal configuration mode?

1 Answers

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

What types of replication are supported in sql server? : sql server DBA

0 Answers

what is asm?

0 Answers Oracle,

Name a tablespace automatically created when you create a database.

5 Answers

For more DB Administration Interview Questions Click Here