u can use the bcp utility that will be faster than DTS..
-Original Message-
Sent: Friday, May 31, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L
EXPORT the database.
-Mensaje original-
De: Gene Sais [mailto:[EMAIL PROTECTED]]
Enviado el: Viernes, 31 de Mayo de 2002 1
EXPORT the database.
-Mensaje original-
De: Gene Sais [mailto:[EMAIL PROTECTED]]
Enviado el: Viernes, 31 de Mayo de 2002 15:51
Para: Multiple recipients of list ORACLE-L
Asunto: SQLServer copy table from 1 db to another
Is there a way to copy a table in 1 sqlserver db to another, simila
command line bcp
bcp out
bcp in
-Joe
--- Gene Sais <[EMAIL PROTECTED]> wrote:
> Is there a way to copy a table in 1 sqlserver db to another,
> similar to Oracle's exp/imp, or create tablle as select.., etc. It
> appears the only way you can do it is thru DTS packages.
>
>
> --
> Please see
