SQL Balance for SQLBase
By Desktop Software
Database Administrators, rejoice! Business owners and IT managers, take a note! Now there is no need to compare and synchronize databases run by SQLBase manually, wasting valuable and quite expensive DBA?s time. SQLBalance compares different databases, highlights the differences and synchronizes them (if necessary) automatically. The program analyzes database contents line by line, object by object, searching for differences in database structure or contents. When any are found, they are highlighted. The information about distinct objects is displayed in the form of table and as a DDL script, so understanding the differences is very easy (two panels, all database entries are side by side). Then, the databases are synchronized. There are two ways to do it ? object by object, which takes more time, but gives the administrator more control, or the entire database synchronization (with one mouse click via generated DDL script). The log of all changes is kept, so the administrator can always go back and look how the database was changed. SQLBalance requires very low system resources and disk space, yet runs so fast that it seems to break the speed of light barrier. And at 120 dollars per copy, this is the software that actually pays for itself and saves companies money, because the average pay for a Database Administrator in 2003 in the United States was $28.53 an hour.
Provectus Data Editor
By Provectus Solutions LLC
Provectus Data Editor is a great way to manage and access data in SQL databases. This product works with SQL Server, SQL Express, MSDE and MSAccess. Insert, update and delete data using a form based interface. Form based searching makes it easy to find the data that you wish to access. Text fields are automatically scanned and data added to drop downs for consistent data entry. Export data to MSAccess, CSV or XML files.
NextGeneration .NET Code Generator
By RAD Software
NextGeneration is a software development tool that saves you time and effort by quickly building database-driven applications. N-Tier solution templates for C# .NET, VB.NET and SQL get your project started rapidly. NextGeneration supports SQL Server and Microsoft Access databases. Generate stored procedures, data access objects, business service classes, DataSets and an ASP.NET web interface in minutes instead of weeks. What is your time worth?
dbAnalyst
By Seabird Software, LLC
dbAnalyst is a powerful and versatile tool for database administrators and developers. With this single tool, you can manage several databases. That means you save money and time because you don?t have to acquire and learn multiple tools for different databases. With its competitive price, dbAnalyst is affordable for any size of company or even individual developers. dbAnalyst is a comprehensive cross-platform solution, handling end to end tasks such as identification of database properties, analysis, and exporting to multiple databases. It allows for translation and analysis among databases and even different versions of databases. dbAnalyst is highly intuitive, easy to learn and simple to use. Its powerful SQL console is always on the desktop, ready for analyzing any database. With its built-in intelligence, dbAnalyst guides the user via a series of scripts, database version by database version and feature by feature. Query wizards streamline database analysis and provide flexibility for executing analysis tasks. When a situation requires the database administrator?s immediate attention, automatic database alerts are sent. dbAnalyst: the one tool for all your database analysis needs. Unique features and functions of dbAnalyst: . SQL console always on the desktop . Intelligent, cross-database tool quickly connects to target database . Guides user on what to do and how to do it . Proactively imports database properties for the user . Full schema translation and export . Supports analysis of databases to feature level . Intuitive, simple user interface . Database alerts . Multiple databases/versions supported: OracleTM (8/8i/9i), Microsoft SQL ServerTM (7/2000), PostgreSQL (7.1/7.2, 7.3/7.4), iAnywhereTM (8.0), Microsoft AccessTM, dBase, MySQLTM (4.0), CacheTM (5.0), Text Folder, IBM DB2 (8.0)
Multi-DB Querier
By Vitaliy Levchenko
Database SQL tool, which allows running the same SQL queries on multiple databases with similar structure at once. Can be used also for a single database as query and export tool. If running query returns resulting table, it can be exported to file of specified format. The tables from different databases can be either consolidated in one file or the result for each database can be exported to separate file. Possible output formats: Text (TXT), comma-separated values (CSV), dBase (DBF), XML, HTML, RTF, Microsoft Excel (XLS). The program can work with databases via BDE or ADO. It was tested on databases of the following types: Oracle (via BDE and ADO), Interbase (via BDE), Paradox (via BDE), Microsoft Access (via ADO) and dBase (via BDE and ADO). Theoretically, it can work also with other database types, supported by these two database engines. Connection parameters for each database are stored in the file of internal format, so if they are specified once, then there is no need to provide them again. The names of the most recently used SQL files are also stored. The program can run multi-statement scripts. Each statement must be separated by SQL terminating character or string, which is specified by the user. SQL queries are edited in convenient SQL editor with syntax highlighting. The most important operations can be performed also via command line.
MySQL Developer Studio
By Core Lab Software Development
MySQL Developer Studio is a flexible development environment for MySQL. MySQL Developer Studio helps you develop MySQL databases faster and presents a powerful visual interfaces interface for browsing databases, creating and modifying MySQL database objects, updating data, developing SQL scripts and stored routines, and much more. Main Advantages: - Convenient server browsing - Simple object creation and management - Advanced SQL handling - Powerful data editor - User and privilege management - Flexible database backup and restore - Easy data export - Fast direct connection to MySQL MySQL Developer Studio is a standalone application that runs with .NET Framework 1.0, 1.1, or 2.0. MySQL Developer Studio supports all features of MySQL server versions 3.2.3 and higher. Related Products: MySQL Developer Tools and MySQLDirect .NET.