Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  How to automate data backup bfore install new ver

Author  Topic  jazzyb Starting Member 20 Posts Posted - 2012-12-24 : 21:19:25 Friends, I have a small VB.Net application with Visual Studio Express 2005 and MS SQL Server Express 2008. I supply .mdf file in my application to store the data of client. Problem is : Now when I am providing new version of my application and installation of this new version removes older .mdf file & and earlier data is lost. My Query is : 1. How can I automate the data backup process before installing new version of application. 2. How to execute the data backup code before the installation process.( I have the working code for data backup and restore in my application, but the client some time forget to take data backup before installation). So I want to automate this. I am using Advanced Installer (Free Version) to create .msi package. Thanks