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 tables from one server to oder

Author  Topic 

niki4ko
Starting Member

10 Posts

Posted - 2007-07-08 : 21:07:42
How can i copy Tables from mssql server from my computer to oder /from my server to oder/. The Data Bases are ready created i must put only the Tables to oder DB. Please can you tell me how?

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-07-09 : 00:31:36
Do you need to move only the structure of the tables or you need the data too? If you just need the objects, you can script them out and compile them on the target server.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

niki4ko
Starting Member

10 Posts

Posted - 2007-07-09 : 03:16:41
I must to move all that i have in the first database. All tables
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-07-09 : 04:16:49
If you want tables with data then do backup at source and restore it at target server

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

niki4ko
Starting Member

10 Posts

Posted - 2007-07-10 : 13:41:55
Thank you men! :)
Go to Top of Page
   

- Advertisement -