MonitorWare Knowledge Base

Hi,

because many customers have a Database running with MWAgent, we decided to created a small article which describes how you can update this database to work with MWConsole.

First off all, I assume that you have the following things installed, and you have download the sql scripts from here: http://www.monitorware.com/en/download/MWConsole.MSSQL.zip

- MSSQL Server with existing database an a valid SystemEvents table
- Enterprise Manager to access the MS SQL Server.
- Query Analyzer (Installed by default with Enterprise Manager).

1. Extract the files from the zipfile somewhere .
2. Open the Enterprise Manager and select the database which holds the SystemEvents table
3. Go to the Tools menu and select SQL Query Analyzer
4. Open a file explorer, and go to the folder that contains the SQL Scripts.
5. Drag all .sql files into the SQL Query Analyzer window, and drop them there.
6. When SQL Query Analyzer has loaded all scripts, press the Execute Query button (or F5) for each script.
7. After you have done this, close the Query Analyzer and go to the tables view of your database in the Enterprise Manager. Verify that all tables are available.

If you experience any problems with this procedure, please let me know.

The Database Update Utility is now available on the following link (Read the ReadMe.txt for details)

http://www.adiscon.org/download/Monitor ... pdater.zip

Hi

I've been away for a while, and am coming back to evaluate MWConsole again - and it's gone final - well done.

First time I try and connect to my database, it asks me to upgrade it - is this safe?

Or shall I use the above utility to upgrade the database first?

--Tosh

Hi,

I recommend to use the update function from the MWConsole, but both the MWConsole and the utility do basically the same.

thanks for the reply...

I've tried and failed - I've posted a new topic with the results... and you've replied already - I'll follow this up in the other topic, thanks

--Tosh