Copy Table

how to copy one table from one database to another on different servers?

March 26th, 2014 2:39pm

You may use Export/Import Wizard in SQL Server.

Ref: http://msdn.microsoft.com/en-us/library/ms140052.aspx

Free Windows Admin Tool Kit Click here and download it now
March 26th, 2014 2:44pm

Just the table design or including the data?
March 26th, 2014 3:02pm

Hi,

You can use linked servers. Add a link server and use the following query:

select * into [target_table] from [source_server].[source_database].[dbo].[source_table]

For more information on linked servers, please refer http://msdn.microsoft.com/en-us/library/ff772782.aspx

-Vatsalya

Free Windows Admin Tool Kit Click here and download it now
March 27th, 2014 2:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics