Migration of Access databases to Microsoft SQL

The purpose of the database migration was to increase the performance of 220 car dealers with almost 6,500 users of a German automobile bank. This purpose was achieved by switching from Access to Microsoft SQL.

The challenge was to design proper processes and develop tools to ensure a smooth and simultaneous transition to the new financial system during the migration. Another critical element was the short timeline and controlled rollout to 6,500 workstations without field support.

By developing fitting tools and with the help of a manageable and experienced project team, elpix ag was able to meet the customer's needs quickly, cost-effectively and with high quality, even under changing requirements.

Since 2010 the customer belongs to the permanent customer base of elpix ag and further projects have been realized.

  • Implementation 01/2010 - 06/2010
  • Conception, design, planning, implementation
  • Development of SQL backup software
  • Development of a DB Update Wizard
  • Integration of a web-based portal solution
  • Automated planning of migration waves
  • DB performance increased by 20%