TUTI - TABLE UTILITIES Version 2.11.275 - November 2000 Copyright © 1999-2000 David Simon P. 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 v2.11.275 for Windows 95/98/Me/NT4/2000 is a very useful and powerful tool applicable to any accessible database for BDE (Borland Database Engine) 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, Paradox reparation, Delphi code generation to table creation, SQL queries, filter, export, pack, reindex, empty, delete, edit and 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. 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: 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. SQL queries with many features: Automatic generation of a normal SELECT..FROM..ORDER BY statement. 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. Information of the process. History of querys. 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. 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. This program is so simple, no help is needed. 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 NT 4.0 or Windows 2000 VGA 800x600x256c or higher resolution monitor. Small fonts recommended. 16 MB of RAM (32 MB recommended). 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.obgi.com/delphi/tuti). 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 $79. You must visit the TUTI homepage (http://www.obgi.com/delphi/tuti) 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 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 Customer Number and Registration Code 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 2.XX versions. Once I receive your registration I will send you an e-mail with your own personal registration number and information (therefore you need a e-mail account) as soon as possible. This code will unlock your shareware copy of TUTI. No hard-copy documentation or media is provided. If you have submitted a registration and haven't received a reply, you can email me at david@obgi.com to check up on the status of your registration. 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ó and Carles Rins. 9. CONTACT & SUPPORT Please see http://www.obgi.com/delphi/tuti 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 Catalonia Spain All products and company names of this document are trademarks or registered trademarks of their respective owners.