Cross database scripts?
willgart
Posts: 8
Hi,
in our solution we deploy 2 databases.
the second database use views where we merge data from the first database
select ... from DB1.dbo.table inner join dbo.currenttable ....
but the name of the databases can change during my deployment process (ie "TestDB1" "QADB1", "ProdDB1" etc...) so my views must change too!
today I'm using my own scripts to deploy this and variables. So the variables allows me to change the name of the DB1 database to reflect the real name.
How it's possible to do this using the packager tool?
in our solution we deploy 2 databases.
the second database use views where we merge data from the first database
select ... from DB1.dbo.table inner join dbo.currenttable ....
but the name of the databases can change during my deployment process (ie "TestDB1" "QADB1", "ProdDB1" etc...) so my views must change too!
today I'm using my own scripts to deploy this and variables. So the variables allows me to change the name of the DB1 database to reflect the real name.
How it's possible to do this using the packager tool?
