User wishes to migrate there legacy SQL Instance that services Orchestrate from an IaaS Virtual Machine to Azure SQL Server PaaS, to make our platform more scalable. Is this possible?
Orchestrate is not compatible with SQL Azure in at least the following aspects:
Orchestrate is using Windows Authentication that is not supported by SQL Azure
Orchestrate is using SQL CLR that is not supported by SQL Azure
Some SPs using OPENDATASOURCE, OPENROWSET, etc. won't work
BULK INSERT is not supported, which is widely used in data import
Currently, Orchestrate doesn't support Azure SQL Server. So, Orchestrate databases cannot be hosted in Azure SQL Server. However, Orchestrate databases can be hosted on traditional SQL Server instances running in Windows Azure environment.