Flexnet Manager MSSQL Database

[tcantor]

Is it possible to use the same SQL server database for the admin and reporting database for FNLM or is it required that they be two distinct SQL databases? The architecture diagram does make it appear that it is two distinct databases but I was curious what the ramifications of combing them would be or if it would work at all.

Thanks in advance for any feedback. New to the product.

-Todd

[ChrisG]

To clarify - are you asking about the FlexNet Manager for Engineering Applications product here?

[tcantor]

yes, specifically, the arch. diagram calls out two databases (admin, reporting) and there was internal discussion that these could use the same database so I wanted to confirm whether separate  DB's was a hard requirement before we spent too much time on it.

Thanks!!

[ChrisG · Accepted solution]

Functionally you can put the admin and reporting schema into one physical database. However at larger scales for optimal performance it is often recommended to keep the databases separate, and possibly hosted on different SQL Server instances.