Upgrading an SQL Database via one click
-
I have three salesmen out on the road demonstrating our latest product on their laptops - an asp.net (1.1) application installed locally on their machine that talks to a SQL Server database instance also installed on their machine.(MSDE 2000) I would like to send upgrades to them and make the process as simple as possible for them (I can't sell - they can't program!). Carrying out the upgrade via one click would be ideal. The updates could be anything from appending a single stored procedure to creating new tables etc. Can anyone suggest a good way of doing this? Many thanks in advance.:) MJ
-
I have three salesmen out on the road demonstrating our latest product on their laptops - an asp.net (1.1) application installed locally on their machine that talks to a SQL Server database instance also installed on their machine.(MSDE 2000) I would like to send upgrades to them and make the process as simple as possible for them (I can't sell - they can't program!). Carrying out the upgrade via one click would be ideal. The updates could be anything from appending a single stored procedure to creating new tables etc. Can anyone suggest a good way of doing this? Many thanks in advance.:) MJ
I'd write a little .NET exe that has all sql database updates within it. Have a field in a table that keeps track of the database version number. In your little DBUpdate.exe, first thing you do is check the version of their database (If the table or field you keep the version number in isn't there, then you know to start at the beginning...and create the table or field). Then, just run through the updates that are less than their database version number, and update their database version number as you go.
--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters