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

  • Build 1.0.0.34 Available

    * [APP-24] Bug resolved for details see the blog entry
    * [APP-25] Search and replace dialog improved.
    * [APP-26] Fast script preview fature added. You can preview object scripts of the objects in a script editor by pressing Alt+F2. This functionality is similar with CoolIris addon for Firefox.

    Download PragmaSQL
    Read Change History
    3/27/2008 4:53:00 PM Published by Ali Özgür
  • Articles moved to PragmaSQL Online Blog

    Articles published by Ali Özgür were moved to PragmaSQL Online Blog.
    3/14/2008 2:32:22 PM Published by Ali Özgür
  • Build 1.0.0.33 Available

    * [APP-21] Change Database added to object search
    * [APP-22] "Add Object To Group" and "Show Grouping Statistics" context menu items added to Object Explorer and Script Editor.
    * Some bug fixes applied to Object Grouping.
    * [COR-10] ReadOnly property added to ITextEditor interface.
    * [COR-11] ScriptExecuting and ScriptExecuted events added to IScriptEditor interface. AddIn developers can cancel script execution by hooking to ScriptExecuting event
    * [COR-12] Some methods and properties added to ITextEditor interface in order to provide addin developers with runtime ToolStripItem add/remove functionality.
     - In order to be able to add/remove ToolStripItems to notification tool strip AddItemToNotificationStrip, RemoveItemFromNotificationStrip methods  and NotificationStripItemCount property added
     - In order to be able to add/remove ToolStripItems to addin tool strip AddItemToAddInStrip, RemoveItemFromAddInStrip methods  and AddInStripItemCount property added
    * [COR-14] EditorClosing and EditorClosed events added to ITextEditor interface. AddIn developers can cancel closing of a text editor programatically by hooking to
    EditorClosing event. Also EditorClosing,EditorClosed and EditorReady events were added to IEditorServices interface for similar purposes. EditorReady is fired after
    a text/script editor is ready with its content.
    * [COR-15] OpenProject(string fileName) method added to IProjectExplorerServices interface.
     
    3/13/2008 4:57:40 PM Published by Ali Özgür
  • Build 1.0.0.32 Available

    - Incremental search added (APP-7)
    - Bit columns can be sorted (APP-14)
    - Default configuration is loaded when Execute In Multiple Databases dialog is opened(APP-17)
    - Application version number added to splash screen (APP-18)
    - Database connection is opened in a background worker thread allowing the user to cancel connection that take too much to open (APP-19)
    - Turkish locale problem of the highlighter resolved (APP-20)
    - EditorServices.CurrentEditor.SaveToFile() removes file dirty indicator (COR-8)
    - ExternalTools Add-In configuration moved to Tools->Options->Modules ( EXTLS - 1)

    Download version 1.0.0.32
    Read change history
    2/27/2008 4:26:00 PM Published by Ali Özgür
  • Jira Client Add-In Published

    Jira Client AddIn developed by Tolga Kurkcuoglu released open source on PragmaSQL Online.
    Download source from here.
    Read article from here.
    2/13/2008 3:43:00 PM Published by Ali Özgür
  • PragmaSQL.Scripting.Smo Assembly published

    Scripting support for user tables added. If your PragmaSQL version is equal to or lower than 1.0.0.31 please
    download the assembly from here and copy the file into PragmaSQL installation directory.

    Higher version will automatically include the update,so you will not need to perform this operation.
    1/23/2008 10:06:48 AM Published by Ali Özgür
  • Build 1.0.0.31 Available

    For changes in this version check Change History
    1/18/2008 12:52:52 PM Published by Ali Özgür
  • Build 1.0.0.30 Available

    1/17/2008 10:27:00 AM Published by Ali Özgür
  • Build 1.0.0.29 Available

    New version of PragmaSQL is available for download.
    For changes in this version check Change History
    1/15/2008 11:34:53 AM Published by Ali Özgür
  • Pragma Help Desk (Issue Tracker) is online

    Pragma Help Desk is online. You can submit your requests via Pragma Help Desk
    Pragma Help Desk (Issue Tracker) source code was also published. Download from here.

    NOTE: Pragma Help Desk (Issue Tracker)  is Cuyahoga module and currently works with MySQL database.
    1/4/2008 5:37:00 PM Published by Ali Özgür