expert system; fuzzy; data migration; database; relational database; data type; relational database management system

This paper deals with the design of the fuzzy expert system for processing data migration between different relational database management systems (RDBMS). At the beginning we identify current state of data migration between different RDBMS. Then we propose new approach which suggests creating of expert system as a tool for migration of database tables and their data between different RDBMS. The proposed tool, which contains an expert system, also includes the possibility of optimizing the data types in the target RDBMS database tables based on processed data of the source RDBMS database tables. Paper also proposes methodological guidelines for successful migration of database tables and their data between different RDBMS and suggests the possibility of tool extension when the source or target RDMBS is changed. The proposed expert system is shown on data migration of selected database of the source RDBMS to the target RDBMS.