=== 15a Extract DACPAC from lab-cst
Resolving references in schema model
Validating schema model for data package
Validating schema
Successfully extracted database and saved it to file 'results/15_artifacts/cst.dacpac'.
Time elapsed 0:00:12.12
--- TIME_ZONE in dacpac model.xml:
23-			<Relationship Name="GenericDatabaseScopedConfigurationOptions">
24-				<Entry>
25:					<References Name="[TIME_ZONE]" />
26-				</Entry>
27-			</Relationship>
28-		</Element>
29-		<Element Type="SqlDefaultConstraint">
--
5054-			</Annotation>
5055-		</Element>
5056:		<Element Type="SqlGenericDatabaseScopedConfigurationOptions" Name="[TIME_ZONE]">
5057-			<Property Name="GenericValueType" Value="2" />
5058-			<Property Name="GenericValue" Value="Central Standard Time" />
5059-		</Element>
5060-		<Element Type="SqlSchema" Name="[tzlab]">
--
5792-				<Property Name="StartLine" Value="1" />
5793-				<Property Name="StartColumn" Value="1" />
5794:				<Property Name="HeaderContents" Value="CREATE   TRIGGER tzlab.trg_TriggerTarget_Audit ON tzlab.TriggerTarget AFTER INSERT&#xA;AS&#xA;BEGIN&#xA;    SET NOCOUNT ON;&#xA;    SET TIME ZONE 'UTC';&#xA;    INSERT tzlab.TriggerAudit (target_id, audit_time, audit_tz) SELECT id, GETDATE(), CURRENT_TIMEZONE_ID() FROM inserted;&#xA;END;" />
5795-			</Annotation>
5796-		</Element>
5797-		<Element Type="SqlTable" Name="[tzlab].[TriggerAudit]">
5798-			<Property Name="IsAnsiNullsOn" Value="True" />
--
5942-				<Property Name="StartLine" Value="1" />
5943-				<Property Name="StartColumn" Value="1" />
5944:				<Property Name="HeaderContents" Value="CREATE   PROCEDURE tzlab.usp_Nested&#xA;AS&#xA;BEGIN&#xA;    SET NOCOUNT ON;&#xA;    SET TIME ZONE 'Nepal Standard Time';&#xA;    SELECT '   nested proc (set Nepal)' AS step, CURRENT_TIMEZONE_ID() AS tz_id, SYSDATETIMEOFFSET() AS now_offset;&#xA;END;" />
5945-			</Annotation>
5946-		</Element>
5947-		<Element Type="SqlProcedure" Name="[tzlab].[usp_NoSet]">
5948-			<Property Name="BodyScript">
--
5951-BEGIN
5952-    SET NOCOUNT ON;
5953:    SELECT '  proc without SET inherits caller' AS step, CURRENT_TIMEZONE_ID() AS tz_id, SYSDATETIMEOFFSET() AS now_offset;
5954-END;]]>
5955-</Value>
5956-			</Property>
5957-			<Property Name="IsAnsiNullsOn" Value="True" />
--

=== 15b Export BACPAC from lab-cst
Error SQL46010: Procedure: [tzlab].[usp_Nested] contains a statement that is not supported on Microsoft Azure SQL Database v12. The specific error is: Incorrect syntax near 'TIME'.
Error SQL46010: Procedure: [tzlab].[usp_ReportInTokyo] contains a statement that is not supported on Microsoft Azure SQL Database v12. The specific error is: Incorrect syntax near 'TIME'.
Error SQL46010: Trigger: [tzlab].[trg_TriggerTarget_Audit] contains a statement that is not supported on Microsoft Azure SQL Database v12. The specific error is: Incorrect syntax near 'TIME'.

Time elapsed 0:00:12.66
--- TIME_ZONE in bacpac model.xml:

=== 15c Generate deploy script (not executed) from cst.dacpac against lab-utc
Generating publish script for database 'lab-utc' on server 'your-server.database.windows.net'.
Successfully generated script to file results/15_artifacts/deploy_to_utc.sql.
Time elapsed 0:00:21.38
--- TIME_ZONE lines in generated deploy script:
44:        ALTER DATABASE SCOPED CONFIGURATION SET TIME_ZONE = CENTRAL STANDARD TIME;

=== 15d Parse-only check of the scripted TIME_ZONE line (SET PARSEONLY ON, nothing executes)
statement under test:         ALTER DATABASE SCOPED CONFIGURATION SET TIME_ZONE = CENTRAL STANDARD TIME;
Msg 102, Level 15, State 1, Server your-server, Line 1
Incorrect syntax near 'CENTRAL'.
(no output above = parsed OK)

--- Control: same check with a correctly quoted statement
(no output above = parsed OK)
--- UTC database TIME_ZONE must still be LOCAL after the parse checks:
name value
---- -----
TIME_ZONE LOCAL