 |
BaseNow provides a user interface for all your databases. It looks like Microsoft Access and it allows you to work with data just like in Excel spreadsheets. BaseNow has a tree-style display of all database objects and enables you to use SQL for data management. It works with all database formats and includes deduplication, data validation, and import/export tools.
BaseNow is an ideal solution when a fast and simple access to data is required. The data may be in the form of a text file on a local computer, in an Excel spreadsheet, or on an SQL Server located on another continent - it is all the same to the program.
BaseNow works with Oracle, Microsoft SQL Server, Access, Excel, and all other ODBC and OLEDB compatible databases. The program can simultaneously display an unlimited number of heterogeneous databases, all combined in an intuitive user interface.
It is very easy to transfer the data from one database to another - all you need to do is use the copy and paste operations just like in any text editor. The program modifies the database structure, creates SQL queries and manages relationships and indexes.
Use BaseNow for:
? Mailing list management
? Deduplication and data validation
? Fast access to the data using built-in Search and Replace tool
? Contact management
? Creating new databases
? Automating database maintenance tasks
? Exchanging data between variety of database formats
databases db relational access spreadsheet search database mailing list validation export import sql statement
|
 |
GiPo@DB_Utilities is a set of utilities for Windows 95/98/ME/NT/2000/XP that provide an easy way to work with different OLE DB- and ODBC-compatible databases and data sources such as Microsoft SQL Server 7.0/2000, Oracle DBMS, Informix, MySQL, DB2, Microsoft Access, dBase, Paradox, FoxPro, Visual FoxPro and many other databases that have OLE DB providers.
Main Features:
Provides the visual browsing and editing for OLEDB- and ODBC-compatible databases.
Supports the connection to a DB using Microsoft Universal Data Link (UDL) files.
Supports the connecting to ODBC sources.
Provides the special connection dialog for the most popular databases (Microsoft SQL Server, Oracle, Inprice Interbase, FireBird, Yaffil, MySql, Microsoft Access, Microsoft FoxPro, dBase, Microsoft Excel).
Supports saving an existing connection to a Microsoft Universal Data Link (UDL) file.
Displays tables, table views, store procedure list, system tables, and system views.
Allows to view and edit the existing rows and to insert new rows.
Allows to view and edit LONG TEXT and BLOB fields.
Provides the image management for BLOB fields.
Provides the quick database navigation and search.
Allows to export rows to an external file, or to copy them to the Clipboard.
Allows to view the table information (columns, indexes).
Allows to view the stored procedure information (parameters, columns).
Provides the stored procedure execution.
Provides the SQL queries execution.
Supports the SQL queries with parameters.
Provides the table management (create table, drop table, add column, alter column, drop column).
Provides the table view management (create view, drop view).
Provides the stored procedure management (create, drop procedure).
Provides the SELECT Query Wizard.
Provides the SQL editor with the syntax highlight.
Provides the 'read-only' and 'DB editing' work modes.
Displays query results as a plain text.
gipo-db_utilities gipo-db_explorer gipo-db_console database utilities db oracle sql server client mysql
|
 |
Database Web Explorer is an universal Web-based database manager intended to work with DBMS in Internet/Intranet networks. Database Web Explorer allows you to manipulate the data stored in databases via Internet. As programm of the remote access the usual Web-browser is used. Database Web Explorer was developed with ASP technology in pure script language and does not required installation of any additional COM-components, DLL or ActiveX neither on the Web-server nor on the computer of the user. Database Web Explorer is distributed in source codes - HTML and JavaScript. Supports connections to databases through ODBC drivers and OLE DB providers. Configuration and installation of Database Web Explorer is very easy. The product works under the Web-server Microsoft Internet Information Server.
Common features:
- Very easy installation, configuration and usage
- Supports the multiuser work with DBMS
- Does not required installation of any additional COM-components, DLL or ActiveX neither on the Web-server nor on the computer of the user
- As programm of the remote access the usual Web-browser is used
- Supports connections to databases through ODBC drivers and OLE DB providers
- Compact code in pure script language
Database Web Explorer allows you:
- Connect to any DBMS via ODBC or OLE DB
- View names of tables, fields, indexes and stored procedures in database
- View definitions of fields and indexes of tables in database
- View data in tables in database
- Export data in tables to MS Excel and as SQL-script
- Add, edit and delete record in tables in database
- Execute SQL-queries to database
- Export results of queries to MS Excel
database dbms sql sql query sql explorer sql tools odbc connection
|
 |
