pok1800

pok1800 / d365-delete-db-users.sql

Created February 4, 2025 07:38 — forked from RahulSharma/d365-delete-db-users.sql

D365 - Delete db users

-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

pok1800 / SqlPackage-export

Created February 4, 2025 07:37 — forked from RahulSharma/SqlPackage-export

	cd C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\
	SqlPackage.exe /a:export /ssn:localhost /sdn:<database to export> /tf:D:\Exportedbacpac\my.bacpac /p:CommandTimeout=1200 /p:VerifyFullTextDocumentTypesSupported=false

pok1800 / SqlPackage-import

Created February 4, 2025 07:37 — forked from RahulSharma/SqlPackage-import

	cd C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\
	SqlPackage.exe /a:import /sf:D:\Exportedbacpac\my.bacpac /tsn:localhost /tdn:AxDB_fromUAT /p:CommandTimeout=1200

pok1800 / D365FO-DBSync.cmd

Created February 4, 2025 07:36 — forked from RahulSharma/D365FO-DBSync.cmd

D365FO-Database-Synchronize

	cd k:\AosService\PackagesLocalDirectory\Bin\

	SyncEngine.exe -syncmode=fullall -metadatabinaries=k:\AosService\PackagesLocalDirectory -connect="Data Source=DBServer;Initial Catalog=AxDB;Integrated Security=True;Enlist=True;Application Name=SyncEngine" -fallbacktonative=False >C:\Temp\synclog.txt 2>&1

pok1800 / d365-add-db-users.sql

Created February 4, 2025 07:36 — forked from RahulSharma/d365-add-db-users.sql

	CREATE USER axdeployuser FROM LOGIN axdeployuser
	EXEC sp_addrolemember 'db_owner', 'axdeployuser'

	CREATE USER axdbadmin FROM LOGIN axdbadmin
	EXEC sp_addrolemember 'db_owner', 'axdbadmin'

	CREATE USER axmrruntimeuser FROM LOGIN axmrruntimeuser
	EXEC sp_addrolemember 'db_datareader', 'axmrruntimeuser'
	EXEC sp_addrolemember 'db_datawriter', 'axmrruntimeuser'