Dynamics AX 2009 Oracle to SQL Server Migration

Data Migration

The process of data migration from Oracle to SQL Server is relatively straightforward once the target instance is fully installed and configured. The Data Migration tool is graphical in nature and intuitive to use and the process of migration on an up to date server should take approximately one hour.

  1. Stop the AOS services on the source and target instances.

  2. Open the Migration Tool and select the version of Dynamics AX being migrated – in this case AX 2009.Oracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics A

  3. Review the Pre-Migration checklist and ensure all the requirements have been met.Oracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics A

  4. Enter the connection details of the source Oracle database and test the connectionOracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics A

  5. Enter the connection details of the target SQL Server database and test the connection.Oracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics A

  6. Validate the target schema against the source schema.Oracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics A

  7. A list of missing tables will be produced. This is expected behaviour and addresses tables that are not to be migrated, for example Oracle temporary tables and tables relating to disused or unlicensed AX modules.Oracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics AExclude tables

  8. Note that Schema Validation re-runs after you have selected to exclude tables.

  9. Schema validation may highlight missing columns that will need to be manually created in the target database. If a missing column is discovered in schema validation, it is necessary to step back and re-validate the entire schema in order for the addition of the column to be recognised by the migration tool. Merely adding the column and running the “revalidate” option will not detect the new column without stepping back a step.Oracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics A

  10. Check the list of tables that will be excluded from the migration. Ensure the list is as expected.Oracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics A

  11. Set the number of threads (depending on the number of CPU cores available) and the number of records to be processed in each batch. Click “migrate” to start the migration.Oracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics AData migration

  12. Once the migration completes, review the migration summary and validate the table row counts. Check the list of partially migrated tables and ensure no tables were only partially migrated.Oracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics AOracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics A

  13. The migrated data can be further reviewed on a table by table basis.Oracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics A

  14. Close the migration tool and restart the source and target AOS services.Oracle to Microsoft SQL Server Data Migration Assistant for Microsoft Dynamics A

Advertisements
Dynamics AX 2009 Oracle to SQL Server Migration

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s