Release 7.0 enables clients to host Aptify database into cloud managed database offerings such as Azure Managed SQL Instance. The first step towards Azure enablement is to migrate the on-premises database to cloud. This document provides step-by-step instruction to migrate the existing database from a SQL Server instance to Azure SQL Managed Instance using Azure Data Studio. For more information on migration to Azure SQL Managed Instance refer to https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-guide.
...
- An Azure Subscription
- A Contributor role for Azure subscription.
Ensure that APTIFYSA user exists in the database. <link Refer to AptifySA user User creation to be provided later> documentation for instruction on how to create the user.
Note If you do not create APTIFYSA user, you will not be able to login to database or Smart Client with Azure instance.
- Execute below queries by connecting to SSMS and selecting database to be migrated.
EXEC sp_changedbowner 'sa'ALTER DATABASE [dbase] SET trustworthy ON- ALTER ASSEMBLY AptifyRecordHistorySecurity WITH PERMISSION_SET = UNSAFE;
- ALTER ASSEMBLY AptifyDecryptionTool WITH PERMISSION_SET = UNSAFE;
- ALTER ASSEMBLY AptifyHTMLUtility WITH PERMISSION_SET = UNSAFE;
Open store procedure spGetCurrentUserTypes from the Object Explorer. In the right-hand panel remove the double dots prefixed to vwGroupMembers.
Note After completion of migration undo the changes done in spGetCurrentUserTypes on On-premises database instance only.
...