Re: Programmatically Importing an Oracle Database

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2 May 2003 07:47:22 -0700
Message-ID: <a20d28ee.0305020647.759ec6ce@posting.google.com>

plone_at_onebox.com (Peter Lone) wrote in message news:<e77088ce.0305020153.30f18848_at_posting.google.com>...
> 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

> Can this be done in VBScript, VB or VB.NET without having to shell out
> and spawn the ugly command prompt window?
>

NO!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Try to learn the differences between Oracle and your Microsux toys.

Sybrand Bakker
Senior Oracle DBA Received on Fri May 02 2003 - 09:47:22 CDT