Re: Convert db Oracle 7.0 to 10g

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sun, 31 Aug 2008 17:19:04 +0200
Message-ID: <6hvr37Fo8t55U1@mid.individual.net>


On 31.08.2008 16:54, Matthias Hoys wrote:

> "Robert Klemme" <shortcutter_at_googlemail.com> wrote in message 
> news:6hvfknFo28q2U2_at_mid.individual.net...

>> 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.

> Can you copy procedures, pl/sql packages, users etc. with it ? Or only > tables ?

It won't copy stored procedure, function and trigger code as far as I know. I do not know a tool that does it. It might not be necessary though as it seems the OP just needs the data.

Kind regards

        robert Received on Sun Aug 31 2008 - 10:19:04 CDT

Original text of this message