D365 F&O Data refresh from Tier 1 to Tier 2 environment

RESTORE DATABASE [AxDB_Copyexport] FROM DISK = N'J:\MSSQL_BACKUP\DHG_datadrop_2_20210916.bak' WITH REPLACE, FILE = 1,

MOVE N'AXDBBuild_Data' TO N'G:\MSSQL_DATA\AxDB_Copyexport.mdf',

MOVE N'AXDBBuild_Log' TO N'H:\MSSQL_LOGS\AxDB_Copyexport_Log.ldf',

NOUNLOAD, STATS = 5

Use AxDB_Export

update sysglobalconfiguration

set value = 'SQLAZURE'

where name = 'BACKENDDB'

Use AxDB_Export

update sysglobalconfiguration

set value = 1

where name = 'TEMPTABLEINAXDB'

Use AxDB_Export

drop procedure if exists XU_DisableEnableNonClusteredIndexes

drop procedure if exists SP_ConfigureTablesForChangeTracking

drop procedure if exists SP_ConfigureTablesForChangeTracking_V2

Use AxDB_Export

drop schema [NT AUTHORITY\NETWORK SERVICE]

Use AxDB_Export

drop user [NT AUTHORITY\NETWORK SERVICE]

Use AxDB_Export

drop user axdbadmin

drop user axdeployuser

drop user axmrruntimeuser

drop user axretaildatasyncuser

drop user axretailruntimeuser

drop user axdeployextuser

update dbo.RETAILHARDWAREPROFILE set SECUREMERCHANTPROPERTIES = null where SECUREMERCHANTPROPERTIES is not null

cd C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin

SqlPackage.exe /a:export /ssn:localhost /sdn:AxDB_Export /tf:J:\MSSQL_BACKUP\DHG_cutover_rehearsal_2_20220104.bacpac /p:CommandTimeout=1200 /p:VerifyFullTextDocumentTypesSupported=false