Convert a Postgres database to MSSQL

Convert a Postgres database to MSSQL

Full Convert by Spectral Core is a robust tool for converting databases from one format to another.  The following instructions will walk you through using Full Convert to convert a Postgres database to MSSQL.

Launch Full Convert

Click New database copy project in the upper left.

Select PostgreSQL from the option list (green arrow below)

Enter your connection information to the Postgres database you're converting (green square section below).

Click Next near the center top of the window.

Select SQL Server from the option box near the top, indicated by the green arrow below.

Enter the connection information to your target database (green square below).  If you type the name of a database that doesn't yet exist on your server you will have the option to create after clicking Next.

Click Start Conversion be begin converting your Postgres database to MSSQL


    • Related Articles

    • Convert a CTREE Database to MSSQL

      CTREE Databases are a legacy database format that has been used by some applications. In order to work with them, you'll need to do the following: Install CTREE ODBC Drivers Create a "Table List" Configure the ODBC Drivers to use the Table List Use ...

    • Recover a POSTGRES username and Password

      The following will help you recover your username/pw to a Postgres database so you can convert it to MSSQL format. Current Process: 1. Log into the server, open Services.msc, find Postgres service, and stop it: 2. Right-Click the service, select ...

    • Create a POSTGRES Backup

      This article assumes that you know your Postgres credentials and PgAdmin is Installed. Connect into PgAdmin. Right-Click on the database and click Backup: On the General tab, enter a filename and choose TAR as the format: On the Data/Objects tab, ...

    • Repair a corrupt MSSQL database

      For law firms with premises based systems like Time Matters you may run into situations where the database has not been maintained and has become inconsistent. This can prevent your ability to create a backup from which you can migrate the customer ...

    • Restore a MSSQL BAK Backup

      To restore a MSSQL BAK database backup, do the following steps: 1. Open Management Studio and connect to the database server. 2. Right-Click on Databases and select Restore Database... 3. In the dialog that appears, select Device and then click the ...