Four years ago I wrote a script which changed server and database names embedded within SQL views after a live Microsoft Dynamics GP company had been copied into a test one. This script is used by a client as one of several which are all run when they refresh live into test, but they also sometimes use it when copying databases between a live server and a test one.
They recently ran it when…
Continue Reading azurecurve’s Article on their blog
SQL Script to Alter Server, Instance and Database References in Views After Copying Microsoft Dynamics GP Databases To A New Server
Four years ago I wrote a script which changed server and database names embedded within SQL views after a live Microsoft Dynamics GP company had been copied into a test one. This script is used by a client as one of several which are all run when they refresh live into test, but they also sometimes use it when copying databases between a live server and a test one.
Blog Syndicated with azurecurve’s Permission
More About This Author
Array
Dyn365GP2023.01.30New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Use Business Events To Notify And Trigger External Systems- Dyn365GP2023.01.30New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Series Index
- Dyn365GP2023.01.27SQL Scripts for Microsoft Dynamics GP: PO Receipt History View
- Dyn365GP2023.01.27SQL View to Return the Accounting Period Starting and Ending Dates in Microsoft Dynamics 365 Business Central
