Final Database Cleanup

After importing your data, run the Final Database Cleanup section from dbsetup.dms, generated by the Database Creation Wizard. Comment out the IMPORT line of the DMS script, since you have already imported all table structures and data. Run the security steps and later lines from dbsetup.dms. Besides the security steps, the dbsetup.dms script may contain these lines:

ENCRYPT_PASSWORD *;

CREATE_TRIGGER *;

REPLACE_VIEW *;

CREATE_TEMP_TABLE *;

The tables referenced by these lines are the ones in the structural export files, or full datamover export file, depending on which one you originally exported.

You should now be able to configure your connection with Configuration Manager, and log in with Application Designer. It is recommended to check the database integrity by running the SQR audits DDDAUDIT and SYSAUDIT.