Copying table from DB to DB in VB

Copying table from DB to DB in VB

Post by Ray Roberso » Sun, 18 Nov 2001 05:28:57

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.



Copying table from DB to DB in VB

Post by Luke Zhang [M » Sun, 18 Nov 2001 15:17:29

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


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


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

How can you copy from one database table to another database table.  I have
two databases that I like to transfer a copy of the entire table of.  Is
there a fast or easy way to do this?

If you know of a way, can you email me any examples or tell how to do it?

PS. I'm using RDO as my database connection method
Chris Barger
L3 Communications - Satellite Transmission System
Digital Systems Division
Voice (516) 272-5796

2. Q: Using a global repeating field to populate related fields

3. how to copy a db to another db table by table and field by field

4. US-NY-New York City - Web Designer (11367)

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

6. date intervals

7. How to copy table from DB to DB?

8. : LONG VARCHAR indexing ?

9. Copying Tables from one DB to another DB

10. copy contents of table to another table in different DB. (Same Server)

11. Copy DB Table to new Access Table

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

13. HELP - using DTS to copy data from sql db to sql db