Migrating an Existing SQL Database to Azure SQL
Procedure Steps
It is not possible to use the MDF files when migrating an existing OnGuard SQL database into Azure SQL.
Options for migrating an existing OnGuard database into Azure SQL include:
- Export the database to SQL scripts, and then run the scripts in Azure SQL.
- Export the database using Microsoft SQL Management Studio's built-in "Deploy Database to Windows Azure SQL Database" option.
- Export the database using Microsoft Data Migration Assistant.
When using any of these options, you might see the following error:
TITLE: Microsoft SQL Server Management Studio------------------------------
One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71627: The element User: [Domain\WindowsUser] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
Error SQL71627: The element Login: [Domain\WindowsUser] has property IsMappedToWindowsLogin set to a value that is not supported in Microsoft Azure SQL Database v12.
(Microsoft.SqlServer.Dac)
To correct this error, you must remove the Windows user identified in the error.
Applies To
OnGuard (all versions)
