Database environment migration

The main purpose of the thesis is to introduce a method on how to proceed when migrating a database environment. The first section presents several commercial and noncommercial applications and subsequently the migration method is introduced. This method can achieve a successful data transfer to the new environment. The method is adapted to ERP system database, but after minor adjustments may be used for a large number of databases. During several phases are selected relevant data, restructured using tools and then imported into the target environment. The whole procedure is well documented into log files which can be used to check the process. To validate the data quality a new validation tool was created. It is capable of monitoring whether the data is consistent with company standards