On Thu, Jun 19, 2008 at 11:54 AM, Curtis Leach <[EMAIL PROTECTED]> wrote:
> My big problem is that the new database hasn't been selected yet & the > our only Oracle database will be gone by the time one is selected. > Which was the reason for the need of a database independent solution. I > won't be able to load it back into Oracle again for a 2nd attempt. > I would recommend using a consistent text backup format. For example, you might use a delimited format (each field printed as text, separated by a delimiter such as '|', with an escape scheme for handling newlines, pipe symbols and escapes (eg, backslash-backslash for a single backslash; backslash-pipe for a single pipe, backslash-newline for a newline). Or you could go with the CSV format that others have suggested - bearing in mind that CSV is not all that well defined (there are multiple possible variants, and even different MS products handle the odd-ball cases differently). At the same time, dump the schema in text - presumably Oracle has tools to assist in that, but failing that, you can either use the DBI and DBD::Oracle metadata facilities, or learn how to interrogate the Oracle system catalog for the information. With the schema and plain text data files, you can get the data into any other DBMS. Informix provides standard tools DB-Export and DB-Import that use the Informix UNLOAD format (basically, pipe-delimited, backslash-escaped data files) for the data and an SQL file (actually created by the code from another utility, DB-Schema) for the SQL. The output from DB-Export is stylized and comprehensible to DB-Import. With Informix, you can also use the same format for ad hoc unload and load commands too - transferring single tables rather than whole databases. > > Curtis > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2008 1:33 PM > To: Curtis Leach > Cc: dbi-users@perl.org > Subject: Re: Generic DBI question about backups > > I guess I'd be more concerned initially with ensuring the datatype > mappings are identical or in the 'to-be' database, the ingress is valid. > > Has that been considered yet? > > On Thu, 19 Jun 2008, Curtis Leach wrote: > > > Does anyone know of a module that would backup an Oracle database in a > > > database independent way? > > > > We are decommissioning our only Oracle database & we would like to be > > able to preserve it's contents so that it can be reloaded into another > > > database at a later date. Such as Windows SQL Server or Informix. > > > > But all Oracle backup tools use proprietary formats. > > > > > > Curtis > > > > > > -- > Louis Gonzales > [EMAIL PROTECTED] > http://www.linuxlouis.net > > > > -- Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h> Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused."
