Link to home
Create AccountLog in
Avatar of wangsasoft
wangsasoft

asked on

Connect Oracle 7 running on Solaris

Hi Experts, I'm quite new with Oracle database. I have developed a new HR system for my client by using PHP with Oracle 11g. However, my client had their old HR system with running on Solaris with Oracle 7 database. I have to migrate the data from old Oracle 7 database to the new one. I've tried using Oracle SQL Developer running on my Windows 7 notebook to connect to it via network but cannot. Do you have any recommendations on how to connect to Oracle 7, accessing the data and migrate them to Oracle 11g. Thank you very much.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I don't think you will find a GUI tool that will connect to both Oracle7 and Oracle11.  I agree that if you export all (or parts) of an Oracle7 database you should be able to import that into an Oracle11 database.
If everything else fails and the database is small, you could dump all the tables to csv files.
I have attached a script I found may Many MANY years ago that could help you (with a little bit of tweeking) automate the process.
Good luck!
:p
dump.sql
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.