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.
by Ray Roberso » Sun, 18 Nov 2001 05:28:57
Can it be done within a SP?
Any assistance would be appreciated.
Thanks in advance.
Ray.
by Luke Zhang [M » Sun, 18 Nov 2001 15:17:29
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.)
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
7. How to copy table from DB to DB?
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