Summary

The LaserFiche Database Migration utility does not create primary keys in the database tables for index card templates, except for the General index card template which is created by the LaserFiche system. Without a primary key, you may experience significant performance degradation when using documents with such an index card template.

Resolution

Edit the SQL tables and manually set the primary key for each template table.

To set a primary key using Enterprise Manager:

1. Click Start.
2. Select All Programs, select Microsoft SQL Server, and click Enterprise Manager.
3. Expand Console Root.
4. Expand Microsoft SQL Server.
5. Expand SQL Server Group.
6. Locate and expand the server the database resides on.
7. Under the Databases folder, locate and expand the correct database name.
8. Under the database name, click Tables.
9. In the list view pane, scroll down and find all the TD tables, for example: TD1, TD2, and so on.
10. Click on TD1, and from the Action menu, click Design Table.
11. Check to see if there is a yellow key icon next to TocId. If not, right-click on TocId and click Set Primary Key.
12. Close the Design Table dialog box and click Yes when asked to save the changes.
13. Repeat steps 10-12 for any additional TD tables.