Help needed for Axapta data migration

subhaster
Member Posts: 64
Hi,
Can anyone please help me about how to proceed for data migration in Axapta? My client is currently using Oracle 9i, this is required to get updated to SQL SERVER 2005.
Can anyone please help me about how to proceed for data migration in Axapta? My client is currently using Oracle 9i, this is required to get updated to SQL SERVER 2005.
Subhasish Chakraborty,
Systems Analyst,
MBS Dynamics.
Systems Analyst,
MBS Dynamics.
0
Comments
-
You've got a tough job.
Which version of Dynamics are you running on Oracle?
What tables have been modified in Dynamics?
What I would do:
Clean install of Dynamics Ax 4 SP1 on a test server
upgrade to SP2 + latest DIS layer for your country
Create a project for your "data" related changes
(new base enums, extended datatypes, table modifications)
after making all the changes verify the new SQL server tables have the same fields as the Oracle tables.
Here comes the tricky part
Create a job in in your datamigration project that establishes an ODBC connection to the Oracle database. Create a query to open one of the tables (you will need to create a seperate job for each of the tables you want to migrate). Map the fields returned from the query to the fields in your new application table. call the validate write method on the destination table and if all is well then call the write method.
Its not trivial, its not the only way - you do need to watch for right justified text fields and modify them to be left justified before inserting them in the destination table. Read all of the upgrade documentation you can find and understand it.0 -
Hi,
currently I am using Ax 3.0 with Oracle 9i database. Does any one have any articles or refer any link from where I can get help regarding this?Subhasish Chakraborty,
Systems Analyst,
MBS Dynamics.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions