d365collaborative / d365fo.tools

Tools used for Dynamics 365 Finance and Operations
MIT License
236 stars 97 forks source link

Update "Import a bacpac file into a Tier1 environment" topic #828

Open TrudAX opened 1 month ago

TrudAX commented 1 month ago

Hi. I think this wiki topic should be updated(at least for the current date usage)

https://github.com/d365collaborative/d365fo.tools/wiki/How-To-Import-Bacpac-Into-Tier1

Repair-D365BacpacModelFile should be added to the process. Right now, restore can't be done due to the Kill permission problem

TrudAX commented 1 month ago

Just restored a Tier2 It seems MS removed this Grant.KillDatabaseConnection.Database permission (at least for plain Tier2 databases), maybe Repair-D365BacpacModelFile is not needed anymore

FH-Inway commented 1 month ago

@TrudAX That's good to see that the Grant.KillDatabaseConnection element was removed by Microsoft.

Nevertheless, I think it is a good idea to add some guidance for Repair-D365BacpacModelFile to the How To Import Bacpac Into Tier 1. While the current issues for its use may have been resolved, @Splaxi envisioned the cmdlet as something that can also be used to address similar issues that may arise in the future. Also, even with the issues for new database backups resolved, there are presumably still .bacpac files out there that have the issues.

With that in mind, I've reopened the issue. Let us know if you would be interested in updating the How To.