RE: Generic DBI question about backups

Thanks for all the responses.

Looks like I may have to go with a CSV type solution.

Too bad that keeping the hardware that Oracle is on isn't an option for
me.

Curtis

-----Original Message-----
From: Rutherdale, Will [mailto:Rutherw@xxxxxxxxx]
Sent: Thursday, June 19, 2008 2:23 PM
To: Curtis Leach
Cc: dbi-users@xxxxxxxx
Subject: RE: Generic DBI question about backups

Maybe I'm missing something here, but isn't this simply a matter of
using DBD::CSV? You could open two dbi handles, one to your existing
Oracle db and the other to a csv db. Read from the one, write to the
other. When you get the new schema set up on the new platform, do the
same thing in the reverse direction.

Of course you would have to review your schema to make sure all your
column definitions are simple universal data types supported by all
platforms. If not then there would be a risk of information loss in
some cases. You could treat such columns as special cases if necessary
and review your CSV data carefully before chucking the oracle version.

Then again you probably wouldn't want to chuck the Oracle db for a while
anyway just as a precaution, until you are convinced your app still
runs. That might in fact make the intermediate CSV representation
unnecessary, but as usual there's more than one way to do it.

-Will


-----Original Message-----
From: Curtis Leach [mailto:cleach@xxxxxxxxxxx]
Sent: Thursday 19 June 2008 14:54
To: gonzales@xxxxxxxxxxxxxx
Cc: dbi-users@xxxxxxxx
Subject: RE: Generic DBI question about backups

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.

Curtis




- - - - - Cisco
- - - - -
This e-mail and any attachments may contain information which is
confidential, proprietary, privileged or otherwise protected by law. The
information is solely intended for the named addressee (or a person
responsible for delivering it to the addressee). If you are not the
intended recipient of this message, you are not authorized to read,
print, retain, copy or disseminate this message or any part of it. If
you have received this e-mail in error, please notify the sender
immediately by return e-mail and delete it from your computer.



.

Relevant Pages

  • Re: Converting oracle tables data into csv on client computer
    ... >(Oracle 9i on solaris). ... But, if that fails, try asktom - I saw an article about producing csv ... 1) How can we manage this using sql? ... The convertion should be done on client computer and ...
    (comp.databases.oracle.server)
  • Re: Importing lg csv file into Access tbl
    ... It just when I try to export the data out of the tool into .csv ... I don't know much about Oracle specifically, but what I ususally do when I ... get the query working correctly there, then copy the SQL and paste it into ...
    (microsoft.public.access.externaldata)
  • Re: Importing lg csv file into Access tbl
    ... I really don't want to link to the tables in the Oracle dB, ... My output data looks ... but when I try to save my results as .CSV so I can imported into Access ... some of the data get split into multiple columns which cause the data to ...
    (microsoft.public.access.externaldata)
  • Importing lg csv file into Access tbl
    ... I'm trying to import data from Oracle into Access. ... that help me run my SQL and it will show the output. ... some of the data get split into multiple columns which cause the data to ... If I try to open up the CSV ...
    (microsoft.public.access.externaldata)