DBConvert for MS SQL & PostgreSQL

DBConvert for MS SQL & PostgreSQL is an advanced tool that enables you to convert SQL databases between MS SQL, MS SQL Dump, Postgre SQL, Postgre SQL Dump, and PHP scripts.

It's also able to merge them, as well as to convert entire databases or take into account only selected tables, fields, indexes and foreign keys. You can either resort to the graphical or command-line interface.

The GUI is user-friendly, made from a regular window with a wizard-like appearance, meaning that you can take a step-by-step approach to configure settings related to the source, destination, conversion settings, execution, and task scheduling.

You can begin by selecting the source type between MS SQL, MS SQL Azure and PostgreSQL database, after which you can tinker with connection settings related to the host name, port number, user name, password, character set, database name, and schema type. The connection can be tested before committing all changes. What's more, you can edit advanced settings regarding SSH and SSL.

It's possible to choose only particular parts of the database for conversion instead of everything, such as fields from categories in tables, customers, employees, products, shippers, orders, order details, and so on. Moreover, you can overwrite existing tables, copy indexes and foreign keys, as well as copy the data or leave the fields empty. Conversion and migration tasks can be set to run automatically, according to the scheduler you define.

We haven't come across any stability issues in our tests, thanks to the fact that DBConvert for MS SQL & PostgreSQL didn't hang, crash or pop up error messages. It converted databases pretty fast while remaining light on system resources (CPU and RAM consumption was low).

This software application sports plenty of powerful options and customization settings for helping you convert and migrate SQL databases between popular formats.