Abacus: Database Conversions

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 can be done two ways:
 
The Abacus data files generally exist in locations such as this:
Regular Data:  D:\Abacus\v23\data01
Accounting Data:  D:\Abacus\v23\data01\accounting
 
Our recommended way to access the data is to use the Abacus application to create a backup.  The backup is a ZIP file which can be extracted and will contain copies of the database file.
 

Verifying Database Files

You will know you have the correct folder when you see lots of documents with .ADI, .ADT, and .ADM extensions like this: 

Converting the Database

Once you have the database files, you can use Spectral Core to convert them to SQL Server.  When doing the conversion, make sure to select the following options: 
 
NOTE:
When you convert the database, the following error will occur but it can be safely ignored:
 
Once the database is converted, you can use Universal Migrator to back up the data from it.

    • Related Articles

    • 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 ...

    • 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 ...

    • 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.

    • Time Slips: Database Conversions

      When working with Time Slips, the database must first be converted from its legacy format into MSSQL. Time Slips from BDE Very old versions of TimeSlips use the Borland Database Environment. To work with this format, do the following: Create a backup ...