How to migrate Oracle database to Microsoft SQL server database

By Errong Leng – 07 Feb 2023 – View online →

Oracle migrate to SQL Server

SQL Server Migratin Assistant is a free tool that Microsoft provides to automate database migration to SQL Server. I tried to use recently but gave up finally. Since it not support connection to your database server via custom JDBC url which is usually used by most backend java application.

DBeaver: one tool for all data sources

I've googled for days trying to find any open source alternatives. Fortunately, I found DBeaver.

You can download DBeaver Ultimate and try a 14 days free trial. It just met all my needs.

All you need to do is 3 steps:
1. connect to both source and target database
2. select the tables you want to migrate from source database
3. right click and select 'export data' menu and complete the rest