The Migrator is a very usefull tool to create and maintain SQR programs in a automated and template-driven way. A wizard helps in creation of an internal repository of data structures of multiple databases, supporting Oracle, MS SQL Server, DB2 or ODBC database servers. Table structures may either be loaded from the database directly, PeopleSoft repository (v7.x/v8+) or by a structure file.
Based on the collected repository, multiple projects with it's own set of program templates and mappings as well as custom code blocks may be maintained. Upon a single click any or all programs of a project may be automatically generated for each import and export side. The generated SQR programs may either be used for data migration or interface purposes.
Comments