Converting to the Inmagic DB/Text for SQL Platform
What Will Be Different?
The following list describes the main changes that you will see after upgrading DB/TextWorks and
WebPublisher PRO to the SQL platform.
There is a new Administration program with its own executable (InmCSAdmin.EXE).
There are fewer mandatory textbase files. These files, which reside outside of SQL Server, all have
.CXX extensions (instead of .TXX extensions):
The .CBA file (formerly .TBA) contains public forms, query screens, sets, and skeletons.
The .CAC file (formerly .ACF) controls textbase access.
The .CBS file (formerly .DBS) contains the textbase structure definition.
User files have a .CBU extension instead of a .TBU extension.
Menu screen files have a .CBM extension instead of a .TBM extension. (The DBText.TBM file that is
used by default if no other menu screen is specified is called InmCSrv.CBM.)
The records, indexes, and textbase lists (validation lists, record classes, and so on) are stored inside
SQL Server. You cannot access these files using Windows Explorer.
If you are using Windows Authentication, you must apply security settings to the control database on
the SQL Server and to each textbase. For more information about security, see the Inmagic DB/Text
for SQL Administrator’s Guide
The DBText.INI file is called InmCSrv.INI.
The deferred indexing feature is no longer necessary. Instead, a new Set Exclusive Textbase
Access/Set Shared Textbase Access command lets you toggle between setting exclusive access and
setting shared access.
Several commands on the Manage Textbases menu have moved to the Administration program. They
are: Recover Textbase, Check Textbase, Copy Textbase, Rename Textbase, and Delete Textbase.
A new command appears on the Manage Textbases menu: Clear Textbase Record Locks. This
clears the locks on any locked records (for example, locked records may occur if a power outage
happens while records are being edited).
The following commands now use a fast load mechanism and permit you to specify buffer size:
In DB/TextWorks for SQL: Manage Textbases>Load New Textbase and File>Import (using the
Express Import option).
In the Administration program: Manage Textbases>Recover Textbase, Manage Textbases>Load
New Textbase, and Manage Upgrades>Convert from DB/Text>Textbases.
Express Import now requires exclusive textbase access.
The following are no longer available in the Options dialog box (Tools>Options):
Ignore accents on extended characters. To ignore accents for searches, set the SQL collation
appropriately, either during the SQL Server installation or by using the SQLCollation parameter in
the InmCSrv.INI file. For information about the SQLCollation parameter, see the online help.
Read/write extended characters in MS-DOS format. Extended characters are always written in
If you installed WebPublisher PRO for SQL, your virtual directory is now called ics-wpd and the
DBTWPub.INI file is now called ICSWeb.INI.