Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Programmatically Importing an Oracle Database
There is a direct load API. Look in the docs and see if that meets your
needs.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Peter Lone" <plone_at_onebox.com> wrote in message news:e77088ce.0305020153.30f18848_at_posting.google.com...Received on Fri May 02 2003 - 07:25:02 CDT
> I'm not having much luck with this. I've built an application in
> VB.NET that can use either an Oracle 8i/9i or SQL Server 2000 database
> as the administrators choice. Now the question is, how can I
> distribute the Oracle database as part of the Windows Installer server
> setup?
>
> For SQL Server, I just use SQL-DMO and VBScript - done. For Oracle, I
> know how to use the IMP and EXP utilities, but is this my only option?
> I would prefer to have the import (or some other method of database
> attachment) to be transparent, without the messy side effects of
> shelling out.
>
> Can this be done in VBScript, VB or VB.NET without having to shell out
> and spawn the ugly command prompt window?
>
> Thanks in advance for any light anyone can shed on this. Any help
> would be greatly appreciated.
>
> :Pete
![]() |
![]() |