Dynamics Link: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/dbmovement-scenario-debugdiag
In UAT server, add the development server’s public IP to Azure SQL firewall
Run this script on the master database
- sp_set_firewall_rule N'Rule name', 'xx.xx.xx.xx', 'xx.xx.xx.xx'
where xx.xx.xx.xx is the development server’s public IP
In UAT server, shutdown the AOS.
End the program “w3wp.exe” and “iisexpress.exe”
- In development sever, backup the AOS web.config under
- In development sever, edit the web.config to connect the UAT database
You need to find the database information on LCS.
Before your changes
<add key="DataAccess.Database" value="AxDB" />
<add key="DataAccess.DbServer" value="developmentDbServerName" />
<add key="DataAccess.SqlPwd" value="xxxxxxx" />
<add key="DataAccess.SqlUser" value="axdbadmin" />
After your changes
<add key="DataAccess.Database" value="xxxxxx_axdb_xxxxxxxx" />
<add key="DataAccess.DbServer" value="xxxxxxx-appdbserver-xxxxxx .database.windows.net" />
<add key="DataAccess.SqlPwd" value="xxxxxxx" />
<add key="DataAccess.SqlUser" value="sqladmin" />
In development sever, restart the AOS
Restart the program “w3wp.exe” or “iisexpress.exe”
Login the development environment and start debugging in Visual Studio
After the developer has finished the debugging,
- In development server, replace the web.config by the backup.
- In UAT server, remove the added IP from Azure SQL firewall
Run this script on the master database
- sp_delete_database_firewall_rule N'Rule name';
- Restart AOS on both development and UAT server.
留言列表