asked on

Copy tables between servers

How can we copy a table from one server to another?

thank you.

Anthony Perkins

You can either link the servers together or use OPENROWSET or OPENDATASOURCE or using DTS.

epmo

ASKER

do you have a sample of OPENROWSET or OPENDATASOURCE ?

Anthony Perkins

Sure. From BOL:

OPENROWSET
http://msdn2.microsoft.com/en-us/library/aa276850(SQL.80).aspx

OPENDATASOURCE
http://msdn2.microsoft.com/en-us/library/aa276845(SQL.80).aspx

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MOA81

Use the Data Export/Import wizard:

Right click on the destination database choose "All Tasks"
then choose "Import data" at this point a wizard screen will pop up
screen 1: click next
screen 2:choose the data source, database and click next
screen 3:choose destination which and click next
screen 4: choose the first option "Copy table(s) and view(s) from the source database"
screen 5: choose the tables that you want to copy
screen 6: click next to finish the wizard and you are done

Note: if you want to save this as a DTS package
in the last screen choose save as DTS package

epmo

ASKER

Interesting we do not have "Import data" under Task. SQL server studio express 2005

SOLUTION

MOA81

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial