I want to upgrade McAfee Network Security Manager 6x to 7.1.
Is there any change in database schema?
Try install and check the scheme in Program Files\McAfee\Network Security Manager\App\db\mysql
There are minor changes to the schema at every major release. New features are added to new tables and sometimes referenced via new columns in other tables.
The easiest table to look at the differences in is iv_alert as this changes at minor revisions at times as well. Do a "describe iv_alert" when logged into mysql and you can see some differences.
The upgradeprocess handles the changes in schema. As long as the upgrade instructions are followed and you upgrade between supported versions you should not have any issues.
Thank you for information.
We are using McAfee Network Security Manager 6x and We already wrote many mysql queries for 6x database and we dont want to make any changes in that.
So before upgrading I just want to make sure that is there any change in database schema.
You can generate the database schema for both versions.
So, you will see a file "myschema.bat". Run it like this:
myschema"<dbuser>" "<dbpassword>" "<dbname>"
(wheredbuser is the mysql admin user that was created during the setup)
Example:myschema "NSMAdmin" "@dmin123" "LF"
Thiswill create a document with the schema for every table in the DB commonlyrequired for 3rd-party access/queries.
Hope this can help you!