SQL Runner is a small utility that lets you store and run SQL scripts against MySQL servers. It lets you build Script Sets that contain as many SQL scripts as you want. Each script consists of a test (for determining if the fix is required), a fix (for updating the SQL data), and notes that you can use to store any additional information. Script Sets are stored as XML files, and thus are quite easy to back up, share, and store in version control.

mysql servers batch modes script sets sql data

pcpmSqlGen Component generates SQL INSERT statements from SELECT statements and runs SQL Scripts from within your application. Use it to create test data, save data prior to test and then restore it after, distribute lookup tables or schema changes to remote databases. Quickly generate INSERTs without needing to remember column names.

schema changes lookup tables column names test data databases

SQL Batch Executor will run SQL scripts for any database with an ODBC compliant driver.

compliant driver executor

Imports data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources. Very fast and reliable. Uses naitive API. Repository: MS Access, Oracle, MS Sql Server, Interbase, MySql, PostgreSQL Also:Easy Repository switching, Data Preview, Mapping editor, Exports, SQL scripts editor, Packages editor, Integrated Scheduler, Logging, Lookups, Email Notifications, File Operations, Check Files, Compare Files

oracle sql server ms sql server microsoft dts performance hundreds

Query Tool (using ADO) is a Universal Data Access (UDA) tool. It lets you query OLE DB data sources, author SQL scripts and queries, return query results to a grid or free-form text, retrieve provider properties, execute multiple SQL scripts or stored procedures simultaneously, and more. Related Products: Query Tool (using ODBC) x86 and x64; Query Tool (using ADO) x64.

universal data access db data query tool query results data sources

Query Tool (using ODBC) is a Universal Data Access (UDA) tool. It lets you query ODBC data sources, author SQL scripts and queries, return query results to a grid or free-form text, retrieve ODBC driver information, execute multiple SQL scripts or stored procedures simultaneously, and more. Related Products: Query Tool (using ADO) x86 and x64; Query Tool (using ODBC) x64.

universal data access query tool query results data sources x86

Create large entity relationship diagrams with CASE Studio 2 LITE database design tool and generate complex SQL scripts automatically. Key featueres include: Visual creation of Entity Relationship Diagrams (database design), definition of referential integrity rules, generation of complex SQL scripts, generation of detailed HTML and RTF reports, model explorer, to-do list etc.

entity relationship diagrams database design tool advantage database server db2 udb referential integrity rules

The solution avaliable for Microsoft SQL Server developers, that enables source control and comprehensive documentation of your databases. Full source control and documentation versioning for SQL Server 2000 with Source Safe 6.0 support. Comprehensive database documentation, HTML reports, easy SQL Server database items management, teamwork development. SQL code editor features syntax color coding and Intellisense-style automatic code completion.

Powerful Visual Studio add-in designed to automate and simplify the process of developing applications with Oracle. OraDeveloper Tools integrates into Visual Studio .NET and lets you quickly browse, query, and update Oracle databases from your development environment. Optimized for PL/SQL development with an SQL and PL/SQL debugger, code completion, code templates, and project management support. Available for VS 2003/2005/2008.

Nerocode SQLWave is a powerful MySQL GUI tool designed to automate and simplify database development process. It also provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways.

MaxDB Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs.

Adds powerful sql processing capability to your program,including sql syntax check, beautify complex sql code with lots of customizable format options,identify various database objects such as table, column, constraints in sql scripts,modify and rebuild sql on the fly, translate sql expression into a binary expression treethat ready for your further processing such as creating filter, and etc.

Oracle Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view/edit BLOBs.

MSSQL Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs.

SQL Edge not only allows users to execute SQL scripts, but also provides a powerful way to visualize data relationships. With SQL Edge, users can use only one query to retrieve data in a master table, and then browse data in all related detail tables. Users can also insert, edit, and delete table records in the data grids.

PostgreSQL Maestro is a powerful Windows GUI solution for PostgreSQL server administration and database management. PostgreSQL Maestro supports all the latest versions of PostgreSQL from 7.3 to 8.3, and all of the most important PostgreSQL features, including tablespaces, dollar-quotation, connection limits, enabling/disabling triggers, OUT and INOUT function parameters. It allows you to create, edit, copy, extract, drop all the database objects.

Perl and PHP Development Environment with tutorials, multi-file syntax-highlighting editor, web utilities such as one-click FTP upload, one-click upload and execute on server, one-click testing to in-line text pane or web browser, inbuilt web server, MySQL integration, Batch files, module installer, inbuilt web server, code templates, multi-level backups / restores, version control, and time-saving Autoupdate & Autoconfig features.

MSISQL (Interactive SQL for MSSQL) is a database administration solution for managing Microsoft SQL databases. It allows to build SQL queries using SQL Editor with SQL syntax highlighting and SQL Query History features; build SQL queries using Visual QueryBuilder; automate routine tasks using ISQL for MySQL in command line mode; export resultset in various data formats (HTML, RTF, XML etc.); SQL query errors highlighting.

The Query Tool is a powerful data mining application. It allows you to perform data analysis on any SQL database Developed predominately for the non technical user. No knowledge of SQL is required. NEW features: Query Builder, quickly and simply build powerful queries; Summary; summarise any two columns against an aggregate function (MIN, AVG etc.) of any numerical column. Query Editor; now you can create your own scripts.

Oracle Maestro is a powerful Windows GUI solution for Oracle administration and database management. Oracle Maestro supports for all Oracle server versions on the market, and all of the most important Oracle features, including users, views, triggers, functions, procedures, synonyms, packages, sequences, types, jobs, collections, queues, clusters, tablespaces, etc.

Altova DatabaseSpy 2008 is the unique multi-database query and design tool from the creators of XMLSpy. It connects to all major databases, easing SQL editing and database structure design for a fraction of the cost of single-database solutions. Features like table browsing, data editing, SQL auto-completion, visual table design, multiple export formats, and more, all save time and ensure accuracy. It is the one tool to liberate data management.

EMS SQL Manager for DBISAM provides you with powerful tools for DBISAM Server administration and object management. Its Graphical User Interface (GUI) allows you to easily and simply create/edit all DBISAM database objects, run SQL scripts, manage users and administer user privileges, visually build SQL queries, extract and print metadata, export/import data, view/edit BLOBs, and supplies many more features.

Altova MapForce 2006 Professional Edition is the premier XML/database/flat file data mapping tool for advanced integration projects. This award winning, visual data mapper converts data on-the-fly and auto-generates custom data conversion code in XSLT 1.0/2.0, XQuery, Java, C++ and C#. With the power to map any combination of XML, databases, and/or flat files, MapForce 2006 is the definitive tool for data integration and information leverage.

A comprehensive IDE for MySQL, it helps you work faster with MySQL by automating and simplifing the database development process. Presents a powerful visual interface for developing scripts, executing queries, managing users and privileges, and more. Key features include a completely unique stored routine debugger, an advanced SQL editor, integrated database explorer, database backup and restore, and fast direct connection to MySQL.

PostgreSQL Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view/edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view/edit BLOBs.

Firebird Maestro is a powerful Windows GUI solution for Firebird administration and database management. Firebird Maestro supports for all Firebird versions from 1.0 to 2.1, and all of the most important Firebird features, including expression indexes, sequences, generators, universal triggers, default values for procedure variables, exceptions, standard comments for objects, viewing and editing data in UTF-8/Unicode encodings, etc.

SQL Script Builder is powerful software that can create a database migration sql script (or dump file) or database files from any database. Scripts formats ; MySql, MS SQL, Oracle, Pervasive and PostgreSQL. Files formats ; Access mdb, Excel csv and MS xml. SQL Script Builder can be used for example for database migration from your Access database to MySql database, or MySql to MS SQL database and vice versa.

SwisSQL DBChangeManager is an affordable and easy-to-use tool for Comparison and Synchronization of Microsoft SQL Server database schema. It also offers powerful Reporting, Auditing and a Web based client interface (with multi user access) which makes it the best fit for collaborative database development and database change management. It also offers a Free Edition with some feature restrictions and no expiry limitations.

SQL Mage for MySQL is a powerful SQL editor, which provides various possibilities for database users, developers and administrators. Besides all standard operations with databases, SQL Mage allows to print out the list of databases, fields of the specified table, data and even SQL scripts, preserving their original font and colour. The editor itself is designed as a set of tabs (each works like a separate SQL editor with its own history).

An enhanced data provider for Oracle that builds on ADO.NET technology to present a complete solution for developing Oracle-based database applications. As part of the Core Lab database application development framework, OraDirect .NET offers both high performance native connectivity to the Oracle database and a number of innovative development tools and technologies.

txtPro Text Editor is your all-in-one multi language code editor, text editor and HTML editor! Great looking color syntax highlighting combined with auto indentation give you the feedback you need to code productively. Turn on line numbering (if you like), choose your favorite font to edit with, and you're ready to fly! txtPro's new tabbed document interface makes it a breeze for you to move around your source code.

SQL Examiner Suite 2008 compares and synchronizes both schema and data of SQL Server including the new SQL Server 2008. You can compare any version of SQL Server form 7.0 to 2008. SQL Data Examiner allows you to compare and synchronize not only SQL Server but also Oracle, MySQL and Access databases. Comparison with backups and SQL scripts, compare results of SQL queries, etc. Try it yourself!

SQLite Maestro is a powerful Windows GUI solution for SQLite administration and database management. SQLite Maestro supports for all SQLite versions from 2.8 to 3.x.x, and all of the most important SQLite features, including check constraints, index sort ordering and index collating sequence.

dbAnalyst is a cross-platform database administration solution: from connection, to import, to schema translation, to export. Database administrators and developers can manage any database with just one tool, reducing the learning curve and saving time and money. dbAnalyst?s intelligent interfaces, feature-rich console, and query wizards make it simple and easy to use yet powerful for any database analysis task.

An enhanced data provider for SQL Server that builds on ADO.NET technology to present a complete solution for developing SQL Server-based database applications. As part of the Devart database application development framework, SQLDirect .NET offers both high performance native connectivity to the SQL Server database and a number of innovative development tools and technologies.

An enhanced data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications. As part of the Core Lab database application development framework, PostgreSQLDirect .NET offers both high performance native connectivity to the PostgreSQL database and a number of innovative development tools and technologies.

MyISQL (Interactive SQL for MySQL) is a database administration solution for managing MySQL(tm) databases. It allows to build SQL queries using SQL Editor with SQL syntax highlighting and SQL Query History features; build SQL queries using Visual QueryBuilder; automate routine tasks using ISQL for MySQL in command line mode; export resultset in various data formats (HTML, RTF, XML etc.); SQL query errors highlighting.

A set of powerful add-ins designed to automate and simplify the process of developing applications with Oracle from existing IDEs. OraDeveloper Tools integrates directly into Microsoft Visual Studio or Borland Delphi and lets you quickly browse, query, and update Oracle databases from the comfort of your favorite environment. Optimized for PL/SQL development with a PL/SQL debugger, code completion, code templates, and project management support.

Powerful Delphi add-in designed to automate and simplify the process of developing applications with Oracle. OraDeveloper Tools integrates into Delphi and lets you quickly browse, query, and update Oracle databases directly from Borland Development Studio. Features include easy object manipulation, visual query building, and extended scripting support. Also available for VS 2003/2005 and Delphi 2005/2006/2007.

Firebird Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs.

Import data from ODBC datasource, synchronize your database. Execute queries for updation of result. Copy databases between hosts. Generate Schema for your database. Manage Foreign Relationships and all options fully InnoDB compliant. Reorder columns.