Cross database scripts?

Forum for users of SQL Packager database archive utility

Cross database scripts?

Postby willgart » Thu Feb 07, 2008 2:42 pm


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?
Posts: 6
Joined: Thu Feb 07, 2008 2:16 pm

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests