You are viewing limited content. For full access, please sign in.

Question

Question

Create new tables in LFForms Database

asked on December 19, 2016 Show version history

I want to create tables that will store questions for dozens of training forms that I want to convert from PDF to Laserfiche forms. Should/Can I create new tables in the LFForms database  or should I create/use a separate DB? If a Forms upgrade is performed and will my new tables be affected?

What is recommended? 

0 0

Answer

SELECTED ANSWER
replied on December 19, 2016

Chris,

What Xavier is saying is that you should NOT create tables inside ANY database that is used to run any production software like Laserfiche. It's a recipe for disaster, because if there's ever a version update that adds a table to the Laserfiche, Workflow, or Forms databases with the same name as the new table you created you could blow up the whole system.

You need to create an entirely new database called something like 'DataLookupTables' specifically for the purpose of storing external data tables. If you don't understand what we're talking about, I recommend you consult your VAR or a DBA for assistance.

1 0

Replies

replied on December 19, 2016

You should create your tables in the "External Tables" database not in the Forms database.  

2 0
replied on December 19, 2016

Should I create separate instance or can this "External Tables" db run on the Laserfiche SQL server?

0 0
replied on December 19, 2016

The db should already exist on your sql server

0 0
replied on December 19, 2016

There is no "External Tables" db on our SQL server. 

0 0
replied on December 19, 2016

Then you should create it.

0 0
SELECTED ANSWER
replied on December 19, 2016

Chris,

What Xavier is saying is that you should NOT create tables inside ANY database that is used to run any production software like Laserfiche. It's a recipe for disaster, because if there's ever a version update that adds a table to the Laserfiche, Workflow, or Forms databases with the same name as the new table you created you could blow up the whole system.

You need to create an entirely new database called something like 'DataLookupTables' specifically for the purpose of storing external data tables. If you don't understand what we're talking about, I recommend you consult your VAR or a DBA for assistance.

1 0
replied on December 19, 2016

That makes complete sense. Thanks for clarifying.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.