Converting a multi-site, multi-database system to a multi-site, single database system

After you read the information in the Infor SyteLine Multi-Site Planning Guide, if you want to convert from a multi-site, multi-database system to a multi-site, single database system, use these steps:

Note: SQL Server Enterprise Manager must be installed on the target database server.
  1. If you are on a previous version of SyteLine, upgrade each of your site databases to the current version. See the installation guide for instructions.
  2. If you have any business partner add-on products, upgrade those products on each of your site databases. See the appropriate product guide for instructions.
  3. On the target server, follow the installation guide instructions. The steps create a new, empty application database that will contain the sites and entities in your new multi-site, single database system. This database is automatically partitioned when it is created.
  4. Follow the steps in Copying an existing site into an existing database (multiple sites per database).
  5. After all sites are copied, use the View Management and Trigger Management forms to regenerate the views and table triggers in all application databases.