Oracle to PostgreSQL

Migrating from one database server to another might pose compatibility-related issues that are difficult to handle. Luckily, there are dedicated applications that can streamline the conversion process, making sure the database content is moved securely without risking data loss. That is also the case with Oracle to PostgreSQL, a handy software utility that enables database administrators who are currently using Oracle to migrate to PostgreSQL with ease.

Thanks to the wizard-based approach, working with Oracle to PostgreSQL is just a matter of following the on-screen instructions. For your convenience, the application allows you to load a profile file that you previously saved, so as to avoid having to go through the configuration once more.

However, there are a few settings you need to pay attention to before moving on with the wizard. First, make sure that the connections to the source and the target databases are both active. Secondly, keep in mind that using the wizard requires sufficient privileges to read the database schemas and data, create objects and insert data, as all these operations will be executed during conversion.

The wizard can migrate the data to the PostgreSQL directly, but you are also presented with the option to export everything to a PostgreSQL script file.   The first step of the wizard prompts you to fill in the server details for Oracle, namely the IP address or the network name, the name of the database you want to migrate, the port number, as well as the username and the password. As expected, the second step allows you to provide the data for the PostgreSQL server: the host and port number, the credentials and the database name.

Next, you must choose the name of the destination database and the name of the log file. You can disable logging by simply not specifying a name at this point, but it is advisable you create a log to be able to find the cause of an issue, should there be any.

The destination schema and the conversion name settings must be specified next. The application can create a new database schema if you don’t want to use an existing one. The last step requires you to select the tables you want to convert.

Oracle to PostgreSQL comes in handy if you need to migrate Oracle databases to PostgreSQL. Following a few simple steps, you can migrate your database securely, without worrying about compatibility or other issues. The migration speed is rather satisfactory: as promised by the developer, the application can migrate a 2GB database within less than 15 minutes on a system with average performance.