Microsoft Server 2003 to Oracle migration

350420 pts.
Tags:
Microsoft Windows Server 2003
Oracle Database
Red Hat Enterprise Linux
RHEL 5
Our organization is planning to migrate from MS Server 2003 and MySQL database server to RHEL5 and Oracle database. We currently havr 100 to 150 users.

Answer Wiki

Thanks. We'll let you know when a new response is added.

The basics are that first you’ll need to identify what the Oracle data types are that you are going to use. Then you can create the new tables with the new data types. Once that is done you’ll need to rewrite all your T/SQL code into PL/SQL code. This includes your stored procedures as well as any code which is within your applications.

If you use any autonumberiny features of MySQL you’ll need to convert these into Oracle sequences.

Then you can start importing your data from MySQL to Oracle.

This is not an easy task at all. Depending on how large the application is that you are trying to move it will take weeks or months. Very large applications can take years to migrate as they are a moving target with new features and bugs being fixed in the old platform which means that those features need to be moved into that new platform.

Then you’ll need to get someone up to speed on Oracle system maintenance to handle maintening the Oracle database. Managing an Oracle database is nothing like managing a MySQL database (or any other database for that matter).

There isn’t enough information provided to suggest a hardware solution other than to say that any Dell, HP, or IBM server should be fine provided that it has enough CPU, RAM and Disk IO available to service the applications needs.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ITKE
    Additional information: Could you give me suggestions for the hardware configuration requirements? (i.e which hardware server is suitable for running RHEL5 as OS and oracle database )
    350,420 pointsBadges:
    report
  • Denny Cherry
    That all depends on what the IO, memory and CPU requirements are for your database. Sun, Dell and HP all have a variety of servers many of which would sit the bill depending on your requirements.
    66,185 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following