January 12, 2010 at 8:10 am
Hey all.
I have written some update software for custom software my company provide. So when it is working, customers can request the latest version of the software, and it will download and install this.
However, one area I have not touched on yet is how to update sql server 2005 databases for changes to tables/stored procedures etc.
How is this done in practice? We are using sql server 2005 and up, and .NET is our programming platform (not that that should matter). Basically I would somehow need to create a script of my own database (new version), and compare this with the existing one, and updating what is needed, all automatically. How is this done? Is there a standard way to do this sort of thing?
Thanks, Paul.
January 12, 2010 at 10:22 am
If your are diligent during the development process to script all the changes you can include a change rollup script as part of the install for the new version. The only challenge you have there is handling if they skipped a version. The update program needs to be smart enough that if you are upgrading from 2.1 to 2.4 to apply the script for 2.2 then 2.3 then 2.4 or whatever. If you version your application it should pretty easy to figure out what version of the app goes with which sql. Hope that helps.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply