Mssql Database and Microolap Database Designer For Mysql Software for Windows

SiteMech Database Manager
$0 - Site Mechanics

SiteMech Database Manager is a part of SiteMech Web Development Framework. This is a small and useful tool for backup and exchange data between Microsoft SQL Server and MySQL databases. It allows to export entire database or particular tables to XML file. Later you can import saved file to a local or remote database. The software allows direct data transfer between MSSQL and MySQL databases. SiteMech Database Manager support database connection string favorites allowing to reconnect to often used databases quickly. For MSSQL database, binary full-database backup is supported.

---

---

DBSync for FoxPro & MSSQL
$69 - DMSoft Technologies

DBSync for FoxPro & MSSQL is a database synchronizer which performs MS FoxPro to MS SQL and MS SQL to FoxPro database conversion and synchronization simply by configuring several options in a wizard-like application.

DBSync for FoxPro & MSSQL gives you a chance to not only convert your data with synchronization, but also to choose a particular number of tables to be converted and organize application work using command line parameters, choosing whether to copy the identical records from source database to the destination database or not.

One of the key things of database managing is the ability to filter data during conversion. Integrated data filters allow users to retrieve only specific data for converted tables according to defined filtering criterias (conditions). Filters give you more control on data migration process.

The Scheduler gives you the opportunity to run the program and any other application on a user defined schedule. You can run programs without user input after having scheduled it just once.

---

---

OmniAudit
$399 - Krell Software, Inc.

OmniAudit automatically and transparently tracks changes to data in any column of any table in your Microsoft SQL Server 7.0 or 2000 databases. Simply select the tables and columns you want to audit, and OmniAudit does everything for you. OmniAudit captures changes regardless of the application used to change the data: a commercial software package, an in-house application, or even the native tools provided with SQL Server such as Query Analyzer?OmniAudit catches it all and records what data was changed and who changed it.

OmniAudit not only captures before and after values for each changed column, but also identifies: the user, date and time, the workstation used, and the application used to make the change.

You decide which tables and columns to audit; OmniAudit automatically generates triggers to maintain an audit trail of all inserts, updates, and deletes made to that data. OmniAudit is a completely server-side solution which requires no modifications to any client software.

Data auditing can be valuable to an IT organization in a number of ways:

* Database administrators can more easily troubleshoot and track down the origin of data corruption.

* Organizations with internal or regulatory requirements for following the history of data can do so easily, even if their software doesn't already handle this requirement.

* Software developers can more easily develop and debug applications by tracing how data gets changed by any particular function of the software. Find unintentional side-effects faster and easier.

* Quality Assurance functions can validate data altering features more quickly and with greater accuracy.

Using OmniAudit Log Viewer, you can quickly and easily sift through the compiled audit log history in a number of ways. Filter audit log data on date/time, table/column, user, workstation?any of the key variables tracked by OmniAudit. Audit log data can be exported to standard file formats including text, Excel and XML.

---

Database Comparer VCL
$239.99 - CleverComponents

Database Comparer VCL (DBC VCL) compares and synchronizes databases structure (metadata) and table data for many popular databases.

Currently supported databases: Oracle, MSSQL, MySQL, InterBase (FireBird, Yaffil), Sybase, Postgre SQL. This list is constantly updated and support for other databases will be added soon.

Most popular database engines such as ADO, BDE supported directly. Also database specific libraries such as IBX, FIB, IBO, ZEOS, AnyDAC etc supported as well.

The library includes more than 25 components for Database development and its code is constantly being refined and improved.

Features at a glance:
- Can compare database with database, database with SQL/DDL script and SQL/DDL script with SQL/DDL script.
- Can compare and synchronize data between two database tables.
- Extracting the database metadata.
- You can optionally select which objects (domains, tables, procedures, triggers etc.) should be compared.
- Royalty free licensing. Free Unlimited Email support.
- Fully-indexed help documentation. Delphi, C++Builder and Visual Basic demos code.

Database Comparer VCL library comes with full sources (demo versions does not have sources), detailed help and demo projects.

---

microOLAP Database Designer for MySQL
$124.95 - microOLAP Technologies LTD

MicroOLAP Database Designer for MySQL is a visual development system intended for database design, modeling, creation, modification and reverse engineering in an easy and powerful way.

It not only accelerates and makes the process of database creation clear, but also simplifies database maintenance.

MicroOLAP Database Designer for MySQL is specially developed for popular MySQL database and takes into account its features:

various MySQL tables types: InnoDB, BDB (Berkeley DB), MyISAM, ISAM...
MySQL references (InnoDB tables only: only this MySQL table type supports references);
all MySQL field types (including MySQL ENUM and SET fields).
Certainly, MicroOLAP Database Designer for MySQL supports ANSI-92/ANSI-99 and MySQL SQL syntax extensions.


MicroOLAP Database Designer for MySQL allows you to construct your database in easy-to-understand visual environment by working with graphical representation of tables, columns, relations and so on.

Finally you will get Physical Entity Relationship Model (ER Model) that can be exported in SQL script, or directly built on working MySQL database server.

After your database model/diagram is modified, you can synchronize existing MySQL database with it.

This product allows to extract tables, attributes, relationships, indexes and other objects from existing databases including MySQL, Microsoft Access and Sybase ASE/ASA, Oracle, Informix, MSSQL, DB2, DBF and many others that accessible through OLEDB or ODBC and import (reverse engineer) them into your diagram.

You can generate reports with complete information about a developed model/diagram in printer-friendly HTML view.

---

Database Migration Tool
$50 - Cirdir Soft

Database Migration Tool is one of the most powerful applications based-windows platform database management. The software can manage MSSQL, Oracle, Access, Excel and DBF databases. It easily see table structure and data. It can easily import and export data. The Database Migration Tool can query data and execute command used direct SQL statements, more easily debug SQL syntax errors and logic errors. You do not have to install the other components to use these features.
The Database Migration Tool allow you easily importing and exporting data from one database to another database. You can import or export one selected table, or all the tables. When you are finished importing and exporting, it automatically updated database members. In addition, it can delete one selected table or delete all the tables. It allows you to easily manage your database objects.
The software is a Windows client database query and management tool. It allows you easy navigation to your database objects. It allows you to intuitively know the relations between the code and SQL database.

---