Butler SQL Users Guide

Introduction Introduction Welcome to the Butler SQL User’s Guide. This guide covers all aspects of configuring and maintaining a Butler SQL server. You should have Butler SQL installed using the instructions contained in the Getting Started Guide before reading the sections of this guide. The four separate sections of this guide describe how to use Butler SQL, ButlerHosts, and the ODBC Setup control panel to • create and manage ports, • configure Butler SQL, • connect client applications to Butler SQL, and • backup and restore data. The various options which Butler SQL provides will be discussed and demonstrated in each section of this guide. Instructions appear in bold type for quick reference; also, the instructions will be accompanied by notes, informing you of system specifics and recommended methods that will help you get the full benefit of Butler SQL. Our intended audience This guide is designed to introduce Butler SQL, DAL/DAM, and ODBC configuration to individuals who are unfamiliar with the functions and operations of a Butler SQL server. Those individuals who have never used client-server software should consult an introductory text to familiarize themselves with the general purpose and usage of such applications. 1 About Butler SQL databases About Butler SQL databases A Butler SQL database contains one or more tables. Each table has a name and contains specific columns and rows. A cell is the intersection of a row and a column. These columns list the properties of the data that may be contained in a database. Columns in a table are made up of data items of a single type. For example, in an employee table, the employee name, occupation, Social Security number, and home telephone number would each be sepa- rate columns. Every table must have at least one column and each column must be assigned a unique name in the table. A row is a collection of values which are related. A row in an employee table could consist of the employee name, employee number, home address, and Social Security number. Databases on a server can be used by many clients. When a client applica- tion is connected to a Butler SQL server, the client can access the tables of the databases located on the server. …