Solved

Copy tables between servers

Posted on 2007-04-06
9
980 Views
Last Modified: 2010-08-05
How can we copy a table from one server to another?
 
thank you.
0
Comment
Question by:epmo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

617 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