Monday, February 27, 2023

Uninstall Store Commerce app using Power shell

 1. Search for the full package name of the current MPOS using command 

Get-AppxPackage -AllUsers

or 

Get-AppxPackage *pos* --AllUser

then find the package of the Microsoft.Retails

2. Uninstall the package using below command

Remove-AppxPackage -AllUsers <Package name in step 1>

3. Go to Control Panel to find the Commerce app and uninstall it.


Wednesday, February 1, 2023

Creat DB snapshot in order to reuse the test data

 --Taking the snapshot

CREATE DATABASE AxDB_Snapshot ON  
( NAME = <DB Logical name>, FILENAME =  
'J:\MSSQL_BACKUP\AX_Snapshot2.ss' )  
AS SNAPSHOT OF AxDB;
It took me around 2 mins to create the snapshot

--Restoring the database from the snapshot
ALTER DATABASE AxDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE AxDB from  
DATABASE_SNAPSHOT = 'AxDB_Snapshot';  
ALTER DATABASE AxDB SET MULTI_USER;

Debug in a Tier-2 (UAT) environment

 From time to time, you may have to debug a copy of the production database, but you are unable to export & import the DB to your dev ma...