IM-SQL Database Notes
Image-Master and SQL: a Backend Connection
The SQL Server data access mechanism for Image-Master is an integrated feature enhancement to the core software. Full backwards compatibility with existing DBF based tables is provided by default which provides flexibility in deploying the SQL server features to selected workstation groups. This allows for certification testing of the new features in a production system while providing data isolation for non-participating workstations.
DB Naming Convention
If a database is SQL enabled, then "(SQL)" will appear at the end of the database name in the Select Image-Master Database screen. Some Image-Master databases can migrate to SQL while others can remain as DBF tables even after the Machine ID group has been enabled for SQL access.
In the Viewing or Scanning Module, "Using SQL Enabled Database:" will appear in the upper-left corner if the connection to SQL was successful.
Search Results Timer
In any search results screen, "SQL Server" will appear in the upper-left corner along with the estimated time it took to return the search results.
PART 1: SQL Server Program Deployment
PART 2: SQL Server Program Primary Installation