Restore UAT DB in Teir 1 Using DFO Tool

-

Here's how you can restore the UAT DB in Tier 1 using the DFO tool script:

  1. Open Windows PowerShell ISE.
  2. Run the below command:
Please note instal DFO tool in the tier 1 enrvioment first :- 

https://github.com/d365collaborative/d365fo.tools/blob/development/docs/Enable-D365User.md
=========================================================================

Write-Host "Get bacpac"
$currentDate = Get-Date -Format yyyyMMdd
$downloadPath = "J:\MSSQL_BACKUP\MockGL{0}.bacpac" -f $currentDate
$newDBName = "AxDB_{0}" -f $currentDate

 

Invoke-D365AzCopyTransfer -SourceUri "https://d365opsastey7emzowmgccv.blob.core.windows.net/81943951-e06d-4a0a-8780-6d12458ef954-c4a28672/0qRPInM8fa2QNEE7z0aNj9?skoid=9ef30196-cd78-4a47-955e-89a3947f0a23&sktid=975f013f-7f24-47e8-a7d3-abc4752bf346&skt=2024-01-17T12%3A35%3A23Z&ske=2024-01-20T13%3A35%3A23Z&sks=b&skv=2023-11-03&sv=2023-11-03&st=2024-01-17T12%3A35%3A23Z&se=2024-01-20T13%3A35%3A23Z&sr=b&sp=r&sig=abevcO9TIFnvzEZRxzYv6KZJhoDIcxF%2Fq0nFva5bluw%3D" -DestinationUri $downloadPath

 

Write-Host "Update model file"
$path = "J:\MSSQL_BACKUP\model\model.xml"
$pathUpdated = "J:\MSSQL_BACKUP\model\model_updated.xml"

 

Export-D365BacpacModelFile -Path $downloadPath -OutputPath $path

 

Get-Content -Path $path | ForEach-Object {$_.Replace('<Property Name="AutoDrop" Value="True" />','')} | Add-Content -Path $pathUpdated

 

Write-Host "Import Bacpac"
Import-D365Bacpac -ImportModeTier1 -BacpacFile $downloadPath -ModelFile $pathUpdated -NewDatabaseName $newDBName -ShowOriginalProgress -Verbose

 

Write-Host "Stop all AX Services"
Stop-D365Environment -All
Write-Host "Waiting 60 seconds, just to make sure that all services are really stopped..."
Start-Sleep -Seconds 60

 

Switch-D365ActiveDatabase -SourceDatabaseName $newDBName

 

Write-Host "Start DB Sync"
Invoke-D365DBSync -ShowOriginalProgress

 

Write-Host "Start all AX Services"
Start-D365Environment -All
Write-Host "Waiting 60 seconds, just to make sure that all services are really started..."
Start-Sleep -Seconds 60

 

Write-Host "Enable users"
Get-D365User -ExcludeSystemUsers | Enable-D365User

===================================================================

This will helps to restore the DB and sync also and also enable all the user 

Comments

Post a Comment

Popular posts from this blog

Customization on Sales invoice Report in D365 F&O

-
 We have a requirement to create a new design and show some new fields in the sales invoice report.  So for that we need to consider the below steps :-  1) Controller class than extends standard class and create alogic. 2) Create a print management class to call the new design. 3) Extension of DP class to write a logic. 4) Report design. ==================================================================== 1) Controller class : -  /// <summary> /// Extension of the controller class to call the custom design of report "MMSSalesInvoice.report" for MMS legal entity. /// </summary> class MMSSalesInvoiceController extends SalesInvoiceController {        public static MMSSalesInvoiceController construct()         {             return new MMSSalesInvoiceController();         }         public static void main(Args _args)         { ...
Read more

75) COC - Create a coc of the table modified method

-
 /// <summary> /// The <c>AvaEntAssetChecklistVariableOptionsDbt_Extension</c> contains the TransMountain extending logic for the <c>EntAssetChecklistVariableOptions</c> table. /// </summary> [ExtensionOf(tableStr(EntAssetChecklistVariableOptions))] final class AvaEntAssetChecklistVariableOptionsDbt_Extension {     /// <summary>     /// Processes the modified field event for TransMountain fields.     /// </summary>     /// <param name = "_fieldId">reference to field id</param>     public void modifiedField(FieldId _fieldId)     {         EntAssetChecklistVariableOptions entAssetChecklistVariableOptions;         next modifiedField(_fieldId);         // Default must be marked for only one check list line for the varaible.         if (_fieldId == fieldNum(EntAssetChecklistVariableOptions,...
Read more

46) D365 FO: SHAREPOINT FILE UPLOAD USING X++

-
Image
Requirement : Uploading a file in Sharepoint online using X++ and inside from Microsoft Dynamics 365 finance and operations. Prerequisites: The current user id of Microsoft Dynamics 365 Finance and operations should have proper rights and privileged in Sharepoint Online. Sample Code: In this scenario i am creating a text file in Microsoft Dynamics 365 finance and operations and then uploading its memory Stream in Sharepoint online using X++ . You can modify the X++ code in D365 finance and operations as per your need. class RunnableClassRun { /// /// Runs the class with the specified arguments. /// /// The specified arguments. public static void main(Args _args) { System.UriBuilder builder = new System.UriBuilder(“ https://XXXXXX.sharepoint.com&#8221 ;); str extId = xUserInfo::getExternalId(); Microsoft.Dynamics.AX.Framework.FileManagement.SharePointDocumentStorageProvider provider; Microsoft.Dynamics.AX.Framework.FileManagement.DocumentLocation documentLocation ...
Read more