Transfer data from Oracle query to SQL Server table without programming

by

Posted on by

Want to transfer data from Oracle query results to SQL Server table?

Using Withdata software DBCopier, a Oracle to SQL Server converter, you can transfer data from Oracle query result to SQL Server table easily and fast.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Support Windows, Linux, macOS.

Download DBCopier Download DBCopier

Transfer data from Oracle query To SQL Server table

Login to Oracle and target SQL Server -> Enter source Oracle query -> Set target SQL Server table -> Copy Oracle query data to SQL Server table

Choose source Oracle database and logon.

convert Oracle query to SQL Server table - Choose Oracle and logon

Choose target SQL Server database and logon.

save Oracle query results to SQL Server table - Choose SQL Server and logon

Click “Convert From Query” at task dialog.

Import data from Oracle query results to SQL Server table - Task Window

then show the wizard.

1. Set a Oracle query.

Convert data from Oracle query results to SQL Server table - open query results

2. Select a destination SQL Server table and config fields.

Extract Oracle query results data to SQL Server table - select table

3. Preview data.

Migrage data from Oracle query results to SQL Server table - preview

4. Transfer data from Oracle query result to SQL Server table.

save data from Oracle query results to SQL Server table - import

You can schedule and automate this “Oracle to SQL Server” conversion task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.

More about DBCopier – Oracle to SQL Server Converter

Download DBCopier for 30-day free trial Download DBCopier