Migrator

Welcome to the home of the Migrator

The Migrator is a very usefull tool to create and maintain SQR programs in an 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.

The list of features includes:

  • Multiple users can work on the same Migrator database
  • Maintenance of collected data structures from Oracle, DB2, ODBC connections
  • Structure retrieval from either database level, PeopleSoft repository or structure file
  • Multiple projects with multiple programs, each with own mappings for all fields
  • Global mappings for general purposes across whole project with ability to automatically apply code to each field occurrence
  • Wizard-driven generation of programs and mappings used for SQR geneneration
  • Repeatable SQR generation for one or many programs, with import/export versions
  • Selective data manipulation per field mapping, e.g. "Insert only", "Update than Insert", "Update only"
  • Customisable code blocks on global or mapping level
  • SQR templates with multiple pre-defined entry points for custom SQR code

The Migrator documentation and introduction (in PDF format) are contained within the installation, but is also available in the Download Area for registered visitors.

System requirements: Windows 2000 SP4, XP SP2 or Windows Vista SP1 or higher; 1 GB physical memory; core installation about 6 MB of harddrive space. For database connection the corresponding client drivers for the server system have to be installed, such as SQL*Net for Oracle. The Migrator does not support execution of SQR programs.