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
 Import/Export (DTS) and Replication (2000)
 Copying Data Structures

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-08 : 09:43:43
Matthew writes "I have several related tables in a monster of a DB (Its a system to compare medical aid schemes right down to the benfit payout level & other natiness - you can imagine the size...) and I'm stuck trying to replicate an entre structure of data to a different parent. It would be no problem to loop and duplicate in code (normally) until you realise that some of the tables I'm trying to copy are threaded internally - I'm just wondering if sql has any built in method to bulk copy such tables."

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2002-02-08 : 10:39:27
Have you tried bcp ? DTS ? See Books-on-line. This is an easy thing to do.

Go to Top of Page
   

- Advertisement -