Аn organization from the US offering individual and family community support services. They are committed to rehabilitation and behavioral health of their patients. Their rehabilitation centers are situated in multiple locations, which makes the service accessible. For over 50 years this organization provides services to people with behavioral problems and complex psychological issues.


IBM DB2 AS/400, Microsoft SQL Server


In order to successfully pursue multiple social goals, the organization needed to modernize its databases. Their technical team considered some alternatives and Microsoft SQL Server platform was selected as the most suitable due to its functionality. The first issue on the agenda was the data move from the DB2 AS/400 database. The project involved the transfer of almost 150 GB.


To enable the migration of data go off swimmingly the company decided to confer this task to professionals of Ispirer. Before delivering the software to the client, Ispirer developers performed some customizations of the Ispirer Migration and Modernization Toolkit 2015, which were required in order to ensure the highest level of automation in conversion of data. For example, the following features have been added:

  • Migration of the data types BINARY, GRAPHIC, CHAR FOR BIT DATA;
  • Migration of CHAR to NCHAR (available as an option);
  • Migration of BLOB Function;
  • Migration of 24:00:00 in TIME and TIMESTAMP data types.
  • The client was provided with the license for the Toolkit usage for several months. Ispirer expert had demonstrated to the user how the Toolkit is working during training conference via WebEx. After that, the client was able to launch the toolkit and start to migrate the data without any difficulties.

    Results and Advantages

    Everything run without a hitch. High performance of the MnMTK 2015 made it possible for the customer to run the migration on time and achieve their business goal.