Data migration

On this page

• Before you start
  • Obtaining a copy of the Aronium Lite database
• Understanding source and target databases
• Preparing users for migration
• Download the Data Migration application
• Running the Data Migration application
  • Welcome screen
  • Selecting databases for migration
    • Selecting Aronium Lite database
  • Review selection
  • Data migration progress
  • Finish

Data Migration is a tool you can use to copy data between Aronium Lite and Aronium Pro.

For example, if you want to move from Aronium Lite to Aronium Pro to use multiple cash registers, you can use this tool to copy your existing data to the new database and continue where you left off. This article explains how to complete the migration in a few simple steps.

Before you start

Before running the Data Migration tool, update your current Aronium Lite installation to the latest version.

Once Aronium Lite is updated, install Aronium Pro. Start Aronium Pro at least once so the application can complete its initial setup and update the database. It is enough to run it until you reach the first onboarding screen. Once this screen appears, you can close Aronium Pro.

Obtaining a copy of the Aronium Lite database

If Aronium Lite is not installed on the PC where you are running the Data Migration tool, you will need to copy an Aronium Lite database backup to that PC.

Follow the instructions in Backup database to create a backup.

Once the backup is created, copy it to the PC where the Data Migration tool is installed. You will select this file later during the migration.

Understanding source and target databases

In the following steps and in the Data Migration tool, you will see the terms source and target. The source database is the database you are copying data from, and the target database is the database you are copying data to.

For example, when migrating from Aronium Lite to Aronium Pro, the Aronium Lite database is the source and the Aronium Pro database is the target.

On the other hand, when migrating from Aronium Pro to Aronium Lite, the Aronium Pro database is the source and the Aronium Lite database is the target.

Preparing users for migration

The Data Migration tool cannot read users' passwords. The following steps will help make sure you can access Aronium after the migration is complete.

In the source database, identify an administrator user and make sure that user has a valid email address. Remember, the administrator is the user with the highest access level in the system.

The easiest way to match users is to create at least one administrator in the target database with the same first name, last name, and email address as an administrator in the source database. The Data Migration tool will recognize these as the same user, allowing you to log in to the target database after the migration is complete.

For example, if you are migrating from Aronium Lite to Aronium Pro, start Aronium Pro (the target) and add or update an administrator user so that the user's first name, last name, and email address match the administrator in Aronium Lite (the source).

Download the Data Migration application

Download the Data Migration installer from https://download.aronium.com/tools/data-migration-tool/latest/DataMigration.Setup.exe. Once downloaded, run the installer and follow the on-screen instructions.

Running the Data Migration application

After installation, you can start the Data Migration application using the shortcut placed on your desktop.

Welcome screen

When you start the application, the welcome screen will appear. Click Next to continue.

Selecting databases for migration

On the second screen, you will be asked to select or confirm the databases to use for the migration.

Because the Data Migration tool is running on the PC where Aronium Pro is installed, the Aronium Pro database will be detected automatically from the local configuration. You do not need to select it manually.

If Aronium Lite is not installed on the same PC, you can select an Aronium Lite database backup to use for the migration.

By default, the migration direction is set from Aronium Lite to Aronium Pro. This means that data from the Aronium Lite database will be copied to the Aronium Pro database.
To reverse the migration direction, click the button in the middle of the screen.

The migration will then run from Aronium Pro to Aronium Lite.

Selecting Aronium Lite database

To select a different Aronium Lite database or a backup file, click Change database and select the Aronium Lite database backup. Depending on the selected migration direction, this database will be used either as the source or as the target.

Once you have selected the correct database, click Next.

Review selection

This screen allows you to review the selected source and target databases before starting the migration.

If everything is correct, click Start import to begin the migration.

Data migration progress

Once the migration starts, a progress bar will display information about the data being migrated. Depending on the size of your database, this process may take some time.

The migration process performs the following steps:

1. Creates a backup of the target database before any data is erased
2. Cleans the target database and removes its existing data
3. Copies the following data from the source database
   • Users
   • Products
   • Taxes
   • Customers
   • Payment types
   • Countries
   • Documents
   • Promotions
   • Access levels
   • Company details
   • Z reports

Finish

When the migration is completed successfully, a confirmation screen will appear.

If you migrated data to Aronium Pro, you can start Aronium Pro immediately and verify that your data has been copied successfully.

If you migrated data to Aronium Lite, follow the instructions in Restore database to restore the migrated database. Then start Aronium Lite and verify that your data has been copied successfully.