Install, Upgrades & Change Mgmt - JDE1 (MOSC)

MOSC Banner

JDE Upgrade having different Databases for source & target

edited Mar 16, 2015 10:35PM in Install, Upgrades & Change Mgmt - JDE1 (MOSC) 4 commentsAnswered

We are doing Upgrade from E900 to E910.

E900 has Oracle 11g database while E910 has SQL 2012 database (both on Windows 2008 R2).

We know that using R98403, we can move the tables from Oracle to SQL database (like for TESTDTA, TESTCTL etc)

The reason is :  JDE Database Datasource points to one database at a time.

Example : Business Data - TEST points to TESTDTA in orcl (name of oracle database)

We want to know is there any other way to move data (tables) from Oracle (E900 DB) to SQL (E910 DB) without affecting the original table specification.

Tagged:

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

E1 Inst & Change Mgmt Tags

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