Migrate +1,000 companies with Data Migration Studio for Dynamics AX

Nov 21, 2014 6:00:00 AM

Migrate +1,000 companies with Data Migration Studio for Dynamics AX

For one of our customers, we had to migrate more than 1,000 companies in Microsoft Dynamics AX. You could not migrate them one by one, so we had to come up with a way to migrate multiple companies. We made a few extensions and adjustments in To-Increase Data Migration Studio. Here’s how you, too, can perform data migration of any number of companies, using the solution.

We thought that, to make this kind of data migration predictable and easier it should be possible to group companies. In addition to that it should be easy to specify the connection for the different companies. Therefore, we introduced some new ways of managing multiple companies in Data Migration Studio:

  • You can now create company groups.
  • When you run a data migration project you can run it for a company group.
  • The connection setup can be global, per company, or for a company group.

Company groups

It’s important to lower the risk when you need to migrate multiple companies at the same time. It should be possible to test your process over and over again. To make it repeatable, we added the concept of company groups to Data Migration Studio for Microsoft Dynamics AX.

Migrate Multiple 1

For example, when you need to migrate six companies, you can do that all in one go or, for instance, in two groups to run multiple companies at the same time. In the first group you have companies 1, 2, and 3 and in the second group 4, 5, and 6.

When the company form is started you get an overview of the company groups:

Migrate Multiple 2

For each company group you can add a set of companies. In addition to that a batch group can be specified to spread the load over different batch servers. When you haven’t specified anything on the company level, Data Migration Studio will use the batch group from the company group.

Migrate Multiple 3

Project execution for a company group

To run multiple companies at the same time you can now run the project as before. In addition to that you can specify the company group. When you do this, Data Migration Studio will create the batch tasks per company in the group.

Migrate Multiple 4

You can still see and trace the history in the project history form per company.

Connection setup

Because it can be difficult to maintain all the connections for the different companies, we made different options available in Data Migration Studio.

  • Data Migration Studio will always check the environment type from the parameters. When you use the project for multiple companies, Data Migration Studio will first check a specific company.
  • When there is no company specified, Data Migration Studio will check the group.
  • When there is no group specified Data Migration Studio, will look for the global setup.

Migrate Multiple 5

I hope this makes your work easier and helps you migrate multiple companies. Please get in touch with any questions or feedback.

Share this message
About Author
Pieter de Jong

Pieter de Jong

Business and Application Integration Specialist Pieter translates the business requirements of the industries and companies To-Increase serves into functionality in our Business Integration Solutions for Microsoft Dynamics AX. His specialized skills include model-driven development, Javascript, Java, HTML, XML, Visual Studio, and Eclipse. Before Pieter joined the team at To-Increase, he spent a career of close to 20 years as a software engineer and developer at Baan Info Systems and in other companies.

Get In Touch

Related Blogs

Jul 1, 2019 8:09:49 AM
May 28, 2019 7:42:40 AM
Apr 9, 2019 9:27:11 AM