Cannot integrate Intrust with SaaS Azure SQL Enviroment
説明
When attempting to create an Intrust Organization and creating the Database(s) in Microsoft Azure, the following error is thrown:
USE statement is not supported to switch between databases. Use a new connection to connect to a different database.
原因
The regular Azure subscription to use SQL-Services does indeed not allow the USE statement to prevent one customer from accessing other customer's databases that are hosted independently on different servers to allow for Azure-internal failover services.
対策
SQL Azure Managed Instance supports use database as a command because all of the databases in that model are on the same SQL instance – just like SQL Server. It is therefore recommended that you consider Managed Instance for migrations from on-premises SQL Server where you can not/do not wish to modify behavior to fit within a single SQL Azure DB.