I am looking to convert my SQL Server 2014 Express Database to Azure SQL Database.
My SQL Server database was automatically converted from Oracle a number of years ago, and needs the sysdb database (provided by Microsoft) as a dependency to provide user defined functions that emulate Oracle functions.
I ran the Data Migration Assistant to check for compatibility, and the main problem seems to be that "Cross-database references not supported in Azure SQL Database". This relates to the dependency on the sysdb database.
The two recommendations of the Data Migration Assistant are either:
- Move the dependent datasets from other databases into the database that is being migrated. OR
- Migrate the dependent database(s) to Azure and use 'Elastic Database Query' functionality to query across Azure SQL databases.
I would eventually like to get rid of all Oracle related references, although I do not have the resources to do that right now. I feel that the best thing to do is to merge the sysdb database with my database (so that it would then work with Azure SQL Database) and then as a long-term project slowly rid myself of Oracle dependencies.
Any ideas about how to achieve this? (Or a better idea?)