Convert and transfer information from Oracle databases to Postgres using this app that lets you handpick the tables or entire schemas you want to process.
- OracleToPostgres
- Version : 2.0 Release 1 Build 170614
- License :Trial
- OS :Windows All
- Publisher :Withdata Software
OracleToPostgres Description
OracleToPostgres is a simple to use application designed to facilitate the data transfer from one database format into another. The program can easily convert and export the indicated data from Oracle to PostgreSQL. It also offers several tools that facilitate the transfer, such as wizards or queries.
OracleToPostgres supports exporting the data contained in the selected table. You are required to connect to both databases in order to permit the data export/import. The software allows you to easily select the source for the transfer, by choosing the desired table and indicating the rows to be processed.
You may even create new tables in the source database, then instantly convert and transfer them to the destination. The output schema must also be indicated, by selecting one of the supported databases from the drop down menu. Moreover, you need to specify the data transfer mode; thus, you may attach the new information to the destination table, replace or update the data.
In case of transferring several tables at the same time, you may do so by using the dedicated function. You may manually select and configure the tables to be transferred or you may open the specific wizard function. Alternatively, you may create a query, in order to define the source of the transfer.
You may control the entire export/import process via SQL query, by identifying the input tables, indicating the destination and the transfer method. The data migration can be done by appending the existing information, by replacing or updating it.
The software allows you to automate the transferring tasks by creating schedules and indicating whether a transfer should be done one time or repeatedly. You may also control the tasks via command line, create batch (.BAT) files or save the current session for later use.
The area at the bottom of the window indicates the progress of the import, activity log and, in case of single table transfer, a preview of the result.
System requirements
- Oracle
- PostgreSQL
Limitations in the unregistered version
- 30 days trial
- Nag screen