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

Jump to solution

hi,

 

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

 

will this be  impacted  in future upgrades?

1 Solution
kclausen
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

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.

3 Replies
kclausen
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
Level 4 Flexeran
Level 4 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

0 Kudos