The Community is now in read-only mode to prepare for the launch of the new Flexera Community. During this time, you will be unable to register, log in, or access customer resources. 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

emtmeta
By
Level 7

hi,

 

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

 

will this be  impacted  in future upgrades?

(1) Solution

kclausen
By
Flexera Alumni

@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

kclausen
By
Flexera Alumni

@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.

dhoagland1
By Level 6 Flexeran
Level 6 Flexeran

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