restore MorphX Version control
When an Ax environment is setup for version control with MorphX, there are times when the database needs to be restored, or another database is required to be used instead. This causes the loss of all version control data. Ax has some standard tables where it stores all this data which can be backed up and restored. The tables used by Ax for MorphX version control are: SYSVERSIONCONTROLMORPHXITE2541 SYSVERSIONCONTROLMORPHXLOC2542 SYSVERSIONCONTROLMORPHXREV2543 SYSVERSIONCONTROLPARAMETERS SYSVERSIONCONTROLSYNCHRONI1982 However due to certain Ax frameworks its just not a straight copy. The Backup procedure: In this procedure, i create an SSIS task and add it to a Job that runs nightly backing up data from the tables specified above to a seperate database, which is then completely backed up. This is a simple “export data” functionality within SQL, and saved in the SSIS and attached to a job. The restore procedure: This is where a similar export data from the backup database