Most Popular Scripts | Tools & Utilities | Database Tools

Access-PHP-MySQL-Magic is a Powerful database utility that can easily perform the following tasks: Import your Access database to MySQL, Even if a direct access to your MySQL database is denied (no sufficient privileges) Store your Mysql database in a PHP script or in a SQL file for making database backups Create a dump file from any access database or MySQL database Retrieve your MySQL database imported directly into an access file instantly Backup file type: *.sql -> for mysql, *.txt for ms access, and *.php for executing your backup from your website. Support for windows scheduled tasks to be performed automatically. Upload/Download your data dynamically.

Powerful easy to use tool syncs data and tables between databases. Converts between different database types Move from MS SQL, MS SQL Sever Express, MS Access, MySQL, Excel, Paradox, Foxpro, DBase to mySQL, MS SQL, MS SQL Express or MS Access. Creates table and indexes automatically. You can clone and design new tables. Maps columns of unlike tables. Imports/Exports SQL Scripts, XML, Excel, CSV and HTML. Reports on table schema.

Data recovery. This software is meant to restore corrupted MS Access databases. After have been run, it attempts to extract all integral information. All the information that had escaped destruction, is stored inside a new database. The program work time is approximately equal to 1 hour per 50 MB of the database size. (using Celeron 1.1 GHz, 128 MB under Windows 2000 Server)

MySQL 2 Excel KonvertR is a small application that automatically exports the entire contents of a MySQL Database to an Excel Workbook, without using ODBC. Features: All tables of MySQL database converted simultaneously; Column headings in each Excel Worksheet named after the MySQL table's Field Names; Excel Worksheets named automatically after the MySQL tables in the database; Excel Worksheets ordered alphabetically in the Workbook; No need for ODBC connection/ODBC drivers for MySQL. One-file .exe: Nothing to Install or Uninstall!

Sync For SQLServer is designed for software developers or database administrators who are working with Microsoft SQL Server 2005. It compares two databases and determines the differences between them. It generates an SQL change script to make the schema of the two databases the same. The existing data in the destination database remains completely intact. One of the unique features include the data migration from the source database to the destination database. You can take over the data in many ways to get your data to the destination database where it is exactly needed. It is based on the .NET framework and very easy to use. It is made to build a professional baseline for your database update process. It requires the Crystal Reports runtime which is included in the installation.

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.

PaGoDump is a GUI Windows utility for backing up a PostgreSQL database built with Microolap PostgresDAC. It makes consistent backups even if the database is being used concurrently. PaGoDump does not block other users accessing the database (readers or writers), also it works with databases with any names (unicode) and dump them to any files (unicode again).

You have a Microsoft � Access � database and want to convert it into mysql? Even in certain time inverals? Then we have the right thing for you: DB Converter! DB Converter converts any Access database into sql commands, that you can easily import into your mysql database. By wish this jobs are done automatically. Every seconde there can be converted about 2000 sets!. The programm works under Windows � 98/2000/XP and needs the VB 6 Runtime components.

OraExp is a free Oracle IDE that targets to be lightweight and easy to use. Currently it is oriented mainly towards software developers. It works on Linux, Mac and Windows and supports Oracle 9i and later. Below is list of currently supported features: Full unicode support, Creators/Editors/Viewers for following object types: Relational tables, Views, Packages, Procedures, Functions, Triggers, Sequences, Types, Synomyms, Database links, Users Worksheet with support for bind parameters (including cursors) and multiple resultsets, DBMS output, Explain plan, Autotrace, Schema comparer, Schema exporter, Data comparer, Data copier, Data exporter, Data importer, Session browser

Databrid is a browsing, retrieval and manipulation tool designed for the novice to the expert user. Databrid works on MySql and Oracle Database (versions 8 and above although not all functionality in the Browser is available for the lower versions). The core functionality of Databrid revolves around the tabbed areas within the Databrid application. The four main tabs in the main screen of Databrid are: SQL Editor, Browser, File and Jobs.

