Hello,
WinDbu is ok ( clipper-style ), but i need soemething more:
Converting from SQL to DBF, opening any SQL-database,
SQL-connection, DBF-Script, SQL-Script and more...
dBAdministrator was designed to simplify the access and management of DBF files.
This may be in support of application development, for general systems administration of one or many DBF files.
It provides many powerful features at the click of a button.
dBA provides all the tools needed to create, modify, index, browse, print and much more.
It has many unique features not found in other products.
The features list below shows just some of the functionality.
Full support of SQL databases been added.
It provides all the tools you need to help the migration from DBF to SQL an easy one.
Just some of the features
-------------------------------
Advanced Graphical Query Builder (XQB)
Table Explorer
Results Browser with sorting,searching and filtering
Import from DBF
Export to DBF, CSV, HTML and XML (with XSL stylesheet)
In addition to the above dBABatch is included.
dBABatch is a set ot command line tools to help administer and manage DBF Databases.
Incuded tools are:
dbfExport
dbfGrep
dbfList
dbfPack
dbfReIndex
dbfUnZip
dbfValidate
dbfZip
dbs
More features :
DBScript Editor
-----------------
The DBScript Editor and engine ( uses VOScript) is a powerful Database scripting language based on Clipper syntax
and gives the user the power to script actions and commands against DBFs and also on the active Database Window.
There is also a debugging capability.
SQLScript Editor
-------------------
The SQLScript Editor is an environment for developing SQL scripts
for MS SQL Server, Oracle and mySQL databases.
Scripts can be developed and run with the output accessible all from dBA.
Text Editor
------------
There is now an internal text file editor that is also used to edit memo
fields as well as external text files such as the output from the execution of scripts.
DBRegEx
-----------
DBRegEx now give the user of dBA the power of Regular
Expression,Soundex and Approximate searching.
This is a very powerful way of searching for data in large files.
Complex search expressions can be built and saved for repeated use.
You also get all the export options of dBA e.g export results
to DBF,SDF,text,HTML and XML formats.
XML Export option
---------------------
In addition to all the normal export options dBA now supports the XML format.
Not only does it create a well formed XML document but it also creates XSL,XLT and DTD files.
Set Window Relation
-----------------------
This feature allows you to set relation between related Windows.
There is no limit on the number of relations that can be set.
Auto Refresh
---------------
This feature allows you to set the Autorefresh of data either by using a timer
or when the Datawindow gets focus. This means that when data is
updated by other users your view will be automatically updated.
Fortress
----------
Fortress Server files are now supported.
Database Drivers
--------------------
dBASE,Clipper,Foxpro,Advantage,Fortress and also support for DBV memo files.
Database Configuration Saved
-----------------------------------
Database display information is saved on Window close.
This means that details like open index files, field widths and filters are
automatically saved and added to recent files list which can then be used
to open the database with options automatically set.
Favorites
-----------
Database Configuration details can be saved manually into a Favorites list.
The Favorites list can be used to Open, ReIndex, Pack and Validate Data
on all or selected files in the Favorites list.
DBValidation
---------------
Validation of DBF Data records with a display of all invalid records.
Hex View
-----------
Records can be displayed in a Hex View which shows the whole record
as a string and as hex values. Also the data is displayed by field.
If there are any corruptions they are hilighted in the Errors tab.
Benchmark-Tests
--------------------
Testing a database on different computers
Database creation and structure modification
----------------------------------------------------
With dBA creation and modification of Database structures is easily done
from a dialog that allows you to import structures and it also does automatic validation to prevent errors.
The modify structure dialog can be used to convert databases from OEM
to ANSI change field names and even field types preserving your data.
Index Manager
-----------------
Index and order management is done from the Index Manager.
From here you can create and change orders you can even auto generate
orders for a DBF with no indexing. From the Index Manager you can
convert from NTX to CDX or any supported format.
Low-level File Access
-------------------------
You can open DBF files low-level to do corruption checking.
dBA does a validation of the DBF header on each open and will inform
you of any errors. When this happens you can us the low-level access
to investigate the problem.
Import and Export
---------------------
Importing and Exporting data is easily done with options to select fields
and scoping of records to be copied. dBA also has the option of export
DBF files into HTML or XML web ready pages.
Searching
-----------
dBA has the usual index seek and also a Fast Find which will look for
values in any or selected fields without the need of indexes.
There is also a Memo search option. This can be used to search for values
in a particular memo of in all memos.
Unique Features
------------------
dBA has many unique features including a DBClipboard to cut and paste whole records.
DBTotals to create subtotals of values by index key.
DBCalc to automatically calculate totals,averages and minimum and
maximum values for numeric fields.
A little overview of the menue-entrys
( much more is possible, inside of the menues ) :
Regards
Uwe