We currently run a legacy version of Octopus on Prem (2019.3.5LTS). this is connected to a SQL2014 server for it’s database. As part of a migration project, I am trying move the database to AzureSQL; however when i try to do this, it fails with the following error “one or more unsupported elements were found in the schema used as part of a data package”.
I then receive SQL71564 errors for the elements User and Login:
The element User: [xxx] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
The element Login: [xxx] has property IsMappedToWindowsLogin set to a value that is not supported in Microsoft Azure SQL Database v12.
I cannot find a solution to this - can anyone help?
I hope this helps! Let me know if you’re able to get the export working as expected or if you run into any further roadblocks with your Octopus DB migration.