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:
- 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
- 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.
4 comments:
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.
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
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
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
Post a Comment