One of the keys to a successful data migration project is ensuring that all your migration steps are automated, and therefore repeatable. Even if in theory manual operations will only be performed once, in reality the best approach is to be able to do multiple runs of the extract from the source legacy systems- because this tests the process, and also avoids having to “do everything over the weekend.”

Take advantage of the datamartist data scratchpad to build automated transforms

Datamartist is ideal for planning and prototyping data migration

• Convert and Clean data quickly
• Parse text fields using familiar spreadsheet functions
• Calculate new columns easily- see the results on millions of rows instantly
• Combine data of different types from multiple sources and apply the calculation needed.
• Data profiling lets you see the data at a glance

For small data migration projects, Datamartist might be all you need. But regardless of how large and complex your migration task is, Datamartist gives you a handy data scratchpad to test ideas and create prototypes that avoid expensive, time consuming false starts.