GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

sql 2000 to oracle database

edited Jul 25, 2014 5:02AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered

Hi

Is there any document/ guide detailing the steps to configure replication between sql 2000 database to oracle 11gr2 database.   I converted sql 2000 database structure to oracle 11gr2 structure using sql*developer migration workbench (no data being moved).  But need assistance how to proceed from this point.  Also since data types are different in sql & oracle do we need to use "defgen" utlility for all of the tables present in sql 2000.  Request you to please help us in this regard..

Regards

Bhanu Pratap M

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center