Dynamic fields table -- can it be stored in the repository database?

SELECTED ANSWER

replied on September 14, 2017 • Show version history

I would expect that modifying the Laserfiche database wouldn't be recommended at the very least because updates could change things and possibly cause issues.

What we've done in our environment is create separate/dedicated databases for our data source tables, in many cases on the same SQL server. I don't think you'd really gain much from having it in the actual LF database.

On a side note, that may open up a can of worms because linking that data source would give access to ALL of the tables so it increases the odds of mistakes that could impact performance.

0 0

replied on September 14, 2017

Thanks. We are going to create the dynamic fields table(s) in a separate database.

Laserfiche documentation seems to indicate that they are not against creating such tables within the repository database -- see this link.

https://www.laserfiche.com/support/webhelp/Laserfiche/10/en-US/administration/#../Subsystems/LFAdmin/Content/Creating_an_External_Table.htm%3FTocPath%3DLaserfiche%2520Administration%2520Guide%7CMetadata%2520Administration%7CFields%2520and%2520Templates%7CTemplates%7CDynamic%2520Fields%7CCreating%2520an%2520External%2520Table%7C_____0

However, our VAR said no -- they want us to use a separate database.

0 0

Question

Question

Dynamic fields table -- can it be stored in the repository database?

Answer

Replies

Sign in to reply to this post.