TUTI - TABLE UTILITIES Version 3.00 - November 2001 Copyright (c) 1999-2001 David Simon P. Portions copyright (c) 1999 Sergey Orlik All rights reserved. D O C U M E N T A T I O N CONTENT 1. Introduction 2. Program description 3. System requirements 4. Installation 5. Uninstallation 6. License 7. Order & registration 8. Acknowledgements 9. Contact & support 1. INTRODUCTION TUTI - Table Utilities 3.00 for Windows 95/98/Me/NT4/2000 is a very useful and powerful tool applicable to any accessible database for Borland BDE or Microsoft ODBC, therefore to almost any database. It allows you to document tables structures, advanced data transfer between different tables, intelligent databases comparison, advanced verify and search, Paradox reparation, Delphi code generation to table creation, SQL with Visual Query Builder, filter, export, pack, reindex, empty, delete, edit and much more. It is a powerful tool for database (desktop or SQL based) administrators and developers. 2. PROGRAM DESCRIPTION TUTI works with any database accessible for BDE: * Paradox, DBase, FoxPro, SQL Server, Interbase, Sybase, Informix, DB2 and Oracle, via fast Borland native drivers. * Microsoft Access via Jet Engine. * Any database compatible with Microsoft ODBC, via vendor-supplied ODBC driver. Detailed features: * Document detailed schema information of a chosen group of tables and views, including BDE low-level information. This information can be printed or exported to RTF or WRI file. It is a perfect tool to report any database schema. The program shows: * Detailed field's structure. * Detailed index structure. * Number of records. * Table type, language driver, number of validity checks and number of referential integrity checks. * And more... * Document list of stored procedures. * Advanced data transfer between two any tables, optionally creating the destination table. The two data structures can be of any type. You can select exactly what records you want to copy (manually and/or filtering), avoid null values in required fields, execute all the process under a general transaction or empty the destination table before the transfer. Transfer models can be saved. The log of process can be viewed and printed. It is a perfect tool to move data between databases and maintaining the integrity between development and real databases. * Intelligent comparison of tables, searching for schema differences, index differences, extra tables, record count differences and stored procedures differences. The log of process can be viewed and printed. It is a perfect tool to maintaining the integrity between development and real databases. * Delphi code generator to Paradox, DBase or FoxPro table's creation. The code creates tables with all their indexes, exportable to any Delphi project as a standard procedure. * Various functions on a chosen group of tables: * Obtain a list with record counts. * Verify the data and indexes. It warns if it does not exist any index or unique index. It warns if exist table names, field names or index names too long, equal to probable database reserved word or with dangerous characters (useful for detecting future migration problems). It warns if exist indexes with too fields, indexes too big or tables too big. It warns if exist too tables, fields, blob fields, indexes or records. It warns if exist tables or indexes with too fields. It warns if transactions are not supported. It warns if exist read-only tables... * Empty tables. * Delete tables. * Pack Paradox, DBase or FoxPro tables. * Reindex Paradox, DBase or FoxPro tables. * Low-level data verification of Paradox, DBase or FoxPro tables via Inprise Table Maintenance Library (TUtility32). * Low-level reparation of corrupted Paradox tables via Inprise Table Maintenance Library (Index is out of date problem, Corrupt table/index header problem, etc.). * Verify number and names of all stored procedures. * View a list of users connected to the same BDE NET DIR. * Chart of number of records. * SQL queries with many features: * Automatic generation of a normal SELECT..FROM..ORDER BY statement. * Visual SQL builder. * Generation of live queries. * Transactions. * Filters. * Standard templates. * Autorefresh. * Display memo and image fields directly on the grid. * Blobs exploration, editing, importing, exporting and printing. * Loading, saving or printing of SQL statements. * Automatic form to edit the result. * Perform calculations of numeric statistical functions over entire columns of any data type. * Information of the process. * History of querys. * Bookmarks. * Sequential searches. * Multiselection to delete records. * Print and export the resulting records to a text window, plain text file, CSV, RTF, WRI, DBF or HTML file. All columns has optimized width. * Database tree with drag-and-drop. * Execute querys at a programmatic later time. * Search text over a entire database. * In filters you can use an asterisk as a wildcard. * All functions of TUTI work through BDE predefined aliases or directly specifying the table's full filename (only for Paradox, DBase or FoxPro tables). Developed in Borland Delphi. No source code is available. 3. SYSTEM REQUIREMENTS To use TUTI you need: * Personal Computer with a Pentium or higher processor. * Windows 95, Windows 98, Windows ME, Windows NT 4.0 or Windows 2000 * VGA 800x600x256c or higher resolution monitor. Small fonts recommended. * 16 MB of RAM (32 MB recommended). * 1 MB of hard disk free space. * Mouse or other pointing device. * Borland BDE 5.0 or higher. BDE 5.X is supplied with several Borland tools, like Delphi 5.0 or higher. Alternatively, you can download it (see more details in http://www.tutisoft.com). * It uses Inprise Table Maintenance Library (TUtil32.dll, included with the product). You must use the correct version of TUtility DLL that matches your BDE Core DLL version. All versions of this DLL are available at the Inprise web site (http://www.borland.com/devsupport/bde/utilities.html). 4. INSTALLATION * Download Tuti ZIP file. * Extract all files. * Run Setup.exe file * Follow the on-screen instructions. 5. UNINSTALLATION * Click the Start button, select Settings, select Control Panel, then select Add/Remove Programs. * Choose TUTI - Table Utilities from the list, select the Add/Remove button. * Follow the on-screen instructions. 6. LICENSE This software is fully functional shareware, with trial period of 60 days. Anyone may use this software during a test period of 60 days from the day that you install it. Following this trial period of 60 days (or during it) you must register TUTI if you wish to continue to use it, or remove it from your computer. Once registered, the user is granted a non-exclusive license to use TUTI on one computer (i. e. a single CPU) at a time, for any legal purpose. The registered TUTI software may not be rented or leased, but may be permanently transferred, if the person receiving it agrees to the terms of this license. If the software is an update, the transfer must include the update and all previous versions. The TUTI unregistered shareware version may be freely distributed, provided the distribution package is not modified. No person or company may charge a fee for the distribution of TUTI without written permission from the copyright holder. All copyrights to TUTI are exclusively owned by the author (David Simon P.). You may not use, copy, emulate, clone, rent, lease, sell, modify, decompile, disassemble, otherwise reverse engineer, or transfer the licensed program, or any subset of the licensed program, except as provided for in this agreement. Any such unauthorized use shall result in immediate and automatic termination of this license and may result in criminal and/or civil prosecution. All rights not expressly granted here are reserved by David Simon P. If you do not agree with the terms of this license you must remove TUTI files from your storage devices and cease to use the product. This software and accompanying written materials are provided "as is" without warranty of any kind. Further, the author does not warrant, guarantee, or take any representations regarding the use, or the results of use, of the software or written materials in terms of correctness, accuracy, reliability, currentness or otherwise. Neither the author nor anyone else who has been involved in the creation, production or delivery of this product shall be liable for any direct, indirect, consequential or incidental damages (including damages for loss of business profits, business interruption, loss of business information and the like) arising out of the use or inability to use the product even if the author has been advised of the possibility of such damages. The entire risk as to the results and performance of the software is assumed by the user. Installing and using TUTI means acceptance of the terms and conditions of this license. 7. ORDER & REGISTRATION The registration fee for TUTI is about US $95. You must visit the TUTI homepage (http://www.tutisoft.com) to order TUTI or to see more details. You may register online on a secure and confidential server using your credit card. Also you can pay it using your credit card via fax or phone, bank transfer, cash or mailing a check. The extra benefits of registration are: * You help to perpetuate and improve TUTI and the Shareware concept: by which, first grade software is available at low cost. * Preferential treatment over unregistered users on support by e-mail (please include your registration name in the e-mail so I know right up front that you're a registered user). * You will receive notice of future upgrades and additions. * Free registration of all future TUTI 3.XX versions. The automatic registration process will send you your own personal registration code immediately after you buy TUTI. This code will unlock your shareware copy of TUTI. No hard-copy documentation or media is provided. Then you must enter your registration information (registration name and registration code) exactly as they appeared on the instructions in the registration dialog by going to the About option and pressing the button Register at the bottom of the window. You cannot substitute a different spelling for your name or use a different name. Thank you for your support of TUTI. 8. ACKNOWLEDGEMENTS Thanks to betatesters: Ricard Boix, Antonio Contreras and Jaume Vila. Special thanks to Manel Castro, Montse Estadella, Jordi Giró, Ruben Giró, Sergey Orlik and Carles Rins. 9. CONTACT & SUPPORT Please see http://www.tutisoft.com for latest versions and product information. Please report (in English or Spanish) all comments, bugs, suggestions, criticisms and problems to the author: David Simon P. david@obgi.com (Barcelona) All products and company names of this document are trademarks or registered trademarks of their respective owners.