Export SQL db table & import on another machine

[furry_cup]

Can someone point me in the right direction to export a database table and its data from one machine to another?

I have several that need moving form a local server to a preview area.

I am using MS SQL Server 2005

Thnks!

 

[KDF]

Just do a backup then restore to the new server ? or is that too simple lol

 

[furry_cup]

i only want a couple of tables from a databse, if i do a backup and restore, wont this restore and overwrite the whole existing DB?

I am new to this!!!!

 

[Longy]

Just use the management tool - connect to the SQL instance - find your database then just use the export wizard (right click the database and click export).

 

[Longy]

I'm sure you can then choose the tables you need.

 

[cava83]

Certainly can.

I'm sure you can then choose the tables you need.

 

[safe9998]

...dts, well SSIS in sql 2005