Sunday, October 22, 2017

Empty Database in your VHD All-in-one Machine - Microsoft Dynamics 365 for Finance & Operations

Hi All

As you know, in an Azure Sandbox Environment you can decide if create it with or without Data.

This is not possible when you download the VHD All-in-one machine.

In order to achieve this result from my understanding there are two options:
  1. André post, https://kaya-consulting.com/how-to-start-with-empty-ax-database-in-your-local-vm/ where you have to first of all, create the Env in Azure with an Empty Database, Backup it and move to your VHD
  2. I have Play around to the VHD Disk C and I notice a folder named “EmptyDataset” with inside a Database backup named “AxBootstrapDB_Empty.BAK”
    I have simply restore this backup file against the AX Database and set the right GUID and email id retrieved from the “old” AX Demo Data.

Till soon!

4 comments:

rajeev said...

I am stuck in step 14.

In Config template database section I have entered this information


D:\Program Files\Microsoft SQL Server\MSSQL13.SQLServer\MSSQL\Backup












When I run Script in Database Server in windows powershell
.\Initialize-Database.ps1 -ConfigurationFilePath .\ConfigTemplate.xml -ComponentName AOS

It creates database but gives error message :

Invalid backup file for database refName axDB
at c:\Infrastructure\Initialize-Database.ps1:164 char:14
throw "Invalid backup file for database refname $($db.ref..


Please let me know how can i resolve this isssue. I have tried keeping AxBootstrapDB_Empty.bak and AXDB.bak file both in given backup file path and also without any file.

Please help.

Denis Macchinetti said...

Hi Rajeev

Your query is not related to this topic..

However, in the BackupFile Tag you must fill the path plus the DB Name.
So, something like:

D:\Program Files\Microsoft SQL Server\MSSQL13.SQLServer\MSSQL\Backup\AxBootstrapDB_DemoData.bak

Anonymous said...

That is a great tip Denis but how do you "set the right GUID and email id retrieved from the “old” AX Demo Data"? Could you add some instructions?

Thank you!
Karin

Denis Macchinetti said...

Hi Karin,

before start the restore, you can backup the SYSUSERINFO, USERINFO and SECURITYUSERROLE tables
On top to the AXEmptyDatabase restore, move on the content of the previous tables.

Hope it help you
Denis