I am using UAT/Demo server for development and end user testing. On UAT/Demo Server I have created 2 database, 1 for testing data and 2nd one for live data. Weekly I am restoring live data on the UAT/Demo server’s live data. I am using same instance to connect different database as and when requires. but can I create an axc file for 2 different databases with single instance.
Can anybody help me?