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 2000 Forums
 SQL Server Administration (2000)
 copy table

Author  Topic 

ratcho
Starting Member

18 Posts

Posted - 2002-09-12 : 10:28:22
Hi People,
I have a table (MyTable) in the data base (MyDataBase1) in my local SQL Server. I want to copy the same table with all the data to another data base (MyDataBase2) in another SQL server group (CompanyServer).

Please help me! How can I do this!

solart
Posting Yak Master

148 Posts

Posted - 2002-09-12 : 10:37:32
Use DTS (Data Transformation Services) or BCP (Bulk Copy Program).
Go to Top of Page

ratcho
Starting Member

18 Posts

Posted - 2002-09-12 : 11:04:31
Thanks a lot solart! It worked. You helped me a lot! Thanks!

Go to Top of Page
   

- Advertisement -