Any UC Suite where a DB migration is needed.
This article describes how to install, configure, or migrate the UC Suite SQL server database to a new SQL Server instance (either commercial, internal or external). The latter can be deployed on the same VM or an external SQL cluster. This procedure should be applied when upgrading from a UC Suite version that is older or equal to Summer 2019 to a newer one.
IMPORTANT: Starting from Imagicle 2023.Spring.1 release, MS-SQL Server 2008/2008R2 is supported only for updating an existing installation to Spring 2023, but you can't deploy a new Imagicle instance with such old MS-SQL version. Starting from 2023.Summer.1 release, MS-SQL 2008/2008R2 is not supported anymore and therefore a MS-SQL update is mandatory.
The new SQL Server 2017 Express local instance can be automatically installed along with the UC Suite by selecting "Install Microsoft SQL server 2017 Express" option during the setup.
You can install SQL Server standard or enterprise on a separated server or on the same Imagicle server, if supported you can upgrade (in place) the existing SQL Server express instance or you can install a new instance. During the setup remember to add the Full-text search feature to the installation.
If using a new instance, track the new instance name (you will need it later).
b. Choose “SQL server Authentication” as authentication type.
For any other SQL versions, or if the defaults has been changed, please check with the database administrator for the right credentials.
c. Connection properties must be left unchecked by default, unless a secure connection is used, in that case Encrypt connection option must be flagged.
After filling the information, please click on the “next” button.
b. Service account running on target SQL server instance must have read privileges on this network location.
Note that the network location can be located on the same VM if both SQL instances are co-located.
6. Finally specify a shared location to backup both the data and log files from the original SQL server and restore it on the target machine. The shared folder should have a size at least double that of the original database.
To check if the service has access to the shared folder, go to windows services, scroll down to the “SQL server” service and check the log on user used:
make sure that user has read and write access to the shared folder created earlier:
a. Right click the folder and click on properties
b. Under “Sharing tab” click on advanced sharing
c. If it’s not done already click on “share this folder” and then on “permissions”
d. Add the user used to run the “sql server” service and assign read and write permissions.
How to determine the SQL database size
In order to determine the database size used by the Imagicle application suite, you need to open to the Imagicle web portal:
Navigate to Admin→Support→Main info
b. Click on “Start migration”
b. When prompted, specify the new database instance name and its credentials.
c. After completing the wizard, log in to the Imagicle web interface and check under admin→support→Database Server that the new SQL instance name is appearing.