Re: Convert db Oracle 7.0 to 10g


"borntoride" <joleveille@xxxxxxxxx> wrote in message
news:b392c720-ab60-45d3-80d3-dc5fba9bd5b1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On 31 août, 12:20, "gym dot scuba dot kennedy at gmail"
<kenned...@xxxxxxxxxxx> wrote:
"Robert Klemme" <shortcut...@xxxxxxxxxxxxxx> wrote in message

news:6hvfknFo28q2U2@xxxxxxxxxxxxxxxxxxxxx> On 31.08.2008 08:08, borntoride
wrote:

Hi ! Thanks a lot for your time. I need to transfer data from a
database in Oracle 7.0 to a new accounting software. From this new
accounting software, we can import data from many type of DB, but not
from Oracle....

A fairly easy solution might be to use MS SQL Server 2k's DTS. With that
you can pretty easy copy a whole schema or even DB IIRC to another
database. All you need is an ODBC driver.

Kind regards

robert

Reading between the lines of what the OP needs it seems that he is trying
to
put data from an old system into a new system. It is likely that the table
names and definitions are different.
Jim

But my main problem is to find the ODBC for the Oracle 7.0 version...
I found somes for 7.3, 8, 9, 10, etc but anything for 7.0 ...
Why bother doing that, just use sqlplus and spool the output to csv files.
Jim


.

Relevant Pages

  • RE: ORACLE DRIVER
    ... Subject: ORACLE DRIVER ... DBI - is the perl module to handle all the request of the database, ... So is there any free Oracle ODBC driver for Linux? ...
    (perl.dbi.users)
  • MS ODBC w/UTF8 & Oracle 10g database NULLS char fields > 1024 char
    ... IF fields over 1024 characters in size are edited using a record set: ... AND that Oracle 10g database has been set to use UTF8 encoding ... If you use the Oracle ODBC driver rather than the MS ODBC driver. ...
    (microsoft.public.data.odbc)
  • Re: Convert db Oracle 7.0 to 10g
    ... database in Oracle 7.0 to a new accounting software. ... A fairly easy solution might be to use MS SQL Server 2k's DTS. ... With that you can pretty easy copy a whole schema or even DB IIRC to another database. ...
    (comp.databases.oracle.server)
  • Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 Serve
    ... I am using the Microsoft's ODBC Driver for Oracle ... >string cannot be found in the tnsname.ora file. ... >the database using a simple SQL query. ...
    (microsoft.public.inetserver.iis)
  • Re: Convert db Oracle 7.0 to 10g
    ... database in Oracle 7.0 to a new accounting software. ... A fairly easy solution might be to use MS SQL Server 2k's DTS. ...
    (comp.databases.oracle.server)