About the CopySiteWrapper utility

System administrators (only) can use this utility to transition from a multi-site, multi-database setup to a multi-site, single-database setup. The script generated by this utility is used to mass-migrate multiple source sites into one target database, using the Copy Site tool.

This utility is located in the Tools folder in the base installation folder for your Mongoose-based application. Open it by double-clicking the file named CopySiteWrapper.exe.

This utility is a UI-based wizard that must be directed to a target multi-site database. When it is run, it gathers data from all source sites and then creates a PowerShell script that must be run for the actual migration to take place.

The CopySiteWrapper utility has these fields and options:

Field/Option: Notes/Description:
SQL Instance Use this drop-down list to select the SQL Server that is the source of the multi-site database to be copied.

When you click the down arrow, the utility automcatically searches your network for all available SQL Servers. You must know the name of the server you want to copy.

Authentication Use this drop-down list to select the type of authentication to use for access to the SQL Server:
  • Windows Authentication uses your system User ID and Password. If you select this option, you need not provide those credentials.
  • SQL Server Authentication uses login credentials specific to the specified server. If you select this option, you must provide both the User ID and Password to use for access.
User If you selected Windows Authentication, your user ID is automatically used for this field.

If you selected SQL Server Authentication, you must provide a valid user ID for the selected server.

Password If you selected Windows Authentication, your password is automatically used for this field.

If you selected SQL Server Authentication, you must provide a valid user password for the selected server.

Target Database From the drop-down list, select the database into which the source data is to be copied.

When you click the down arrow, the utility automcatically searches your network for all available SQL Servers. You must know the name of the server you want to copy the data to.

Analyze Only To instruct the utility to only search the specified servers and databases and verify the feasibility of the copy action, select this option.
Note: When this option is selected, no data is actually migrated. The utility simulates a copy action to verify that everything looks like it will work.
Parallel Process. Threads To instruct the utility to run shared and non-shared table migrations in parallel, select this option.

The number of Threads determines how many site copy threads can be run in parallel. The default is 10.

This setting should usually be kept 'as is' but, if the SQL Server resources are low (memory/CPU), it could be lower. If your server resources are very robust, you could raise this number.

Pre-Process Notes To instruct the utility to migrate notes for the combination of all source sites at the beginning of the script, select this option.

This setting is highly recommended for accuracy and efficiency of notes migration.

Select Sites To select or deselect subordinate sites to migrate, click this button.

This opens a dialog that lists all the sites that have been detected and that will be affected by the migration.

By default, all sites are selected. If, for any reason, you have any sites that you do not want to include, you can deselect them from the list. If all sites are to be migrated into the same database, then you need not click this button.

Create Script To create the PowerShell script that you can then run to copy the data from the source to the target database.

All standard site copy requirements (for example, linked servers and SQL permissions) are required before running this script. For additional requirements to run this script, see the header notes in the script itself.