Moiz Ahmed

 Steps: 1. On this navigation click on Export Data-tier Application. Error: Solution: Increase time on Registry Editor and restart the machine.                    Navigation :  Computer\HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\SQLDB\Database Error: After removing this error, repeat same process to export bacpac file and again face another error. Solution: to resolve this error run command on SQL. update sysglobalconfiguration set value = 'SQLAZURE' where name = 'BACKENDDB' update sysglobalconfiguration set value = 1 where name = 'TEMPTABLEINAXDB' drop procedure if exists XU_DisableEnableNonClusteredIndexes drop procedure if exists SP_ConfigureTablesForChangeTracking drop procedure if exists SP_ConfigureTablesForChangeTracking_V2 drop schema [NT AUTHORITY\NETWORK SERVICE] drop user [NT AUTHORITY\NETWORK SERVICE] drop user axdbadmin drop user axdeployuser drop user axmrruntimeuser drop user axretaildatasyncuser...

  Steps: Note : Take a backup before importing .bacpac file. 1. Download SQL package from this URL (https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/dbmovement-scenario-exportuat) 2: Go to SQL package folder  3: Open CMD as administrator and go to SQL package directory 4: Run command (SqlPackage.exe /a:import /sf:C:\Users\Adminab1850da5a\Downloads\11012023\SZY-UATbackup.bacpac /tsn:localhost /tdn:AXDB_UAT /p:CommandTimeout=9999 /TargetEncryptConnection:false) 5: In this command give bacpac file directory path and give database name 6: Once bacpac file restore. Stops services (word wide web, Microsoft Unified, Data Import Export, Batch Mangement) and rename the database. 7: After restoring DB synchronization DB. 8: Run admin provisioning tool(k:AosService/PackagesLocalDirectory/Bin)