This blog covers the basic steps in migrating a SQL Server 2016 database to Autonomous Database 19c via SQL Developer online migration tool.
What I used:
- SQL Server 2016 running on a Windows server in OCI as the source
- Autonomous Database on Shared infrastructure as the target
- SQL Developer 21.4.3 running on the same server as SQL Server
- SQL Developer documentation
Basic steps all within SQL Developer:
- create connections to the source (SQL Server 2016) and target (Autonomous Database)
- Setup migration repository, I used a different schema within the target Autonomous Database
- capture source information
- review convert/translate options for meta info, procedures, triggers, views, ...
- create target
- submit the job to create the DDL and move the data
Almost always you will use offline in which SQL Developer creates the scripts which you will use to move a production database. Online is nice for testing.
After creating connections within SQL Developer to the source and target as well as setting up the migration repository select Tools->Migration->Migrate.
|Step 1 -- Info on steps|
|Step 2 -- Select repository|
|Step 5 -- Select database(s)|
|Step 6 -- Convert data types|
|Step 7 -- Select objects to be converted|
|Step 8 -- Select target|
|Step 9 -- Select move data online|
|Step 10 -- Start job to migrate|
After job is completed using SQL Developer to view the migrated objects and data. Image below shows the source and new target.