Personal Edition Professional Edition






  • T-SQL script editor with syntax highlighting
  • Object Explorer with filtering support
  • Code Completion support for  tables, views, columns, stored procedures, functions, triggers, variables, temporary tables
  • Code block shading and folding support for select and case statements
  • User defined code block definitions with #block and #endblock special keywords, similar to Microsoft Visual Studio regions
  • Table data editing
  • Script and code snippet sharing via PragmaSQL database
  • Local code snippets (accessed from script editor with Ctrl+J)
  • Change history logging for stored procedures, functions, views and triggers.
  • Automatic script logging to PragmaSQL database.
  • Database object grouping support with documentation
  • Search for objects in databases by name and/or any text
  • Project explorer, which supports connections, any database object and any local file
  • Extensible through freely available PragmaSQL.Core add-in api.
  • Microsoft Help2 Integration add-in
  • Server Management add-in
  • Supports Microsoft SQL Server 2000/2005
  • Implemented with C# on .NET Framework version 2.0
RSS-2.0

PragmaSQL Online News

  • PragmaSQL 1.5.0.101 Available

    • Professional Edition: You can define custom syntax highlighters. For customization details read this section
    • Auto recover functionality added. To enable auto recover open PragmaSQL Options dialog from Tools -> Options menu. Select Application settings from the three and open Auto Recover page.
    • Palette support added. You can apply predefined palettes or define and apply your custom palette. To change palette open PragmaSQL Options dialog from Tools -> Options menu. Select Application settings from the three and open Style page. See screenshots
    6/24/2009 5:23:00 PM Published by Ali Özgür
  • Build 1.0.0.42 Available

    New feature added: Highlight matching words when a word is double clicked in text editor.
    See Screenshot
    6/4/2009 1:14:00 PM Published by Ali Özgür
  • Build 1.0.0.41 Available

    PragmaSQL now offers Personal Edition for home users. If you want to use Personal Edition you can simply download (no registration) and install PragmaSQL. No license is required for Personal Edition.

    For commercial users we continue to offer Professional Edition. If you want to evaluate Professional Edition you can download(registration required) and retrieve a demo license.
    6/2/2009 2:51:00 PM Published by Ali Özgür
  • Build 1.0.0.40 Available

    • Object Grouping: Script Selected Objects functionality added
    • Object Grouping: Import Selected Objects functionality added
    • Object Grouping: Search order bug fixed. Check out comment of issue APP - 34 to learn how to fix order problem in existing Object Grouping support installations
    • Sercah On Database: Change Database functionality improved by adding server and database combos
    • Server Management AddIn : SQL Server 2008 specific Modify Table problems resolved
    • Server Management AddIn : User Defined Data Types related Modify Table problem resolved
    • PragmaSQL Application: Bug crashing the application on startup resolved. When Document Style is selected to be SystemMdi and has at least one script editor from the previous session application crashes on startup with exception message Invalid document state.
    5/28/2009 6:51:00 PM Published by Ali Özgür
  • Build 1.0.0.39 Available

    Maintenance release to improve machine identification.
    5/25/2009 4:03:00 PM Published by Ali Özgür
  • PragmaSQL named as Best General Database Tool by The Code Projects members


    PragmaSQL was named as Best General Database Tools by The Code Project’s members.

    Members were asked to rate their favorites on http://catalog.codeproject.com/. The Code Project staff then compiled the highest rated listings, awarding the highest ranked in each product category. The results reflect actual perceptions of what developers value. Each codeproject.com member decides which companies or products deserve recognition, based on in-the-field experience. 
    5/20/2009 9:29:00 AM Published by Ali Özgür
  • Server Management AddIn Requirements

    If you do not have SQL Server 2005 installed on your machine you may not be able to use some of the Server Management AddIn functions like Script Objects and Copy Data because these functions depend  on SQL Server 2005 SMO.

    To solve this issue you have to download SQL Server 2005 XMO. XMO installation checks if SQL Server Native Client is installed so you will have to download SQL Server Native Client if you do not have native client already installed on your machine.
    5/8/2009 9:55:45 AM Published by Ali Özgür
  • Build 1.0.0.37 Available

    • Demo period is extended to 120 days
    • All previous demo licenses were deleted, so that you can request a new demo activation key for extra 120 day evaluation. You can delete licence.lic file from PragmaSQL installation folder and enter the new activation key provided to you by PragmaSQL Online.
    • Script editor was enhanced to support renderer add-ins. You can now develop custom renderer add-in and users can choose your renderer for rendering query results.
    • PragmaSQL Virtual Result Renderers source code published as a sample for custom renderer add-in development. Download Source Code
    • Download PragmaSQL
    10/13/2008 12:46:00 PM Published by Ali Özgür
  • Build 1.0.0.36 Available

    • PragmaSQL Bulk Copy wizard introduced
    • Some improvements applied to PragmaSQL Scripter wizard
    • Scripter and Bulk Copy wizards moved to SQLManagement addin.
    7/10/2008 2:44:44 PM Published by Ali Özgür
  • Build 1.0.0.35 Available

    - APP-27: Objects in the Object Group editor are sorted by Type, Name. Type order is a following
     * Table,
     * Stored procedure,
     * User defined functions and
     * Views
    - APP-28 : After initializing Object Grouping editor, first parent node is not automatically expanded anymore.
    - APP-29 : After changing database in the script editor Fast script preview was showing script for the object in wrong database. This issue was fixed.
    - Database object scripting functionality changed.  PragmaSQL Scripter wizard is used for scripting. Most important improvement is that we can save our selected object names, along with the schema name,  for later use, which is a crucial feature especially needed while doing intergration testing.

    Download PragmaSQL

    Read change history
    7/7/2008 1:22:59 PM Published by Ali Özgür