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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXrP_oPN2Z1AfjHdOSwxXft_NH9D_DD96ZX0f8XmaSpszhVr3pgymIIJCgk9tS9Q1HDNzp15RmNyp8GaBL6xIHshixDbdvKX845Tckmvq2AOOLrER9dbxF_UVN1S1bnNY-pL_mPEn-tJXEiEw5z1e4kfrnCruzqMC0nrp8HQwmtzzpmUHIjuwAe6kUhg/s320/Screen%20Shot%202022-05-25%20at%204.17.48%20PM.png) |
Step 1 -- Info on steps |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk08Txtb8NFMc7JvWdaWhIeL31OhhOyHVjpJIMaq81qgSg1E2qPxYM9fynSEl2u7LDEqSuozbMihtsE8YvoscVjlYUAv10OPCsp6GLjDqDu4OvlcF5RsyMdoA8IQkK_z8H7uJLvs8jjgfaW_V9abgu9QW3P5YnrBlV78mRP3FCoFb9L5p570k9uuit6w/s320/Screen%20Shot%202022-05-24%20at%201.38.51%20PM.png) |
Step 2 -- Select repository |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdnlME0sS-qP9Klmd2dZ6DTiAZPSMcp8J_dYBKqotdOiNg1J2GHKvT5rtBmKRjCNB21tviEgYVIFwq6PW14-fPMrJfft-92NoBeLp_gnuNR7iwlcedBJL4Jr7vYf9lhIexSvcV7X0k5nez5RfhSfDiRR_gT_SOkzES7VRlHc53oHfhuuhuebXXPRuRnQ/s320/Screen%20Shot%202022-05-24%20at%203.53.50%20PM.png) |
Step 4 -- Select source |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXTu0B1aMGldXUZX6JGkmTUhsfbZ7yW432LLCPQ7-qEmP2eJpPamWz9-CHO-ES9Fnn1Z9sLGvqHSsKMwmedKWjOmbLAC_CgJjQ-7yF66cRTQ_EKSCJeSKSAxpM3lxl2GujluNzbdR3y7zRMveOg9fUa0SGBB8vElKM_jS5QH8QklngEMz0vYFTLEPogA/s320/Screen%20Shot%202022-05-24%20at%203.54.05%20PM.png) |
Step 5 -- Select database(s) |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0IrkAKPSi4ap69ijcx9BI5Rg8nKWLq7le6ZGXqVzFfc6UxuU8lF92V3_ZUWhMV_NnQXK1AAR7kosa4garAVCXZQdrFKKkLFU4lIb9KAS7WSFVslFXttCqTXK5YmqqDhXbrqSXqOjJkHbyG_f0D7CWJP--OzWLGGHsCtr68uFqhiueSRiR_DZH4pD4cg/s320/Screen%20Shot%202022-05-24%20at%203.54.17%20PM.png) |
Step 6 -- Convert data types |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZHkJoKz0l08B7ttVedMDgExdvE_2qt7pqLTvc_kAh7J_MVxOuhpWe9Ea654CRFQ48Z5VaxS4u-guZWOvoshWB-DrtMEZ7qnwuxO1NelpbTW6d_MpQrCL-kkMC_CSrIMoEvYdo8Zzjg7aj4zQ6qk1q2NZPM31RHY2Uii-ayJjOZxW4eCZqAhNvVDL3SQ/s320/Screen%20Shot%202022-05-24%20at%203.54.29%20PM.png) |
Step 7 -- Select objects to be converted |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9WUDWDCf1houiwy7LfORf4P_R2IYuO-9n3oNsN2kwNDgByyQV7ea3trIPAjbDj0yBKp1XaVVjBJbZuHnhjNQXcc7MdwSYASNptfQKtzkbdX1rsQdBqZYTaYPuBToob-S7ijmhiKgEf0bqJlZjYV9JwWGuhicrRpc32ekEj3Q0kZcfcMtIprLLvox79g/s320/Screen%20Shot%202022-05-24%20at%203.54.53%20PM.png) |
Step 8 -- Select target |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDuPkPmpXCoSXZZXNQNTupVUecbYEDvzcFbuoXIOfYoMNQf6VFlFUDc_FuOPbrhn_tih2F8HoBNncikQ3f5K7iziLov8x9sTzyhX13l3dDgNQOkebE2_CyKOcX_EkLj57uSu_nkedUT5EXtXEA6GR8L6nj60AFXAMJxStAinSRCF6BGoAYp0C32rQq9g/s320/Screen%20Shot%202022-05-24%20at%203.55.07%20PM.png) |
Step 9 -- Select move data online |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrd6S3yjyTCiw00mRSooGelqX7Cv471934_mclidy61VusbtIvFo0JFhhM8ac8nLGPlW1SwDStoppUVsL9aE3w1ynpzubMSVCPJV1b2kmSqmbFS2uIXVLoi6uOQdOZiZQzTj2_sKVei-voAsFpdATAyfdXhY1CrHd2Evh5scfd5NkTPBH7TO0NkNnTGQ/s320/Screen%20Shot%202022-05-24%20at%203.55.18%20PM.png) |
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.
No comments:
Post a Comment