Hello there!
I have a test environment in dataverse called TEST-ICC.
In this place I login with my test user test-user-icc@outlook.com.
I create an unmanaged solution called ICC-SOL.
I create some virtual table that read a sql db called SQL-TEST-ICC (that stay in a test server called SQL-TEST-ICC-SERVER).
In this environment I also create a ModelDriven app that use the virtual tables.
Now I want to deploy in PROD.
There I have an environment called PROD-ICC.
I also have a sql prod db called SQL-PROD-ICC (that stay in a test server called SQL-PROD-ICC-SERVER).
I will use a user prod-user-icc@outlook.com.
I successfully deploy the solution ICC-SOL as managed.
When I deploy the solution I choose to create the sql connection reference with the prod user prod-user-icc@outlook.com.
Of course now my virtual table are pointing to the sql db SQL-TEST-ICC.
Is there a way to edit the connection reference in a managed solution, so I can read a different sql server and db?
Do you have any suggestion?
Regards,
dignus