One SQL Server has both databases
Databases DB1_QA and DB1_TEST
Database RP has a view vw3
vw3 consists of
select * from DB1_TEST.dbo.Sometable
Crystal Report calls the view select * from v3
When the developers want to test QA they are having to change the view vw3
select * from DB1_QA.dbo.Sometable
I looked around and there are context sessions or use contexts, or RxSqlServerData features.
Is there any way to "pass in a parameter to dynamically change the Databasename from DB1_QA to DB1_TEST
I know you can do this with stored procedures and I could set up another database and make the databases DB1_QA become DB1
That is a cost of two SQL Server Licenses.
Any thoughts would be appreciated.