Create backup database

Note: x.x.x.x is the latest version of the IFPLM application installation folder and script files.
  1. From the installation package folder, open the Infor Fashion PLM x.x.x.x – Archiving subfolder.
  2. Run the IFPLM_DBARCHIVE.sql script after replacing the token [<%DATABASE_PATH%>] for the database file path.
    Note: This script is good for one time use only since this script only creates a backup database on the server.
  3. Run the IFPLM_ARCHIVE_Script.sql script after replacing the token [<%SCHEMA_NAME%>] for the schema name and [<%CORE_DBNAME%>] for the core database name.
    Note: This script should be executed on the new backup database created to create the tables and Stored procedures. The schema name should match the schema name from the main Infor Fashion PLM database where records are archived. You can get the schema name from Admin > Manage version.