DBReader is a hierarchical database browser with editing capabilities.DBReader provides the end user with a fully integrated set of development tools for data manipulation and data definition. Complete with a metadata view of the underlying data structure, the end user is presented with a total overview of the data environment.
main features:
1.Connect to any datasource accesible via ADO using OLE DB Provider or ODBC.
2.Browse and edit database server-specific schema objects, including tables, fields, indexes, and stored procedure definitions(now only sqlserver).
3.Metadata View of tables and views with constraints and dependencies such as primary keys, foreign keys and indexes. Column details with datatypes, default values, nullability, etc.
4.Explore database structure in a tree (tables, views, columns, indexes, procedures, etc.)
5.Enter SQL statements to query a database, and edit the result set of a query.
6.View/Edit BLOB Field(plain text,RTF,image).
7.Run scripts of unlimited length. You can load SQL command from file or save SQL command to file.
8.Syntax Hi-lighting of keywords, string literals and comments.
9.Launch the ODBC Administrator to configure the ODBC Data Source Name.
db reader database editor db utility dbreader hierarchical database browser editing capabilities
|
 |
ADO Explorer is a powerful database tool using ADO (ActiveX Database Objects) that allows you to proceed quickly and efficiently in your everyday database work.
Now comes with ready to use native SQL commands for MSSQL, ORACLE and INFORMIX servers!
Features:
- connect to any datasource accesible via ADO using OLE DB Provider or ODBC
- organize your connections in a tree and connect with a simple double-click
- explore database structure in a tree (tables, columns, constraints, indexes, procedures, triggers, foreign keys, referencing keys etc.)
- visual SQL query builder
- powerful database scripter (reverse engineer your database, transform data)
- native support for MSSQL, ORACLE and INFORMIX servers
- native support for any other SQL server is possible (you can define your own SQL commands for your datasource and explore database structure via these commands rather than using ADO schemas)
- export data results to Excel, Word, HTML, XML, DBF, RTF, CSV, DIFF, SYLK, LaTeX
- easy SQL construction (just select the tables and it generates all necessary joins)
- full featured SQL command editor (customizable color syntax parser, search/replace functions, bookmarks, unlimited text length) (see picture)
- SQL batching support ("GO" command separates SQL commands and runs them in a sequence)
- transactions support (you can run SQL commands in transactions)
- editable recordsets support (you can run SQL command in a way that produces editable recordset)
- run-time parameters support
- store your SQL commands in archive tree (either main archive or connection-specific one )
- SQL commands history
- run scripts of unlimited length
- cross-server datatypes conversion
- BLOB view/edit support
- printing support for SQL commands and results
- db owner filtering
- highly customizable environment
sql query ado database tool connection mssql server oracle informix sybase
|
 |
DBExplorer is a powerful database utility that allows you to compare any two databases and report the structural and/or data differences between them. It then enables you to synchronize the differences. DBExplorer supports any OLE DB or ODBC compliant database which includes all the mainstream databases including MS SQL Server, Oracle, DB2, Access etc.
Database Catalog
Browse a databases schema and/or data. Provides a built in reporting tool and an export to file feature so you can document the database schema and records. An SQL query wizard allows you to select particular columns and filter specific records. It can also generate SQL DDL scripts to reproduce or record the database structure.
Compare Schema
Compare the structure or metadata between two versions of a database. The objects compared include tables, columns, views, procedures, indexes and foreign and primary keys constraints. Once the comparison is complete DBExplorer presents a detailed on-screen summary. From here DBExplorer can automatically generate the appropriate SQL statements (ie, SQL DDL - Data Definition Language) to bring the database up to date. Depending on the differences detected this may be a "CREATE TABLE/VIEW/PROCEDURE" or a "ALTER TABLE ADD COLUMN?" type statement. These generated SQL statement can be saved to a separate SQL script file for later execution or applied directly.
The entire comparison results can also be saved to a document file or printed out as a HTML report.
Compare Data
DBExplorer uses a sophisticated internal hashing algorithm to report the differences between the data stored in two databases. The databases to compare do not have to reside on the same machine or even in the same RDBM system. Comparison includes records that are identical, duplicated or having the same data but different keys as well as being present in only one of the databases. Once the comparison is complete you can choose to synchronise selected records to one or other database.
database utility compare database view database database difference schema metadata compare tables compare data compare records synchronise database compare
|
 |
-
net control net component database controls ole db net control selecting colors using buttons listbox
|
 |
-
net control net component database controls ole db net control displaying schema ole db data
|
 |
-
net control net component database controls ole db net component open data source dialog return
|
 |
-
net control net component database controls ole db net control showing font names samples listbox
|
|
|
