Sync data from SQL Server to Oracle

by

Want to sync data from SQL Server to Oracle ?

Try Withdata DBCopier, a SQL Server to Oracle converter for Windows, Mac, and Linux, Synchronize SQL Server to Oracle, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Synchronize data from SQL Server to Oracle

Login to SQL Server and target Oracle -> Select source SQL Server tables -> Set target Oracle tables -> Sync SQL Server data to Oracle

Choose source SQL Server database and logon.

sync SQL Server to Oracle - Choose SQL Server and logon

Choose target Oracle database and logon.

sync SQL Server to Oracle - Choose Oracle and logon

Click “Wizard – Import All Tables” at task dialog.

sync from SQL Server to Oracle - Task Window

then show the wizard.

1. Select source SQL Server tables to sync.

sync from SQL Server to Oracle - Open source database

2. List target Oracle tables.

Set “Import Type” to “Replace”, it will do a full synchronization.

sync data from SQL Server to Oracle - full synchronization

Or set “Import Type” to “Upsert”, it will do a upsert synchronization.

sync data from SQL Server to Oracle - upsert synchronization

3. Select Oracle tables to sync.

sync from SQL Server to Oracle - select tables

4. Sync SQL Server data to Oracle.

sync from SQL Server to Oracle - sync


More about SQL Server to Oracle converter

See also: