Transfer table from one SQL server to other server.

Question

Transfer table from one SQL server to other server.

Vijai-703291

SSC Eights!

Points: 959
More actions
September 26, 2008 at 3:10 am

#198908

I want to transfer the full structure(Index and Trigger) and data of one table from one server to another server. I have SQL 2005 Express edition. Please let me know how to do this.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

John H Marsh SSChampion Points: 11671 More actions · Answer 1

Hello,

Do you have DTSWizrad.exe on your machine? If so you can use that to transfer the table and data. You can then script the triggers and indexes from the original server and run those on the new server.

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

steveb. SSC-Forever Points: 46733 More actions · Answer 2

Since you are using SQL 2005 then you can create a simple SSIS package to copy a table across.

Or else scipt out the table and triggers, and insert the data with t-sql

Vijai-703291 SSC Eights! Points: 959 More actions · Answer 3

I will manage to script the table and triggers from one server to another server by using option "Script Table as" in SQL Express edition.

But how to transfer Data from one server to another server.

John H Marsh SSChampion Points: 11671 More actions · Answer 4

Hello,

Have you tried DTSWizrad.exe? I believe it is included with Express. It is the Import/Export Wizard.

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

Vijai-703291 SSC Eights! Points: 959 More actions · Answer 5

No, Express ediiton has no Import/Export Wiz. Is it possible to download DTSwizare.exe from net?

John H Marsh SSChampion Points: 11671 More actions · Answer 6

Possibly from: http://msdn.microsoft.com/en-gb/express/bb410792.aspx

www.sql.lu
SQL Server Luxembourg User Group

Vijai-703291 SSC Eights! Points: 959 More actions · Answer 7

Thanks I got it.

But it ignores Primary columns and relationship between tables. Is it possible to transfer along with it.

John H Marsh SSChampion Points: 11671 More actions · Answer 8

Hello,

May be best then to script the table as well, create it in the target server and just use DTSWizard to transfer the data.

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

Vijai-703291 SSC Eights! Points: 959 More actions · Answer 9

Ok, thx. Will do it manually.

But eager to know how to transfer just data from one server to other server using script.

John H Marsh SSChampion Points: 11671 More actions · Answer 10

Hello,

There are tools such as Redgate's Data Compare that generate SQL Scripts for data transfer.

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

jacob sebastian SSChampion Points: 11822 More actions · Answer 11

Database publishing wizard can help you: http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

Also, if you have the Management Studio of SQL Server 2008, it has an option to generate the INSERT scripts for the data of an entire table. you can run this insert scripts on the other server and populate the data.

.