Create the VM

Access LCS with an Administrator account and click on your project

Click on “Cloud-hosted environments”

Click on “Add”

Choose D365FO Version

Set Environment name and click on “Advanced settings”

Check these settings

Check these settings

Click Next
Wait 6-7 hours until completion

Once completed click on “Local Accounts” (a remote desktop session will open) and access with User and password defined on this section
Configure Visual Studio

Access the virtual machine, configure and open visual Studio.
Click on View –> Team Explorer

Click on Manage connection –> Connect to a project

Connect to your TFS environment

Click Cancel
IMPORTANT!! DON’T CLICK “Map&Get”

By clicking on Source Control explorer you’ll see the entire environment

Click on “Workspaces”

Click on your workspace environment and click on “Edit”

Now you have to map your Source control folder for Metadata

Now set Local folder “K:\AosService\PackagesLocalDirectory”

You’ll get this.

Now you have to map your Source control folder for Projects

Now set Local folder for Projects (in this example C:\Users\Admin95bf664719\Documents\Visual Studio 2019)

Click on “Get latest version” to download all datas locally

This is the final configuration

Click on “Close”. Confirm download of repository file by clicking “Yes”

Wait until download is completed.


Build all models. This operation could take several hours….
Override existing DB
Now If you want you can override the existing empty environment database with a backup copy of your UAT or Production Environment Database.
To do that you can download your DB backup from LCS

So opena again LCS and click on “Asset library”

Click on db backup and download it
…Wait several minutes…

After download is completed Go to to this link https://docs.microsoft.com/en-us/sql/tools/sqlpackage-download?view=sql-server-ver15 and download “Windows .NET Core” Zip file and extract it to a folder

Open a cmd prompt window and paste this script
SqlPackage.exe /a:import /sf:C:\Users\Admin95bf664719\Desktop\UATbackup.bacpac /tsn:localhost /tdn:AxDB_fromUAT /p:CommandTimeout=0
where C:\Users\Admin95bf664719\Desktop\UATbackup.bacpac is the path of the backup file and AxDB_fromUAT is the target DB

…..Depending on your DB size this operation could take up to 4 hours…..
After completion you have to switch the current database with the one
To do that rename the current AxDB in AxDB_OLD and the AxDB_fromUAT in AxDB.
Before renaming you must disable 3 services and do some SQL script
Open Services and temporary disable these 3 services

Now open a new SSMS session, connect to AxDB and launch this script to rename the current AxDB to AxDB_OLD
ALTER DATABASE AxDB
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE AxDB MODIFY NAME = AxDB_OLD
ALTER DATABASE AxDB_OLD
SET MULTI_USER WITH ROLLBACK IMMEDIATE

Then manually rename the new AxDB_fromUAT to AxDB
Remember to restart the 3 previosly disabled services
Now you can connect to your D365FO cloud hosted environment

Comments
Post a Comment