TS DataServer for MS SQL Server lets any Thoroughbred Dictionary-IV based application read and write Microsoft SQL Server tables directly, either locally or across a network. Vertical applications written in a Thoroughbred Environment can share a corporate SQL Server database, or use SQL Server as their primary database.
How it works
The SQL Server table structure is a defined file type in the Dictionary-IV Link definition. Dictionary-IV links to the SQL Server table definitions, and from then on the application runs against SQL Server as it would against Thoroughbred files. Thanks to Dictionary-IV’s three-tier design, applications do not need to be written specifically for SQL Server.
- Automatic setup. The DataServer creates the SQL Server table from the Dictionary-IV Link and Format information.
- Local or remote servers. The SQL Server database can be local or remote, with no limits on its configuration.
Existing applications and Solution-IV
Existing applications that use Dictionary-IV can be recompiled once the Link definition is set to the SQL Server database type, and then run on SQL Server. The Solution-IV financial and distribution suite can be set up to run on SQL Server at installation.
Platforms
Thoroughbred clients can run on UNIX, Linux or Windows. On the server side, the DataServer runs on Windows servers, where a manager process runs as a Windows service and starts a server process for each client connection. The client side is part of every TS Environment installation.
How it fits
Thoroughbred offers matching DataServers for Oracle and MySQL. To keep a SQL Server copy of your Thoroughbred data current in real time, see Real-Time Database Solutions and DataSafeGuard.