Introduction

Thank you for your interest in DB Commander 2000.

DB Commander 2000   is an all-in-one database tool. Ideal for handling many types of databases where copying/transferring of table structure and records takes place.   It can manipulate two databases, of any type, at the same time. Create duplicate copies of tables in existing databases and copy table structure and/or data across different database types - even from a query result set. Delete/empty tables, create/delete indexes or use SQL statements to perform any type of query.  Plus much more.

It's a must have database tool!

DB Commander 2000 connects to any SQL based database supported by BDE*, such as Oracle, Sybase, MS SQL, Interbase, Informix, MS Access, MS Works...

*BDE (Borland Database Engine) required and included with software.

What can DB Commander 2000 do?

   ·          View/Edit Two Tables of different database types at the same time.

·          Copy Table structure to another database with indexes intact if applicable - one or more tables at a time.

Table structure can also be created from a query result set.

·          Transfer Records across to another table – one or multiple tables at a time. DB Commander will transfer even if

the tables are not identical. This can also be done from a query result set.

·          Transfer Selected records to another table.

·          Transfer records between tables by mapping their fields.

·          Delete Tables - one or more tables at a time.

·          Empty Tables (Clear the contents) - one or multiple tables at a time.

·          Rename Tables.

·          View/Create/Add/Delete Indexes.

·          Add/Delete Columns (Fields) to existing tables and/or transfer the contents of a single column (field).

·          Execute any query, even scripts, using SQL statements.

·          Export/Import to/from a text file.

·          Preview the contents of any table including the contents of a query result.

·          Export the contents of any table to an FTP site (in text).

·          Quick comparison of count of Tables, Records, Fields, Indices & Primary Keys between databases.

For a quick handling of the above-mentioned options simply right-click on the side you wish to have

an action performed.

Note:    To connect to SQL Based databases you must connect via a BDE/ODBC alias.

            You can access the BDE Administrator from the control panel. 

            Consult the BDE Help files on how to setup a Database Alias.

            Use the File/Open dialog to open Paradox/Dbase or Interbase databases only.  

            All other databases (SQL databases) need a correctly configured alias, using the BDE or ODBC Administrator. 

 ·          Connect to a database. For SQL databases, connect using the alias drop down.

·          Select the table you want and open it.

·          From the Utilities menu choose “Create a copy of “ and choose the side on which to create the copy of the table.

         If you are creating the copy over to another database make sure you are connected there as well.

 ·          Connect to a database on both sides.

·          From the Utilities, menu choose “Mass-copy Tables” and choose the side on which to create the table copies.

·          Connect to a database on both sides.

·          From the Utilities menu, choose “Multi-Select Copy Tables” and choose the side on which to create the table copies.

 ·          Connect to a database on both sides. For SQL databases, connect using the alias drop down.

·          Select the table you want and open it.

·          From the Utilities menu, choose “Transfer Data” and choose the side on which to transfer the data of the table.

 ·          Connect to a database on both sides.

·          From the Utilities menu, choose “Mass-Transfer Data” and choose the side on which to transfer the data.

 ·          Connect to a database on both sides.

·          From the Utilities menu, choose “Multi-Select Data Transfer” and choose the side on which to transfer the data.

·          From the form simply select the tables and click transfer.

 ·          Connect to a database on both sides. For SQL databases, connect using the alias drop down.

·          Select the table you want and open it.

·          Select the records you wish to transfer. You can select them by holding the “Ctrl” key down and clicking on the records with the mouse. If the records you want to select are all in sequential order, you can hold the “Shift” key down and use the arrow keys to select them.

·          From the Utilities menu, choose “Transfer Data” and choose the side on which to transfer the data of the table.

 ·          Connect to a database on both sides. For SQL databases, connect using the alias drop down.

·          Select the tables and open them.

·          From the Utilities menu select “Mapped Transfer” and choose the From/To side.

·          Select the fields one by one from the “From” side and drop them onto the “To” fields to map them.

·          Once mapping is completed, click on the “Start Mapped Transfer” button.

 ·          Connect to a database.

·          Select the table you want to empty.

·          From the Utilities menu, choose “Empty Table”.

Note: You can mass-empty all tables from a database or do a selective emptying of the tables.

 ·          Connect to a database.

·          Select the table you want to delete.

·          From the Utilities menu choose “Delete Table”.

Note: You can mass-delete all tables from a database or do a selective delete of the tables.

 ·          Connect to a database.

·          From the Utilities menu choose “Run SQL Statements”.

 ·          Connect to a database.

·          Select the table.

·          From the Utilities menu, choose “Index”.

 ·          On the form that will pop-up you can double-click on the fields that you wish to index.

·          Name the index and click on the “Add” button.

 ·          Select the index in the index window.

·          Click on the “Delete” button.

 Note: You can view all the main details of the fields of the table you are viewing by clicking on the “Detail” button.

Tip: If for any reason the addition or deletion of an index fails, you can use the SQL Editor of

the program by clicking on the “Run SQL Statements” button and try to execute SQL commands

for the specific task.

·          Connect to a database

·          Select the table.

·          From the Utilities menu, choose "Add/Delete Columns".

·          On the form that pops-up, enter a name for the column and select the type and length of the column

 to be added and click “Add”.

·          On the form that pops-up, select the column you wish to remove and click “Delete”.

Tip: If for any reason the addition or deletion of a column fails, you can use the SQL Editor of

       the program by clicking on the “Run SQL Statements” button and try to execute SQL commands

       for the specific task.

 ·          Connect to a database on both sides.

·          Bring up the SQL editor by clicking on the “Run SQL Statements” button.

·          After executing an SQL statement that returned a result set, click on the “Create Table Over” in the “Utilities” menu. 

·          Name the table. (No extensions)

  ·         Connect to a database on both sides.

·          Select the table on which to transfer the data – opposite of the database where the query will run against.

·          Bring up the SQL editor by clicking on the “Run SQL Statements” button.

·          After executing an SQL statement that returned a result set, click on the “Transfer Data Over” in the “Utilities” menu.