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

  • The Code Project 2010 Members Choice Winner

    PragmaSQL is The Code Project's 2010 Members Choice winner in General Database Tools category.

    We would like to thank to all Code Project members and PragmaSQL users.

    Read the press release from Code Project

    8/11/2010 8:52:00 AM Published by Ali Özgür
  • PragmaSQL 2.0 Available (Build 101)

    • PragmaSQL upgraded to Microsoft .NET Framework 3.5. You will have to install .NET Framework 3.5 in order to use PragmaSQL
    • Schema support for Microsoft SQL Server 2005/2008 implemented. PragmaSQL can now handle objects owned by different schemas.
    • Windows 7 specific features like jump lists, dialogs and task bar progress added. In order to experience these new features you shall run PragmaSQL on Windows 7
    • Background recovery manager related bugs resolved
    • Object Explorer Options added. You can specify if object explorer shall show system databases, system tables and database compatibility level.
    1/6/2010 11:57:00 PM Published by Ali Özgür
  • Microsoft SQL Server 2008 Feature Pack

    From version 1.5.0.105 PragmaSQL Server Management facilities utilize Microsoft SQL Server 2008 Management Objects. Please download management objects from the latest Microsoft SQL Server 2008 Feature Pack.
    10/19/2009 9:36:00 AM Published by Ali Özgür
  • Compatibility Files issue with Windows Vista

    PragmaSQL stores license file and the custom syntax highlighter files under the installation folder. If you installed PragmaSQL to C:\Program Files on Windows Vista you will not see licence.lic file and SyntaxHighlighters folder right away. Check out this post for details.
    10/16/2009 6:32:00 PM Published by Ali Özgür
  • PragmaSQL 1.5.0.105 Available

    DB Search related bugs fixed.
    For details check issues with keys APP-40 and APP-41 here.
    10/16/2009 6:28:59 PM Published by Ali Özgür
  • PragmaSQL 1.5.0.104 Available

    Bug fix build.
    For details please read the change history entry for this particular build.
    9/8/2009 4:21:00 PM Published by Ali Özgür
  • PragmaSQL 1.5.0.103 Available

    Minor improvements.
    8/3/2009 9:20:49 AM Published by Ali Özgür
  • PragmaSQL 1.5.0.102 Available

    • Script editor can open database connections in a separate thread.
    • Restore and recover functionality improved. Connection verification dialog will not be prompted, instead PragmaSQL will load the script and script editor will try to reconnect to the database asynchronously.
    • Shared scripts and shared snippets restored/recovered properly
    • Some minor bug fixes
    • Some parts rewritten
    7/22/2009 2:24:00 PM Published by Ali Özgür
  • 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