Copying table from DB to DB in VB 
Author Message
 Copying table from DB to DB in VB

Researching the best way to copy a table from one DB (SQL Server 2000) to
another DB. Straight copy.

Can it be done within a SP?

Any assistance would be appreciated.

Thanks in advance.

Ray.



Wed, 05 May 2004 04:28:57 GMT  
 Copying table from DB to DB in VB
Hi Ray,

I suggest you can consider to create DTS package or a linked server in the
SQL sevrer. That will be easier to implement and mainten than a programming
way

Luke

(This posting is provided ?AS IS?, with no warranties, and confers no
rights.)



Wed, 05 May 2004 14:17:29 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. How to copying from one DB table to another DB table

2. Copying Tables from one DB to another DB

3. How to copy table from DB to DB?

4. copy runtime a table from db a to db b

5. Copy table from one db to another db with vb5

6. Copy Access/Oracle table from one DB to another DB.

7. Copy table schema and data from one DB to another DB

8. MS Access DB - Copy Table A from Database A to Table A Database B

9. Copying data from one DB to another DB

10. Copying DB over existing DB connected to DataEnvironment

11. Copy Data Structures no data DB to DB

12. Copy Recordset from one Db to a different Db

 

 
Powered by phpBB® Forum Software