I am finished testing my Integrator for BA, and now I want my 3 PI Integrator D/B's promoted to my Production SQL Server. What are the steps involved in doing this seamlessly?
First we need to identify Integrator's version. If this is a new 2018 R2 on the administration page click on the Targets tab and switch for new SQL Model Database.
I found it in the User Manual https://techsupport.osisoft.com/Downloads/File/67f7005e-1881-4f6a-bd5d-747b63b00ca0 on page 45.
If the three SQL DBs you are referring to are SQL targets for Integrator views, then Anton has you covered. If you are talking about moving the the backend SQL DBs used by the Integrator:
to a new production Instance of the Integrator, my thinking is that the easiest path is to do a fresh Integrator install in Production, set up any targets you need there, and then use the view export/import feature to move the view information.
Documentation on moving views: PI Integrator for Business Analytics
It's on page 154 if you downloaded the User Guide for 2018 R2.
Retrieving data ...