our approach
The first task in a big project should always be the most difficult one, or the one with the most unknowns. In this case it was dealing with the existing parts database. So we set about liaising with all stakeholders to work out how we could get the existing Microsoft SQL database of parts data into the modern Contentful CMS so we could then present this data on the frontend.
This required a bespoke migration and synchronisation procedure which we created and tested. Mainly utilising age-old SQL and the Contentful API. The Flaunt team made sure to involve Ideal’s technical team at all stages to follow relevant security procedures.
This data migration procedure also had the pleasant side effect of allowing us to spot issues and redundancies with the existing database, allowing us to assist in cleaning up entries and improving data integrity.