Migrate Data

What is Data Migration? Background: You're upgrading an older system or you need your existing data in another database. Problem: It's taken thousands of hours of effort entering the data into your existing system. Do you really want to manually enter it all again? Solution: Data Migration. The automated export of data from your old system and import into a different system or database. Data Export and Data Import Data Migration comprises two stages: Data Export: Code is created to automate the extraction of relevant data from your old system. Data Import: Code is created to automate insertion of extracted data into your new system. Why not just key in the new data? You may be tempted to just key in the most essential data by hiring in a few temps. This can be done, but many users forget that all that data has to be checked and corrected and rechecked. Automated data migration is far more accurate. Data Export Only Sometimes clients want us to just set up a Data Export facility. Examples:

• Marketing staff want to be able to extract selected clients for mailshots. We can 'bolt-on' this feature to many existing systems.
• Third party developers have designed a new system for clients. Data Creative have been asked to set up the data export from the old system to a set format that can be loaded into their new system.

Data Migration as part of a System Upgrade: In most projects where we upgrade a system from say Access ™ to SQL Server ™, we will also handle the data migration. We'd like to but we don't think it can be done! Over the years we've handled most popular types of data format and many of the more exotic ones. Examples:

• Non-PC IBM EBCDIC data from System 36 and AS400 midrange hardware
• Older PC formats like dBase and Paradox.
• We've even extracted data from printout files when clients have no access to the code of their old systems

Contact us now to discuss how we can help you.