Copying table from one database to another one

Copying table from one database to another one

Post by Boris Makhli » Sat, 13 Jan 1996 04:00:00



Hi!
I want to be able to copy table from one database to another.
How do I do that?
Thanks a lot!
-Boris
 
 
 

Copying table from one database to another one

Post by Pablo Sanch » Sat, 13 Jan 1996 04:00:00



> Hi!
> I want to be able to copy table from one database to another.
> How do I do that?
> Thanks a lot!

Hey Boris,

If yur copying on the same SQL server:

   insert new_db..a_table select old_db..a_table

remember to set sp_dboptions on "new_db" to "select into" and "trunc"

If yur copying across SQL servers then yur best bet is to bcp the
data out and bcp it in.

For more information checkout Sybooks:

    http://reality.sgi.com/employees/pablo_corp/Sybase_FAQ

Pablo Sanchez              | Ph # (415) 933.3812        Fax # (415) 933.2821

===============================================================================
"I am accountable for my actions."  http://reality.sgi.com/employees/pablo_corp
   - pablo