How to export bacac file

 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

drop user axretailruntimeuser

drop user axdeployextuser


--Tidy up the batch server config from the previous environment

DELETE FROM SYSSERVERCONFIG


--Tidy up server sessions from the previous environment

DELETE FROM SYSSERVERSESSIONS


--Tidy up printers from the previous environment

DELETE FROM SYSCORPNETPRINTERS


--Tidy up client sessions from the previous environment

DELETE FROM SYSCLIENTSESSIONS


--Tidy up batch sessions from the previous environment

DELETE FROM BATCHSERVERCONFIG


--Tidy up batch server to batch group relation table

DELETE FROM BATCHSERVERGROUP


-- Clear encrypted hardware profile merchant properties

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

After that bacpac file will be exported successfully.


Comments

Popular posts from this blog

Assembly reference containing type is not referenced, Object 'CLRObject' could not be created

Open Packing slip posting form when updating Generate picking list

Extract data of PO from the System in Ax 2012