Sign In

Data Migration Guide

If you have an existing database that you want to migrate to AppSynergy, this guide is for you. If you require ongoing read/write integration with another system we recommend that you explore AppSynergy's Federated Data Integration capabilities instead. If you only need to import a few CSV files please see File > Import Data....

AppSynergy uses MariaDB for its SQL engine. Note that MariaDB is largely compatible with MySQL, so most tools that support MySQL will work with MariaDB.

Export Your Existing Database

There are many tools available that can do this but we suggest using RazorSQL. Its key feature is the ability to connect to almost any existing database (e.g. MS SQL, Postgres, MS Access, etc.) and generate SQL export statements that are compatible with MariaDB. What you should end up with is a .sql file that contains human-readable text that can be used to recreate the db in AppSynergy.

Tweak the Exported .sql File Prior to Importing (optional)

The following manual datatype tweaks are sometimes required for compatibility with AppSynergy:

If you are working with gigabyte sized .sql files then common text editors like Notepad will not be able to edit the file. We recommend EmEditor for editing large .sql files.

Import the .sql File

You can send the .sql file to AppSynergy support and request an import, or you can do the import yourself.

To import the file yourself you will need to install the MariaDB command line tools on your local machine. They can be downloaded here.

Second, create an AppSynergy API Key via Tools > API Keys... and assign the API Key user the Administrator role via Tools > Database Users...

Finally, you can import the .sql file you created above as follows:

mariadb --host=API_KEY_SERVER_HOST --database=API_KEY_DATABASE_NAME --user=API_KEY_USER_ID --password=API_KEY_PASSWORD --ssl-verify-server-cert < myfile.sql

After importing you will need to modify your AppSynergy database as follows: