I can offer some general suggestions. First, I assume that you will be using osql or sqlcmd to execute the SQL inside of a custom action.
If you use sqlcmd, it can process "scripting variables", which are basically on-the-fly text substitions. If you are using osql, I would recommend writing your scripts to not reference a database at all. Instead of MyDB.dbo.MyTable, use dbo.MyTable. The osql command has a command-line parameter to define the database to use. If you use this parameter inside the custom action, your script will be applied to the correct database. - Don Benson - On Wed, Mar 11, 2009 at 8:09 AM, akash bhatia <911ak...@gmail.com> wrote: > hi, > > i have a scenario as described below: > 1. need to capture the DBSERVER on the fly. > 2. need to capture *DBNAME* on the fly. > 3. need to run a script which creates a database named *DBNAME.* > *4*. need to run another sql script which uses this DBNAME and run some > commands. > > now the problem i am facing: how can i update the DBNAME propery on the fly > in my SQL script ? > > any suggestions will b highly appreciated? > > Regards, > Akash > > ------------------------------------------------------------------------------ > Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are > powering Web 2.0 with engaging, cross-platform capabilities. Quickly and > easily build your RIAs with Flex Builder, the Eclipse(TM)based development > software that enables intelligent coding and step-through debugging. > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
