Sync data from Oracle to SQL Server

by

Want to sync data from Oracle to SQL Server ?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from Oracle to SQL Server

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

Choose source Oracle database and logon.

sync Oracle to SQL Server - Choose Oracle and logon

Choose target SQL Server database and logon.

sync Oracle to SQL Server - Choose SQL Server and logon

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

sync from Oracle to SQL Server - Task Window

then show the wizard.

1. Select source Oracle tables to sync.

sync from Oracle to SQL Server - Open source database

2. List target SQL Server tables.

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

sync data from Oracle to SQL Server - full synchronization

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

sync data from Oracle to SQL Server - upsert synchronization

3. Select SQL Server tables to sync.

sync from Oracle to SQL Server - select tables

4. Sync Oracle data to SQL Server.

sync from Oracle to SQL Server - sync


More about Oracle to SQL Server converter

See also: