The change from one database to another sounds quite harmless in theory: Due to the standardization of SQL, existing applications should basically be able to work with any new database platform.
In practice, however, there are a few obstacles in the way of a smooth changeover. On the one hand, incompatible manufacturer standards for defining tables and views and, on the other hand, proprietary programming languages for triggers and stored procedures. In addition, there are often considerable differences between the individual SQL dialects.
PRODATA enables a smooth migration of your databases individually adapted to your needs and objectives.
After a detailed analysis of the databases to be processed, we create a specification sheet in which all necessary steps of the migration are listed in detail. After your approval, our experienced IT specialists merge the databases. As a rule, a semi-manual post-processing is carried out, for example to ensure the correct merging of duplicates.
During the entire process, you will be supported by a competent project manager who will monitor and control the success of your project.