Copying an existing site into an existing database (multiple sites per database)
Before you start this process, consider this information:
- If you have custom tables in your existing sites (possibly created with the
SQL Tables form in a previous version of SyteLine), they will be copied, but they will not be changed
to multi-site tables. That is, the table name is not changed to xxx_mst, no view is
created over the table, and no multi-site column is added to the table. If you want
a custom table to be multi-site, create and run a script to perform the conversion.
For more information about the required schema conversions, see the white paper Coding and Schema Changes Made in SyteLine 9.00 for Multiple Sites per Database.
- Tables or columns that exist in the source must also exist in the target database. So if you have custom tables or columns in the source, you must ensure that they are added to the target.
- Use the Analyze Only option (described later) to find additional potential problems that you must address before you perform the copy. If you do not find and correct these problems, and the copy process hits a validation error, the copy process is aborted.
- Do you have replication document metadata (that is,
records in the Replication Documents form and related forms) that has been
customized or revised from the standard Infor metadata? If so, be aware that
this process copies replication document metadata only into a target database
that does not contain any replication document metadata. This could be an empty
target database, or a target database that is emptied during the site copy
process, or a target database where all replication document metadata has been
removed.
If replication document metadata exists in the target database, then use the App Document Metadata Sync utility as described in Step 13.
- The Infor CPQ (formerly BuyDesign) configuration output tables are excluded from this process and are not copied to the target database by the CopySite utility. Run the Infor CPQ Configurator Output Database Copy Utility after the CopySite utility has successfully completed the copy process. For more information about this utility, see KB article 1549052 on the Infor Support Portal site.