copy tables from one server to another

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

copy tables from one server to another

Author

Topic

chih
Posting Yak Master

154 Posts

Posted - 2007-03-31 : 20:04:43

Hi everyone

I have 2 severs. I want to copy 3 tables (data, table definition, inex..ect) from sever A to sever B.

What is the best way to do it?

Please help!

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-04-01 : 03:00:30

i favor bcp.

http://msdn2.microsoft.com/en-us/library/ms162802.aspx

www.elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources