Top Rated Scripts | Tools & Utilities | Database Tools

A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements.

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.

This shell script backs up any or all of your databases and emails and/or FTPs them over to you. You can send the backups to unlimited email addresses and to unlimited FTP servers. The script is very flexible, so give it a try! With cron, you can have this process automated, leaving you with regular backups, as well as a piece of mind.

This is a shell script which is for backing up your mysql database. This can be customised as you like. The speciality of the script The script can keep a copy of the mysql database on the server along with sending a copy as attachment to your mail id.

This book is a collection of notes and sample codes I wrote while learning and using SQL. Topics include data types, built-in functions, data definition statements, data manipulation statements, query statements, transaction, stored procedures, MySQL, etc.

DBACentral for MySQL is a unique solution for database administration, development and data management. DBACentral for MySQL provides you with easy-to-use graphical user interface for executing all database operations: database structure management, table data manipulation, server administration, PHP forms generation and many more.

MS SQL server backup/restore application. Very useful if you want to backup only certain selected SQL tables not the entire database. It allows to: 1. Back up selected database tables separately (as .sql script file - insert clause) 2. Restore database table using previously created .sql script file 3. Omit timestamp (rowversion) columns 4. Omit identical columns 5. Select top n rows 6. Disable constraints during DB restoration.

EMS SQL Manager Lite for MySQL is an excellent freeware graphical tool for MySQL Server administration. MySQL Manager works with any MySQL versions from 3.23 to 5 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys and so on. It has minimal required set of instruments for those users who are new to MySQL server and need only its basic functionality. MySQL Manager has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

Navicat Lite is an intuitive GUI tool lets you create, browse databases, run SQL queries and connect to remote MySQL, SQL Server, SQLite, Oracle and PostgreSQL in an easier way. 30 days demo version includes query builder, report builder, backups/ restore, batch job scheduling, and the ability to convert Access to MySQL, SQLite, SQL Server, Oracle and PostgreSQL and Excel to MySQL, SQLite, SQL Server, Oracle and PostgreSQL. Other features include a SQL Console, View Builder and Data Synchronization.

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)

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.

Oracle Data Guard alternative and used worldwide. Dbvisit can implement automated Oracle Standby Database without Data Guard. Dbvisit is simpler and easier to use and install than Data Guard. Dbvisit can be used with the Standard Edition of Oracle from version 8i to 11g. This makes Dbvisit a very cost effective Oracle Standby Database solution compared with upgrading to Oracle Enterprise Edition to enable utilisation of Oracle Data Guard. Includes many features such as Graceful Switchover, supports Oracle RAC, ASM, OMF and flash recovery. Also includes built-in alerting and monitors and manages the Oracle archive log files.

Extract data from your Oracle tables with WikApp Oracle Database Retrieve 1.0. This program allows you to save BLOB data (such as Word docs, PDF's, XML, etc.) from your Oracle database to your local hard drive. Simple interface makes it easy to get the data you want. Works with Oracle 9i and 10g clients. Visit http://www.wikapp.com for more information.

SQLPorter Migration Toolkit helps you migrate your data and database schema from databases such as Microsoft SQL Server Versions (6.5, 7.0, 2000, Oracle 8, 8i, 9i, IBM DB2, Sybase Adaptive Server, Postgres, and MySQL on any supported workstation/server platform to all other databases listed above. The SQLPorter toolkit can also act as an agent to automate data population and migration based on selected time intervals. SQLPorter currently runs on Windows NT or Windows 2000 and is English only. Linux version of SQLPorter will be available very soon.

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!

Need latitude longitude center point information for every US City? Not everyone has this kind of data, but we've got it. Get your hands on our up-to-date accurate list of US cities and their corresponding latitude / longitude data.

PHPMagic is a program that helps you develop web database applications rapidly. Just define your database, set some options, click the Generate button, and ... that's it! You do not need to have any programming background to use it. PHPMagic creates a full setup script to create the mysql tables and the forms that interface with them. You will then have an exceptional web database application ready for uploading to your website. It has all the powerful features you would expect from a professional database application: data navigation, sorting, searching, advanced filtering, modification, addition, deletion and File Uploads.

Automatically creates a MS Word documentation of your chosen database. You will need to enable Word macros, and use medium security settings. If all is well, then when you open the documentor, a login page will appear. Enter the database Server name, the user name and password. Click trusted if you has a trusted connnection. Then click the List Databases button. A list of databases appears in the list view. Double click a database name to document it. There is now a button on the menu bar that brings up the documentor menu.

Capture contacts with a Click Use ListGrabber to capture leads / contact information from the Internet or any other source into your database. The ListGrabber is a powerful sales lead capture tool that allows you to build your own lead list / prospect list from various publicly available sources on the Internet such as Online Directories (yellowpages.com, superpages.com, Realtor.com), White Pages, MLS Listings, etc. ListGrabber can capture name, address, email, phone and fax numbers, etc of business contacts from online directories, email signatures, and also spreadsheets and documents. It then transfers these details instantly into respective contact fields in your database. You can use it to build your own list of prospects to whom you can market your services or products. Use our sales and marketing software to capture lead lists/ prospect lists into your address book or contact manager (ACT!, Outlook, Excel, GoldMine, etc.)

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.