A new Flexera Community experience is coming on November 18th, click here for more information.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Is there any impact in creating custom views or table in FNMP DB

hi,

 

Is there any impact in creating custom views or table in FNMP DB ?

 

will this be  impacted  in future upgrades?

(1) Solution

@emtmeta - No.  When you perform application upgrades, and additional views or tables you create within the FlexNet database tables are ignored and will remain and you run the Database Upgrade SQL Scripts.

View solution in original post

(3) Replies

@emtmeta - No.  When you perform application upgrades, and additional views or tables you create within the FlexNet database tables are ignored and will remain and you run the Database Upgrade SQL Scripts.

No impact as long as you keep 2 things in mind:

  • They are in the dbo schema - our upgrades check and abort if there are any objects in a user schema
  • Please choose a naming convention that is very different than what you see Flexera using - I typically prefix with a company specific acronym (dbo.client_mytable). You want to make sure Flexera is unlikely to choose to name an object the same thing.

 

thanks @kclausen  @dhoagland1 

Points well noted 🙂

 

It actually helps us to stretch the product capability  to more levels .

 

Cheers,

Junaid Vengadan