Moving the E10 DB

[SteveFossey]

If you have enough space for a few VMs, definitely build a test environment first in another VM. We ran into a few issues with external integrations doing just that.

Also based on what I’m going through right now I have to say I’d hesitate to separate my Appserver and my DB.

Misspending my youth on an External BAQ using Dynamic Query in a Data Directive, only works where Appserver and Database share a machine

We’re trying to build a new way to forecast, as we sell manufactured parts assembled from purchased parts and we want to stop forecasting the manufactured items as they clog up the system with 1000s of unfirm jobs. I built a solution that works perfectly in DEV: 1 - A stored procedure runs every day and analyzes the BOMs of everything we sold, returning a table in a separate DB containing adjustments needed to our forecast; 2 - An external BAQ grabs the data from that table; 3 - A system age…