Database Table Creation

FlexNet Manager Suite 2022 R2 (On-Premises)

The staging server requires an operating version of Microsoft SQL Server 2012 or later. Any edition is suitable, including Microsoft SQL Server Express (if its limitations on CPU, RAM, and database size are adequate for your purposes). As described in Choosing a Staging Server, the staging database may be located on a separate staging server, or on your central (on-premises) operations databases on your FlexNet Manager Suite server.

In the SQL\ subdirectory of your unzipped adapter archive, the script ADDM_staging.sql is provided for creating the staging database, its tables, and its stored procedure. Obviously, this must be run on the SQL Server instance that is to host the staging database.

Important: If you have been using an earlier version of ADDM, and are now migrating to BMC Discovery release 11 (or later), you must run the same ADDM_staging.sql script to update your staging database schema. If you are continuing to use ADDM release 10 (or earlier), the update to the staging database schema is not required, and you may omit it for now; but if you choose to apply the upgrade now (so that the staging database is prepared for any future migration to BMC Discovery 11 or later), you must also use the latest version of the FnmpADDMStage.exe executable from the same Adapter Tools for FlexNet Manager Suite 2022 R2.zip archive. This executable transfers BMC Discovery data (for any BMC Discovery/ADDM version) to the staging database, and is schema-aware for the upgraded staging database.