Wednesday, December 3, 2008

SQL Programming Tool

SQL Programming Tool
From Wikipedia, the free encyclopedia
Jump to: navigation, search

This article is orphaned as few or no other articles link to it. Please help introduce links to this subject in articles on topics related to it. (June 2008)

The external links in this article may not follow Wikipedia's content policies or guidelines.Please improve this article by removing excessive or inappropriate external links. (July 2008)
In the field of software, SQL programming tools provide platforms for database administrators (DBAs) and application developers to perform daily tasks efficiently and accurately.
Database administrators and application developers often face constantly changing environments which they rarely completely control. Many changes result from new development projects or from modifications to existing code, which, when deployed to production, do not always produce the expected result.
For organizations to better manage development projects and the teams that develop code, suppliers of SQL programming tools normally provide more than facility to the database administrator or application developer to aid in database management and in quality code-deployment practices.
1 Features
1.1 SQL editing
1.2 Object browsing
1.3 Session browsing
1.4 User-security management
1.5 Debugging
1.6 Performance monitoring
2 List of SQL programming tools
3 See also

[edit] Features
SQL programming tools may include the following features:

[edit] SQL editing
SQL editors allow users to edit and execute SQL statements. They may support the following features:
cut, copy, paste, undo, redo, find (and replace), bookmarks
block indent, print, save file, uppercase/lowercase
keyword highlighting
access to frequently used files
output of query results
editing query-results
committing and rolling-back transactions

[edit] Object browsing
Tools may display information about database objects relevant to developers or to database administrators. Users may:
view object descriptions
view object definitions (DDL)
create database objects
enable and disable triggers and constraints
recompile valid or invalid objects
query or edit tables and views
Some tools also provide features to display dependencies among objects, and allow users to expand these dependent objects recursively (for example: packages may reference views, views generally reference tables, super/subtypes, and so on).

[edit] Session browsing
Database administrators and application developers can use session browsing tools to view the current activities of each user in the database. They can check the resource-usage of individual users, statistics information, locked objects and the current running SQL of each individual session.

[edit] User-security management
DBAs can create, edit, delete, disable or enable user-accounts in the database using security-management tools. DBAs can also assign roles, system privileges, object privileges, and storage-quotas to users.

[edit] Debugging
Some tools offer features for the debugging of stored procedures: Step In, Step Over, Step Out, Run Until Exception, Breakpoints, View & Set Variables, View Call Stack, and so on. Users can debug any program-unit without making any modification to it, including triggers and object types.

[edit] Performance monitoring
Monitoring tools may show the database resources — usage summary, service time summary, recent activities, top sessions, session history or top SQL — in easy-to-read graphs. Database administrators can easily monitor the health of various components in the monitoring instance. Application developers may also make use of such tools to diagnose and correct application-performance problems.

[edit] List of SQL programming tools
Advanced Query Tool (AQT) offers cross-database queries with a query environment and a wide range of DBA , data-analysis and developer tools
ESF Database Convert All-in-one cross database migration tool for DBA. Supports Microsoft Access, Microsoft Excel, MySQL, Microsoft SQL Server, PostgreSQL, Oracle, SQLite, FireBird, FoxPro, CSV/Text etc
dataPro transfers database objects between different databases and servers, converts tables schema and migrates data from one database type to another. Works with Oracle, MySQL, Microsoft SQL Server, Microsoft Access and SQLite.
DBDiff for Oracle performs comparisons between two Oracle databases and can also automatically write scripts to upgrade from one database to the other
DB Tools for Oracle integrates tools for monitoring, tuning, diagnosing, coding, creating, editing, benchmarking, and reporting Oracle databases
dbForge Studio for MySQL automates and simplifies work with MySQL
dbXpert for Oracle aids development and administration of Oracle databases
OraDeveloper Studio automates and simplifies work with Oracle data
EMS SQL Management Studio - set of SQL tools for migration, data loading and synchronization, database backup and extraction (for MySQL, Oracle, PG, IB, MS SQL).
PL/SQL Developer sets up an integrated development environment (IDE) targeted at the development of stored program units for Oracle Databases.
Embarcadero Rapid SQL, an integrated cross-platform database development environment, raises productivity for both novice and expert programmers.
TOAD, originally written for Oracle databases but subsequently expanded to include the ability to access other database management systems.
SQL Manager Studio, an Integrated Development Environment (IDE) designed for Microsoft SQL Server, allows users to run SQL scripts on different SQL Servers at the same time
SQL Enlight, a Transact-SQL code management tool able to reformat, validate, perform static analysis and summarize Transact-SQL scripts. SQL Enlight is impelmented as add-on for Visual Studio 2005/2008 and SQL Server Management Studio 2005/2008.
SQLPro SQL Client - database management and development tool for Oracle, PostgreSQL, MySQL, Microsoft SQL Server, Microsoft Access and SQLite.

[edit] See also
Comparison of database tools

No comments: