Solved

Copy tables between servers

Posted on 2007-04-06
9
975 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
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.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.

830 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