Azure SQL DB's - 2 features to add

[lostsole]

1. install of the Maint script for Azure only, if target Version = 'Azure sql db' then only install compatible

• skip backup

2. for azure sql db - on install Set 'User schema' for it to be created against. (Client doesn't want anyone to use the dbo schema, and not install on Master db in azure)

[lostsole]

get this messaged when installing on azure sql db , incompatable commands and references.
Msg 40508, Level 16, State 1, Line 22
USE statement is not supported to switch between databases. Use a new connection to connect to a different database.
Msg 40515, Level 15, State 1, Procedure DatabaseBackup, Line 16 [Batch Start Line 402]
Reference to database and/or server name in 'master.dbo.xp_instance_regread' is not supported in this version of SQL Server.
Msg 40515, Level 15, State 1, Line 9108
Reference to database and/or server name in 'msdb.dbo.sysjobs' is not supported in this version of SQL Server.
Msg 40515, Level 15, State 1, Line 9431
Reference to database and/or server name in 'msdb.dbo.sysjobsteps' is not supported in this version of SQL Server.

[olahallengren]

Thank you for the feedback.

I think that in order to fully solve this, I would need to create a separate installation script for Azure SQL Database.
It could be something like: MaintenanceSolutionAzureSQLDatabase.sql

[lostsole]

I have a few clients that don't what to install in Master db and not to use the dbo schema for both on-prem and Azure.