Prevail Backups: Database Conversions

Prevail Backups: Database Conversions

Converting the Database

Prevail uses an object-oriented database named Postgres.  

Recover your username and password to Postgres

Refer to the Training: POSTGRES - Recovering username/pw article for instructions on preparing your database for conversion to MSSQL 

Convert to MSSQL

Follow the instruction found in the Training: Full Convert - Convert Postgres to MSSQL article to convert your Postgres database to MSSQL.


    • Related Articles

    • Proclaim Backups: Database Conversions

      Proclaim runs using the Progress OpenEdge database engine. You should contact Proclaim to have them enable ODBC connectivity and the use Full Convert to convert the database from ODBC to SQL. When you do, errors will occur but they can be ignored.

    • PCLaw Migrations: Creating Database Backups

      Depending on a firm's version of PC Law, their PC Law database is running with either SQL Server or CTREE. You should identify the database type and use the appropriate measures to acquire a copy of their database and their STATDATA folder. For SQL ...

    • Amicus Accounting: Database Conversions

      Because Amicus Accounting uses the FoxPro database engine, it must be converted before you can use it. When you receive an Amicus Accounting backup, it will be a ZIP file with content like this: You should extract the ZIP file and then locate the ...

    • Needles Migrations: Database Conversions

      Because the Needles database is an Advantage database, special steps need to be taken to access and convert it. On the Needles Server Backup the Needles Database Connect to the Needles Database server. Stop the SQL Anywhere - Needles service. Copy ...

    • Abacus: Database Conversions

      When working with Abacus, the database must first be converted into MSSQL format. Abacus from Sybase Advantage Abacus uses an old database format named Sybase Advantage. Before performing the conversion, you will need to gain access to the data. This ...