SQLPro SQL Client
Encyclopedia
SQLPro is a proprietary
, visual database management and development tool for multiple databases. SQLPro comes with a three-pane interface and has integrated SQL
editor with many useful SQL
editing features. SQLPro connects directly (using native drivers) to most popular database
servers using one single interface. It supports native data source connection for Oracle
, PostgreSQL
, MySQL
, Microsoft SQL Server
, Microsoft Access
and SQLite
. Provides quick view of the database schema
, table schema and results of the query execution.
Amenities include color-coding of the SQL
, drag-and-drop of objects into the SQL
pane to save you from typing their name, retrieval of SQL
for things like stored procedures and triggers from the underlying database
, and one-click creation of SELECT and INSERT statements. You can save SQL
files and print result sets.
Proprietary software
Proprietary software is computer software licensed under exclusive legal right of the copyright holder. The licensee is given the right to use the software under certain conditions, while restricted from other uses, such as modification, further distribution, or reverse engineering.Complementary...
, visual database management and development tool for multiple databases. SQLPro comes with a three-pane interface and has integrated SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
editor with many useful SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
editing features. SQLPro connects directly (using native drivers) to most popular database
Database
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...
servers using one single interface. It supports native data source connection for Oracle
Oracle Database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
, PostgreSQL
PostgreSQL
PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
, MySQL
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
, Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...
, Microsoft Access
Microsoft Access
Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of...
and SQLite
SQLite
SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard...
. Provides quick view of the database schema
Database schema
A database schema of a database system is its structure described in a formal language supported by the database management system and refers to the organization of data to create a blueprint of how a database will be constructed...
, table schema and results of the query execution.
Amenities include color-coding of the SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
, drag-and-drop of objects into the SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
pane to save you from typing their name, retrieval of SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
for things like stored procedures and triggers from the underlying database
Database
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...
, and one-click creation of SELECT and INSERT statements. You can save SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
files and print result sets.
Feature Summary
- SQLPro runs on all 32-bit Windows platforms, including Windows 95Windows 95Windows 95 is a consumer-oriented graphical user interface-based operating system. It was released on August 24, 1995 by Microsoft, and was a significant progression from the company's previous Windows products...
, 98Windows 98Windows 98 is a graphical operating system by Microsoft. It is the second major release in the Windows 9x line of operating systems. It was released to manufacturing on 15 May 1998 and to retail on 25 June 1998. Windows 98 is the successor to Windows 95. Like its predecessor, it is a hybrid...
, NTWindows NTWindows NT is a family of operating systems produced by Microsoft, the first version of which was released in July 1993. It was a powerful high-level-language-based, processor-independent, multiprocessing, multiuser operating system with features comparable to Unix. It was intended to complement...
, 2000Windows 2000Windows 2000 is a line of operating systems produced by Microsoft for use on personal computers, business desktops, laptops, and servers. Windows 2000 was released to manufacturing on 15 December 1999 and launched to retail on 17 February 2000. It is the successor to Windows NT 4.0, and is the...
, XPWindows XPWindows XP is an operating system produced by Microsoft for use on personal computers, including home and business desktops, laptops and media centers. First released to computer manufacturers on August 24, 2001, it is the second most popular version of Windows, based on installed user base...
, and VistaWindows VistaWindows Vista is an operating system released in several variations developed by Microsoft for use on personal computers, including home and business desktops, laptops, tablet PCs, and media center PCs...
. - No specific hardware requirements.
- Color coding of SQLSQLSQL is a programming language designed for managing data in relational database management systems ....
keywords - Retrieve stored procedures, triggers and functions
- No other software or third party drivers to install. SQLPro comes with full set of drivers.
- Multiple host/database connections.
Supported Databases
- Microsoft AccessMicrosoft AccessMicrosoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of...
- Microsoft SQL ServerMicrosoft SQL ServerMicrosoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...
- MySQLMySQLMySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
- OracleOracle DatabaseThe Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
8i, 9i, 10g and 11g - PostgreSQLPostgreSQLPostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
- SQLiteSQLiteSQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard...