Refresh database from Production Environment to Sandbox(UAT)

Sometimes due to business need, we need to refresh Sandbox environment as per Production environment.  Here LCS play a important role to perform Sandbox DB refresh. A database refresh copy the transactional and financial reporting DB of production environment into sandbox environment.

There are few important thing that we need to take care while performing the sandbox DB refresh.

1. After sandbox DB refresh, all user's disable except the admin user

2. In sandbox, as other user account disable and only admin user account is enabled only.

    Except admin user no user are able to login UAT from their account

3. Admin user first login the sandbox instance from admin account and enable the other user

    than only other user would be login sandbox client

4. If admin user forget their credential, they can update the environment administrator.

    This option is not recommendable but if there are no option to get admin credential we can update the environment administrator

5. Better to copy production data during non-business hours or peak hours to avoid PROD system performance issue

Below are the Sandbox refresh processes:

1. Login LCS - https://lcs.dynamics.com/

2. Sandbox environment (UAT) full details








3.  Maintain --> Move database








4. Maintain à Move database à Refresh database

 




 








5. After refresh database à choose source environment. In our case, we will choose PROD environment and submit 




 

 





 


Update environment administrator: This option useful after sandbox DB refresh, all user disabled except admin but using admin user if we unable to login Sandbox environment than using this option we can make any user as admin. 

Sandbox environment --> Maintain --> update environment admin

 




 

 

Comments

Post a Comment

Popular posts from this blog

Execute D365 F&O SSRS report with parameter and upload report output on Azure blob storage using X++

Image
 Execute D365 F&O SSRS report with parameter and upload report output on Azure blob storage using X++ Steps: 1. Create controller class and execute SSRS report with parameter 2. Create Azure storage on Azure 3. Create Azure storage containers and folder to store report output 4. Get Azure connection key to establish connection between D365 F&O and Azure storage 5. Convert SSRS report output into byte stream 6. Upload byte stream to azure storage How to create Azure storage, containers and folder and get Azure connection key? Login to https://portal.azure.com Go to Storage account --> Storage browser --> Blob containers How to get  Connection string ? Go to Storage account --> Security + networking --> Access Key --> Connection string Code: using Microsoft.WindowsAzure.Storage; Using Microsoft.WindowsAzure.Storage.Blob; using System.IO; public class ExampleUploadReportToBlobStorage {     public static void main(Args _args)     {  ...
Read more

Microsoft D365 F&O: Remove custom models from deployable package

Image
Sometime we deploy custom model to PROD/Sandbox and due to some reason needs to revert back custom model code. If we revert back code, code reverted back but model still exist in the  environment. the next time when we suppose to deploy new package, deployment would failed with following reason: "The selected package is missing the following modules that are currently deployed on your environment. You must create an all-in-one deployable package that contains all your code customizations and ISV solutions. More information can be found at the following link:  https://go.microsoft.com/fwlink/?linkid=2118104 . Missing module(s): [ Package1 ] ,[ Package2 ] [ Package3 ]’ (Activity Id: ‘12345XXXX’)" I will explain how to remove the custom models from your environment(PROD/Sandbox). Steps 1.  Create a deployable package from your VM(Visual studio) or download the build package 2.  Unzip the deployable package and open the deployable package folder. 3. Go to   \AX...
Read more

Generate Text/CSV/DAT file using X++ and upload on Azure blob storage

 Generate Text/CSV/DAT file using X++ and upload on Azure blob storage There are many scenario's where we want to wrap data inside the file and upload on blob storage. Following code use to generate file and upload on azure blob storage. `   public void processOperation(Contract _contract)     {         #OccRetryCount         #File         InventTrans          inventTrans;         Query                query;         QueryRun             queryRun;         str                  stringToWrite;         int                  recordCount = 0;         stringToWrite = "Customer Account Number|Invoice Amou...
Read more