How to upgrade ?

Nov 12, 2008 at 10:22 AM
Hello,
First, thank for this new release about SQL Server Health & History,

My question is : how to upgrade an installed old version of SQLH2 ?
I upgraded my version with the H2Setup_Debug.msi and H2Setup_Retail.msi package.

Finaly the reports are not running now, can you please explain about the installation ?

Y tried to install the package sqlh2-5394.zip, Visual Studio reply that the application are not installed, can you please explain how it's works ?

Thank for advance.
Nov 20, 2008 at 12:01 AM
Sorry for being quiet.
Actually there is no specific Upgrade path.
You can install SQLH2 on another computer or to a different folder. Then you can copy your existing H2Config.xml to the new location. Then if you run SQLH2 from the new location it should just work, adding data to the existing repository. It should not affect your reports in any way. If you have a scheduled task you would need to alter it to point to the new executable.
I don't know why your reports are not working. If you didn't do something to your repository database nothing else could affect your reports.

I'm not sure what you mean by installing sqlh2-5394.zip
I guess if you just unpack it you could work with it. Do you have VS 2005?
There are other ways to work with source code on CodePlex. You'll have to follow CodePlex instructions. I don't think I could explain it better, and I'm not an expert there.