Skip to main content

Posts

Showing posts with the label Azure SQL database

Copy production databse to UAT environment | D365 Finance and Operations

Here in this blog we will see how to import database of production environment in UAT for D365 Finance and Operations.In D365 Finance and Operations when you want to move production data in to your UAT environment for testing or special case where you want to perform section you need to Perform refresh database operations. Here are the steps how to refresh the databases as follows:- click on maintain and select move database In the LCS select full details option for desired project and select environment where you want to import your database and now click on maintain button as follows and select move database option as follows select methods among move database option here select "refresh database" option to import prod database into your UAT / Tier 2 or greater than that environment Here is also option point in time restore where you can restore system from previous time here you can find details about it in this  link . select source environment from where data will be imp...

How to create Azure SQL Database

Hello guys in this blog we are going to create Azure SQL Database which will be useful for many integration scenarios for D365 and other external applications. To make use of azure portal first of all you need to have azure subscription which is essential to use all the azure services.After which you just have to follow steps given below. Visit to azure portal(portal.azure.com) and from Hamburger menu or from search menu you can search for Azure SQL as follows.          And select desired database type   Select resource group and set desired database name If you have server then select server otherwise you need to create server as follows. Now select desired architecture from given sets. After this status page will open as follows which will show deployment status of database in azure. After completion you get overview of Azure SQL Database from Azure Portal Home>Azure SQL>Overview I hope this will help you to cre...