How to update an existing MSSQL Database

Support, Questions and Discussions on MonitorWare Console

Moderator: alorbach

Google Ads


How to update an existing MSSQL Database

Postby alorbach » Fri Mar 14, 2003 3:48 pm

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.
alorbach
Site Admin
 
Posts: 1627
Joined: Thu Feb 13, 2003 11:55 am

New MonitorWare Database Updater Utility

Postby schmidman » Fri Sep 19, 2003 8:13 pm

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
schmidman
Avarage
 
Posts: 19
Joined: Tue Sep 16, 2003 6:50 pm

Postby tosh » Mon Jan 12, 2004 12:09 pm

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
tosh
Frequent Poster
 
Posts: 83
Joined: Fri Feb 28, 2003 3:14 pm
Location: London, UK

Postby alorbach » Mon Jan 12, 2004 12:26 pm

Hi,

I recommend to use the update function from the MWConsole, but both the MWConsole and the utility do basically the same.
alorbach
Site Admin
 
Posts: 1627
Joined: Thu Feb 13, 2003 11:55 am

Postby tosh » Mon Jan 12, 2004 12:30 pm

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
tosh
Frequent Poster
 
Posts: 83
Joined: Fri Feb 28, 2003 3:14 pm
Location: London, UK

Google Ads



Return to MonitorWare Console

Who is online

Users browsing this forum: No registered users and 0 guests

cron