I'm developing a proof of concept application this week that shows how I might organize a ClickOnce application with embedded databases. I've used DbDeploy in the past and am quite happy with it under the typical NAnt script process but I have a few changes I would need to make to successfully embed dbdeploy in a smart client.
I'd like to integrate delta scripts as embedded resources in a dll along with the providers xml. For this to work, I need to overload/extend a few classes in the core library and eliminate the File i/o requirement. In the end, the clickonce application will utilize the upgrade/downgrade capabilities of dbdeploy on a SqlExpress database every time the code is updated.
I'll make the changes and if there is interest, I'd like to submit the new capabilities for future releases of dbdeploy.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm developing a proof of concept application this week that shows how I might organize a ClickOnce application with embedded databases. I've used DbDeploy in the past and am quite happy with it under the typical NAnt script process but I have a few changes I would need to make to successfully embed dbdeploy in a smart client.
I'd like to integrate delta scripts as embedded resources in a dll along with the providers xml. For this to work, I need to overload/extend a few classes in the core library and eliminate the File i/o requirement. In the end, the clickonce application will utilize the upgrade/downgrade capabilities of dbdeploy on a SqlExpress database every time the code is updated.
I'll make the changes and if there is interest, I'd like to submit the new capabilities for future releases of dbdeploy.