Advanced Authentication DB migration from Oracle to MS SQL

[Camil Huric]

Hello
Does anyone has experience in migrating Advanced Authentication DB from Oracle to MS SQL?

What could be major challenge?

Thank you

Camil

[Redentor Del Rosario]

1. Database Schema Creation
2. Export Oracle Schema
3. Transfer the dump files 
4. Import Oracle Schema into MS SQL Server 
5. Data Conversion 
6. Test and verify 

Challenges 

A. Data type mapping 

B. Syntax differences

C. Schema and object name conflicts

D. Differences in built-in functions 

Red

[mustapha.benmahbous]

Hello

Did you consider a new deployment with MS SQL as the AA Repository so the schema will be fully supported, fresh and clean. All you need then is to import/create your Data. That alternate method depends of your deployment of course.

Regards.