I take a liberty to answer myself. I've also migrated from Access to MSSQL.
Procedure is rather simple.
1. Create Netview databases to MSSQL, it is done by running either
\usr\ov\databases\odbc\create_sqldb.bat --if you have mssql 6.5 or
\usr\ov\databases\odbc\create_sqldb7.bat --for mssql 7 (2000)
You must specify one parameter - drive letter where netview is located
Bat file creates database schemas, stored procs whatever is needed.
2. go to odbc manager, system DSN tab. (firs of course ensure that NV is not
running)
2.a _Delete_ following data sources:
Nvdbexport_ds, snmpcollect_ds and topo2sql_ds
2.b Recreate them but this time use mssql driver, usually "SQL Server", use
localhost, and specify default database as NetviewDb.
Use exactly same settings for all of them (three), only difference is the name.
Done. Start your NV daemons.
If you want to migrate existing data to SQL then I guess you have to use MS
Access for pumping.
Another thing, if youre going to build your own tools for NV DB take a good
look at nvdbexport proggie, it just exports NV _internal_ database to mssql or
whatever location. There's also some ODBC configuration is required.
Jaano Rosin
--- random quote (honestly) ---
A nuclear war can ruin your whole day.
________________________________
From: James Shanks [mailto:jshanks@us.ibm.com]
Sent: 1. september 2004. a. 17:21
To: nv-l@lists.us.ibm.com
Subject: RE: [nv-l] Using Microsoft SQL in NetView
If you have tried this and made it work, then please post your
procedure here. I only know one way of doing it.
James Shanks
Level 3 Support for Tivoli NetView for UNIX and Windows
Tivoli Software / IBM Software Group
"Leventidis Dimitris" <dil@altec.gr>
Sent by: owner-nv-l@lists.us.ibm.com
I think that it could be done via modifying the ODBC driver (to NV
server as well as to all the Workstations running the NV Consoles) from Access
DB to SQL.....
-----Αρχικό μήνυμα-----
Από: James Shanks [mailto:jshanks@us.ibm.com]
Αποστολή: Τετ 1/9/2004 4:00 μμ
Προς: nv-l@lists.us.ibm.com
Κοιν.:
Θέμα: Re: [nv-l] Using Microsoft SQL in Netview
The Windows NetView DB cannot be changed once it is
installed. You have to re-install and tell it that you want to use SQL server.
I haven't done this in a couple of versions but if memory serves me, I believe
you will be prompted when the install occurs.
James Shanks
Level 3 Support for Tivoli NetView for UNIX and Windows
Tivoli Software / IBM Software Group
Mohammed Quayum <MQUAYUM@dm.gov.ae>
Sent by: owner-nv-l@lists.us.ibm.com
08/31/2004 11:58 PM
Please respond to
nv-l
To
nv-l@lists.us.ibm.com
cc
Subject
[nv-l] Using Microsoft SQL in Netview
Hi all,
We have Netview 7.1.4 on Windows 2k Advance server.
I want to use Microsoft SQL on Netview to generate
reports. SQL is already installed on Netview server.
How I can configure NV to use SQL (Can I use the
existing SQL which is already installed on NV server).
Or do I have to un-install NV and re-install to
integrate with SQL.
Waiting for the response.
Thanks.
Mohammed Quayum
NOC Administrator
Network and Operation Section
Information Technology Department
Dubai Municipality
Contact# 009714-3011-759.
Our Vision
To create an excellent city that provides the essence
of success and comfort of living.
Disclaimer:
This Electronic Mail and any files transmitted with it
are confidential and intended solely for the use of the individual or entity to
whom they are addressed. If you are not an addressee, or have received the
message by error, please notify the sender via E-Mail or over the telephone and
delete this e-mail. You are not authorized to read, copy, disseminate,
distribute or use this E-Mail or any of its attachment in any way. Any views or
opinions presented in this email are solely those of the author and do not
necessarily represent Dubai Municipality. The recipient should check this email
and any attachments for the presence of viruses/worms. Dubai Municipality
accepts no liability for any damage caused by any virus/worms transmitted by
this email.
Dubai Municipality, Dubai, UAE, http://www.dm.gov.ae
<http://www.dm.gov.ae/>
|