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.
| Author |
Topic |
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
 Posted - 2009-03-20 : 12:15:13
|
| Let's say you've created a product built on the Microsoft BI Stack (SQL Server 2005, Analysis Services, PerformancePoint/ProClarity)....Let's say your product is a huge success and installed around the world.Let's say you found and fixed a bug in a Stored Procedure.How would you go about distributing this "Hotfix" to your vast user base? (Let's presume that distributing a .sql file and instructions like, "Open Management Studio, connect to database as a user with rights, execute script" will result in countless frustrating hours of support calls.)Jayto here knows when |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-20 : 12:21:16
|
| is the backend db under your control or has that also being shipped to clients along with product? |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2009-03-20 : 12:52:29
|
| I never said it was "me" ... :)shrink-wrapped, shipped, under the control of and running at the client's location and on the client's hardware.Jayto here knows when |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-20 : 13:06:02
|
| i meant does your organisation support it or is it upto client? |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2009-03-20 : 13:19:29
|
| Yes, the organization does support it; however, it is under the "control" of the client. That is to say, physically and/or virtually going to each client and re-compiling the proc is out of the question. Something needs to be made available to each client, probably via web or ftp download that the client can run themselves.If this were a windows application, then using a Windows Setup Project in Visual Studio to create an MSI installer would be an easy and effective solution. However, with a SQL Server application, that approach seems to add some undue baggage.Jayto here knows when |
|
|
|
|
|
|
|
|
Release Management