Cross database scripts?

willgartwillgart Posts: 8
edited February 7, 2008 9:42AM in SQL Packager Previous Versions

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?
Sign In or Register to comment.