Data Migration

Last update: July 25, 2023

CREATED FOR:

  • Beginner
  • Intermediate
  • Admin
  • Developer
  • User

Migrating to a new database schema, server, or reporting database does not have to be stressful. The Adobe Services team offers migration assistance.

To ensure that your transition is as smooth as possible, you should be as detailed as possible when submitting your migration request. This topic has everything that you need to submit a request and get started on the migration. Providing us with a comprehensive picture of your needs guarantee that your project is scoped properly and that the estimate is accurate.

Getting started

Before getting started, you must know the answers to these questions:

  • Is the new database on a new server? Before submitting a request, update your data connection’s settings under Manage Data > Connections. If you need a refresher on how to do this, go to the Integrations section and find the instructions for the type of database you are using.

  • Does your all historical data exist in the new database or does it need to be migrated? You can consolidate the historical and new data during the migration process. Even if you do not need a consolidation, let us know in your request.

After you have the answers to the above, you need to know the type of migration. Will the new database have the same schema, or will it have a different schema? In the discussions below, you find detailed instructions for each migration type.

Migrating to a new database with the same schema

When submitting the request, let us know that the database schema is not changing and that the connection is already set up in Adobe Commerce Intelligence.

If the database has a new name, include it in the request so your dashboards can be properly migrated.

If the database name is not changing, the migration is complete. Dashboards and reports will refresh after the next full update is completed.

Migrating to a new database with a different schema

IMPORTANT
If certain data columns do not have equivalent columns in the new database, there is a chance that certain analyses may be lost in the process.

To successfully complete this type of migration, existing data columns have to be matched with their equivalents in the new database. This is not mandatory, but performing the matching for us helps speed up the turn-around time of your request and lower the price of the migration.

If you feel comfortable doing the matching yourself, follow these instructions and attach the finished spreadsheet to your request:

  1. Review all the tables and columns currently syncing to your Data Warehouse (Manage Data > Data Warehouse).

  2. In a spreadsheet, create a tab for every table to be migrated to the new database.

  3. In each tab, create a column for all the existing columns that need to be migrated. Adobe recommends naming it something like Existing column name.

  4. You also need to make another column for the column equivalents in the new database in each tab of the spreadsheet. Adobe recommends naming the column something like New column name.

  5. Enter the existing columns and their equivalents. If an existing column does not have a new equivalent, enter N/A.

    Also, if there is a new way to calculate the same information in the new database, enter it in the [New column name] column.

Here is a look at an example:

NOTE
If certain data columns do not have equivalent columns in the new database, there is a chance that certain analyses may be lost in the process.