I have a net application that uses a SQLite database. We need to upgrade the schema in the latest release. I am thinking that standard practice is to upgrade SQL Database in an installer? We use Wix with custom actions implemented in a NAT assembly.
Thank you,
Devices such as YX and Install Shield are only SQL (YX, installed Basic support for Shields), Oracle (Instal Shell) and My Sql (Instal Chest - Microscope Connect). There is no original in MSI and there is no other than shelf solutions for the installer.
You can definitely roll your own (hopefully data driven) custom actions to deal with this, but if I consider implementing my database servicing in your application layer This way your app is more fault tolerant and self-service without the help of the installer.
For example, if a customer was to upgrade your installer, restoring the old version of your database, your application will be able to upgrade it in the new schema itself.
Comments
Post a Comment