How do I migrate integrations using the SQL server adapter from prod to test without modifying them?

Summary:

I cannot migrate an integration from OIC TEST to OIC PROD without modifying the integration in production to specify the correct schema in the stored procedure page.

Content (please ensure you mask any confidential information):

I have a TEST SQL Server for OIC Test Instance and a PROD SQL Server for OIC Prod Instance. Both have a stored procedure call MyProc.

My Integration uses the SQL Server Connection SQL Server, which exists in both OIC environments but configured differently to connect to the appropriate SQL server.

My issue is that in the Stored Procedure Page, I am being asked to select a schema. In OIC Test, the only value in the LOV is TEST while in OIC Prod, the only value is PROD. So even though the