A wizard will appear. Agree to the privacy notice and select “Next”. Click the ellipses to choose your product.
Click “Next”. Enter your SQL Server connection string and Integration Runtime Service ID. Note that this screen is very finicky:
Here is the SQL connection string that I used: Server=DESKTOP-
Note that I removed the semicolon from the end of the connection string that would normally be there. In my testing, the setup guide did not like the semicolon. If you do not have an Integration Runtime Service installed yet, leave this field blank. I already have one in my test environment so I populated this field.
The next screen will show a list of companies available in your GP instance. Place a checkmark next to the companies which you would like to migrate, or choose to migrate all companies, then click “Next”.
Because Business Central’s chart of accounts is dimensional and does not require the full account string to be created for each combination of natural account and segment, we need to identify which segments in the chart of accounts should be used for global dimensions 1 and 2. The remaining segments (if any) will be assigned to shortcut dimensions 3-8.
Once complete, click “Next”. This next step is very important. You must schedule the integration to run. If this step is not activated, the migration will not take place. If you only want to run the migration once, you can disable the schedule after the initial run.
One note on the Start Time field: in my testing, I found that this corresponds to the region that your Business Central SaaS tenant is deployed to. I am in the Eastern Time Zone and my tenant is deployed in one of the East US regions, so when I type in 9:40 am I can expect the integration to run at 9:40 am my time.
Click “Next”, then “Finish”. At this point, a message will appear asking if you would like to Open the Cloud Migration Management page. Click “Yes” to monitor progress.
Before any data can be migrated, you must initialize the company. Click on the “Not Initialized Companies” tile in the fact box.
At this point, Business Central will create one company for each of the companies that you chose to migrate.
Select the company you would like to initialize, and click “Schedule Company Initialization”.
Now we wait….
There are many variables that come into play that will determine how long the migration will take including network speed, SQL server resources, size of the GP database. For the most up to date details on the GP to BC Migration, click here: