Solved

Copy tables between servers

Posted on 2007-04-06
9
973 Views
Last Modified: 2010-08-05
How can we copy a table from one server to another?
 
thank you.
0
Comment
Question by:epmo
  • 3
  • 2
  • 2
9 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 18868362
You can either link the servers together or use OPENROWSET or OPENDATASOURCE or using DTS.
0
 

Author Comment

by:epmo
ID: 18868374
do you have a sample of OPENROWSET or OPENDATASOURCE ?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 18868406
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 250 total points
ID: 18868409
Oops I see you are using SQL Server 2005, so it should be:

OPENROWSET
http://msdn2.microsoft.com/en-us/library/ms190312.aspx

OPENDATASOURCE
http://msdn2.microsoft.com/en-us/library/ms179856.aspx
0
 
LVL 8

Expert Comment

by:MOA81
ID: 18869109
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
0
 

Author Comment

by:epmo
ID: 18873644
Interesting we do not have "Import data" under Task. SQL server studio express 2005
0
 
LVL 8

Assisted Solution

by:MOA81
MOA81 earned 250 total points
ID: 18874339
SQL Server Studio express 2005 is a small engine not all features are there

or

either no sufficient rights has been given to you
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question