A D V E R T I S E M E N T
Tools & Utilities » Database Tools
SQLyog MySQL GUI - $49
SQLyog is a easy to use, compact and very fast Win32 GUI tool to manage your MySQL database anywhere in the world.
Apart from regular features like backup, query execution, admin functionalities it has many unique features like - Schema Synchronization, Schedulable Data Synchronization Utility and much more.
SQLyog was developed keep in mind the necessities of all who use MySQL as their preferred RDBMS. Whether you enjoy the control of handwritten SQL or prefer to work in a visual environment, SQLyog makes it easy for you get started and provides you with tools to enhance your MySQL experience. Navicat 2004 (MySQL Manager) for MySQL database management - Free Trial / $95
Navicat(MySQL GUI) is the most popular MySQL database management tool which can convert Excel spreadsheets/MS Access to MySQL databases, eliminating time-consuming data entry and the errors that accompany it. It uses a Microsoft Access-like interface and comes with a MySQL server Launcher and comprehensive manual that will help you to get started. It is more than just a simple MySQL admin client, other useful major features include schedule backup, data transfer, import/export wizard, support Foreign Keys, visual query builder, and visual report builder.
More than 100 new features and improvements added, user can now import data from ODBC, create Batch Job Scheduling (schedule of Import/Export, Data Transfer and saved queries) and print table structure of their designed database. Furthermore, it now supports MySQL 5.0 Alpha (support stored procedure). Automatic MySQL Backup - Free (GPL)
Using cron, mysqldump (included with MySQL) and gzip, this script will take daily weekly and monthly backups of your MySQL databases. Daily and Weekly backups are automatically rotated. Output log can be emailed to whoever is resposible for maintaining the backups. Can create a single backup file for all databases on a server or a seperate backup file for each backup. Plus a number of other features. See changelog in the script for full change history.
Rememebr to rate it.. dbQwikSync2mySQL
--- dbQwikSync Moves PC data to your mySQL Server--- Wizard steps 1)Select you source local database from: Access,dBASE,MS SQLServer, Excel, FoxPro, Paradox 2)Select your target MySQL database 3)Pick the tables to move 4) Click Sync! Highlight Features are: Easy to Use, Step-by-Step Wizard Interface; Creates tables and indexes as needed; Automatically converts data types to closest compatible type; Save SQL as Scripts Excel To MySQL Converter Agent - Free to try, 29.85$ to buy
- Excel To MySQL Converter Agent converts from Excel To MySQL server through four easy steps with self description and help through any step.
- Excel To MySQL Converter Agent has a built-in algorithms to detect the suitable data type for each field in the excel or CSV files.
-Excel To MySQL Converter Agent gives you many options during conversion steps which makes the conversion flexible.
-Try before you buy by downloading the demo version which allows the conversion of the first three rows.
Supports all versions of MS Excel.
Supports CSV files.
Supports all MySQL versions.
Convert to remote or local MySQL servers (your hosting company must be supporting remote access if you will convert to remote server)
Merges Excel or CSV sheets into an existing database or a new database.
Converts individual sheets or more than one sheet depending on your selection.
You can convert sheets into new destination database ,overwrite existing database or even merge source sheets with destination database.
You can choose separator type in case of CSV files.
Try before you buy download the Demo version which allows the conversion of the first three rows.
How to Convert Excel, Access, DBF or XML into MySQL Using Navicat
This article discusses a solution to import MS Excel, MS Access, XML data to local or Remote MySQL databases by using a famous MySQL Admin Tool called Navicat.
We very often need to import various data into MySQL databases. This becomes a tough job if we don't have a reliable & easy-to-use MySQL GUI; At times, when I am working on deadlines, this job becomes frustrating and I find myself wishing I had a tool to do this job for me.
Navicat can convert Excel spreadsheets /MS Access to MySQL databases, eliminating time-consuming data entry and the errors that accompany it. It uses a Microsoft Access-like interface and comes with a MySQL server Launcher and comprehensive manual that will help you to get started. It is more than just a simple MySQL admin client, other useful major features include schedule backup, data transfer, import/export wizard, support Foreign Keys, visual query builder, and visual report builder. Ariacom Business Reports - Freeware ($00.00)
Easy-to-use database reporting and multi-dimensional analysis tool with dynamic SQL generation.
-Native line, bar, point and pie charts
-Integrated security management limiting user access
-Fully multilingual design (currently in English, French, German, Spanish)
-Report results in various formats (html, csv, txt, xml with conversion to pdf)
-Output to various devices (file, printer, fax, email, ftp) MySQL Maestro - $129
MySQL Maestro is a powerful Windows GUI solution for MySQL server administration and database management. MySQL Maestro supports all the latest versions of MySQL, including MySQL 4.1/5.0, and all of the most important MySQL features, including views, stored procedures and functions, InnoDB foreign keys, user-definable functions, transaction-safe tables, BLOB and TEXT field types, MySQL 4.x user privilege extensions and many more. Table croozer - GPL
Whether you are a PHP, Perl or Python Developer or simply have a message Board, Guestbook or other MySQL application running on your web server, this application will allow you to quickly and efficiently search through large MySQL tables and find the stuff you're looking for directly in your Web Browser. You can View, search and sort through tables in any MySQL database, Store views, ignore columns and more. SQL Uniform - $69
SQL Uniform is a general interface (GUI), a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert).
It supports every database and database server to which there is an ODBC or JDBC standard driver.
Tested on the following databases: Access, Adabas D, dBASE, Excel, HSQL, IBM DB2, Interbase (Firebird), JDataStore, Linter (Relex), McKOI, Mimer, MSSQL, MySQL, Openlink Virtuoso, Oracle, Paradox, Pervasive (Btrive), Pointbase, PostgreSQL, Quadcap QED, Solid, SQLITE, Sybase, ThinkSQL, Yard. MySQL Turbo Manager Enterprise - 65
MySQL Turbo ManagerÍ is powerful tool for MySQL Database administration and development.MySQL Turbo Manager allows you to maintain all MySQL database objects in a simple and direct way like run SQL scripts, manage users and administrate user privileges, build SQL queries, extract, print, export , edit BLOBs, build reports , send and receive messages between developers using the application, share projects files ( SQL , XML , TXT ) by email , create developer projects and supplies others additional features that will make your work easier, also integrates PHP and Java features and code generator.
ExcelReport - $39.95
ExcelReport is an Excel report generator that outputs reports in Microsoft Excel spreadsheet format. Connects to all databases using ODBC, supports Oracle, DB2, Sybase, Informix, MS SQL Server, Teradata, MS Access, etc. Accesses database through SQL, supports multiple and different types of SQL statements (DML, DDL) in one report building process. With one time configuration, automatically generates Excel reports. MyDbConverter (Access to Mysql Converter ) - free to try , $42 to buy
MyDB Converter is designed to convert MS Access databases to MySQL or converts MySQL database into Access database, using a very easy to use wizard style interface. No need to learn any SQL code or any other technical details to use the program.
MyDB Converter main features are:
Supports MS Access 2003 and MySQL 4.0.
scheduling of conversion tasks to be performed automatically
Command line support
All common MySQL and Access data types and attributes are supported.
Full support of indexes, Auto increment, composite primary keys and Constraints.
The ability to select only the tables you want convert.
You can choose either to convert to a new database, overwrite an existing one or append you tables to an existing database.
You can choose to convert both table definition and data or definition only.
Supports both local and remote connections to MySQL server.
The ability to convert all name spaces " " in MS Access Database to underscores "_". MySQL Data Wizard - a GUI tool for MySQL data management - 89
MySQL Data Wizard is a powerful Win32 GUI utility for managing your MySQL data. It provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. MySQL Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the MySQL database, export data from MySQL tables and queries to most popular formats, and import data into the tables. Advanced DBF Repair - $69.95
Advanced DBF Repair (ADR) is a powerful tool to repair corrupt DBF files. It can scan the corrupt DBF files and recover your data in them as much as possible, so to minimize the loss in file corruption. Currently ADR supports to fix dBASE, FoxBase, FoxPro and Visual FoxPro database. Moreover, it has integrated with Windows shell, supported drag & drop operations and command line parameters, which will make you repair DBF files easily and quickly. Access2MySQL PRO - $49
Access2MySQL Pro is an efficient converter which performs MS Access (mdb) to MySQL and MySQL to Access database conversions simply by configuring several options in wizard-like application. Whether you want to copy the whole database or convert a number of tables, our program is at your service. There is an ability to save data to PHP script or to SQL Access file that allows you to get over the restrictions on access to MySQL database if any. Full Convert 1.0 Standard MySQL Edition
Full Convert provides you with comfortable way to convert data between many different databases. For highest possible speed and reliability, Full Convert uses native access to databases wherever possible. Currently, native connections are used for Interbase/Firebird, MySQL, Oracle and SQL Server databases.
Full Convert 1.0 supports following databases (future version will support even wider variety of data formats)
- Microsoft Access
- Microsoft Excel documents
- Interbase / Firebird
- Lotus 1-2-3
- SQL Server
- Delimited text files
All editions feature target database browser with multiselect which greatly simplifies certain actions.
Standard Edition supports (besides conversion itself) dropping of all tables or selected tables/columns.
Professional Edition adds a powerful action and parameters handling. Similar tools require that you make mappings from source tables and columns to target, often with cumbersome interface to handle the amount of data displayed.
Full Convert makes a swift conversion and puts you in control of target database with additional functionality which enables you to transform database and data structure with ease. Extract several columns to a new table leaving a referencing column, merging data from a table into another, renaming tables and columns and changing their properties, drop unused columns or tables, conditional data changing using your own parameters... Not to mention you can see how many records each table has so you know where your data is.
Full Convert remembers all actions and stores them in saved session file. Next time you want to convert, all you have to do is press a button and all your actions are executed after conversion over new data and with no additional work from your side
Database Generator for Internet
TreeBase Generator is a MS Windows based program which allows its users to publish new or existing databases to the Internet in a very simple and fast way. The user can decide what sort of database he/she wants to realize, and what goals he/she wants to achieve. He can also determine the appearance of the search forms.
With TreeBase Generator you will acquire predefined appearances of your sites, and you can choose designs from our list and download them for free. You will also receive a language tool for displaying the system messages in several different languages. WordReport - $39.95
WordReport is a Word report generator that outputs reports in Microsoft Word document format. Connects to all databases using ODBC, supports Oracle, DB2, Sybase, Informix, MS SQL Server, Teradata, MS Access, etc. Accesses database through SQL, supports multiple and different types of SQL statements (DML, DDL) in one report building process. With one time configuration, automatically generates Word reports. Database Management Solution - US$ 249.00
WinSQL is an ODBC compliant database development solution that streamlines day-to-day tasks related to databases. WinSQL works with any ODBC compliant database including, but not limited to, Oracle, Sybase, DB2, MS SQL Server, Informix, MS Access, MySQL, PostgreSQL, and more. WinSQL's simple, yet powerful, graphical user interface allows you to easily submit SQL queries, browse the database catalog, view the relationships among different entities, and more. WinSQL uses database specific plugins to extend default ODBC behaviour - in other words these plugins start where ODBC ends.
A D V E R T I S E M E N T
||Subscribe to SourceCodesWorld - Techies Talk