Entity Developer is a free powerful modeling and code generation tool for ADO.NET Entity Framework, NHibernate, and LINQ to SQL. You can use Model-First and Database-First approaches to design your model and generate C# or Visual Basic .NET code for it. It introduces new approaches for designing ORM models, boosts productivity, and facilitates the development of database applications.

SQL Locator is a database search engine for SQL Server. It can search one or more databases, real-time, for text, numeric ranges, date ranges, and various other combinations. Like Google, it can also provide search suggestions using real data from your databases. SQL Locator is easy to use like Google and enables you to start searching immediately without any setups or understanding database structures and their complexities. Results can be replaced, removed, saved, and shared with others. There are other nice features including database browsing, which lets you browse data within an entire database in just a few seconds.

The Marshal SQLUtility is a Free generic cross database utility with batch execution capabilities. It allows you to test ODBC connections, browse database schemas, discover tables, views and columns. All you need to do is to enter the connection string to your database. Features * Execute any query supported by your database server * Execute batches of queries • Discover tables and views in your database * Discover columns for a selected table or view * Supports BLOBS and CLOBS * Save your results to file * Use any ODBC compliant database such as Oracle, SQL Server, MySQL, PostgreSQL, DB2 etc.

dbForge SQL Complete Express is a free add-in for SQL Server Management Studio and Visual Studio. It offers powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense ®. Besides the extension of the List Members, Complete Word and Parameter Info features, SQL Complete also includes SQL Formatter. Key Features: - Smart filtering to suggest relative keywords and objects. Filtering of the suggestion list, realized in SQL Complete, is based on various criteria: * first typed symbols, * whitespace, * camel case, * square bracket. - Quick parameter info for functions. When you are typing names of the user-defined and built-in functions and procedures, SQL Complete displays their parameter information in a hint. - Customizable SQL formatting (partial support*). Produce clear and well-formatted code without worrying about indents, whitespaces, wrappings, line breaks, etc.

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. Report results in various formats (html, csv, xml, pdf, rtf). Output to file,email,ftp. Reports ready to use for sugarCRM, vtiger CRM. COM Component to be integrated into any Win32 applications.

This tutorial will give you the steps to follow in order to setup a MySQL database replication based on a master-slave scenario.

Nevron Gauge for SharePoint delivers a rich set of Linear and Radial Gauges, Numeric Displays and State Indicators to your SharePoint applications. The web part uses the powerful Nevron Pivot data aggregation engine, which, combined with the numerous gauge customization features makes it the perfect tool for displaying KPIs, numeric and real time data inside SharePoint. The web part is also very useful in the creation of Enterprise grade digital dashboards and reports as an integral part of the Nevron SharePoint Vision suite. The product is completely configurable trough an advanced, pure HTML based gauge designer. The gauge designer supports all major web browsers and does not require any plug-ins. It does not use postbacks, MS ASP.NET controls or MS AJAX, which ensures that the client-server communication is minimized so the design process can speed up. The client-side is just HTML, CSS and jQuery JavaScript, while the server-side UI processing is pure HTML and script rendering.

Stored procedure compatible with Microsoft SQL Server 2000 and 2005 that automatically deletes unnecessarily users from your database.

Creating reports from data stored in a database is a very common need of businesses and organizations - monthly sales reports, reports of employee hiring, reports of purchases from an online store, etc. For online databases, there is no more common method of data storage than MySQL, and for report presentation, there is no more desired format than PDF - Adobe's award-winning document display format. MyPDF allows you to do this - create PDF reports with advanced application logic from MySQL. Create summaries of your data, so-called 'sub-reports' with various levels of grouping for your data, calculations, calculations of calculations, sorts and filters, and much more - and then save your report layout and display it as a PDF! MyPDF is highly customizable using Flash 7 stylesheets.

DBConvert for Access & MySQL is a database converter which performs MS Access (mdb) to MySQL and MySQL to Access conversions. Features: Unicode Support, Primary keys and Indexes conversion, Interactive (GUI) mode / command line mode, renaming of tables, fields, indexes before conversion. There is an ability to save data to PHP script or to a dump file that allows you to get over the restrictions on access to MySQL database if any.