Re: Convert db Oracle 7.0 to 10g
Date: Sun, 31 Aug 2008 17:19:04 +0200
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.
robert Received on Sun Aug 31 2008 - 10:19:04 CDT