How to migrate Oracle database to Microsoft SQL server database
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
References
DBeaver Ultimate
DBeaver Ultimate is a full-featured toolkit for database management that also provides easy access to AWS services: integration with AWS user and permission management, connection to AWS databases in a few clicks.
SQL Server Migration Assistant - SQL Server
Learn about SQL Server Migration Assistant, a tool that automates database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and SAP ASE.
