Hello,
Last week I was principally working on modifying our WIX setup for installing some databases for our solution for document management. Now, we are using the WIX SQL Extension and we have everything in a transaction. Before, we were using Batch scripts and the "sqlcmd" command to install our databases.
As we install multiple databases, now each database is a feature. When the setup, the databases are not dropped. They should be dropped manually when installing a new version of our setup (only if it is possible to drop the databases). In order to do it, the user can use a script that is generated when installing our setup. As the name of databases are dynamic, this script is generated using TemplateFile for SystemTools WIX Extension provided by Application Security Inc. at Codeplex.
I have to also to make some changes to our SQL jobs deployed by setup (as the databases names are dynamic, and the jobs are executed on specific database). As the SqlScript tag does not take properties as parameter, and when using the SqlString tag, it is difficult to maintain the code in WIX file, I think the setup will deploy our standard jobs and then it will update the name and it's command.
I was working also on some bugs that were due of my modification of database last week.
And that's all.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment