Softpedia >Mac >Developer Tools >SQLPro for MSSQL >  Changelog

SQLPro for MSSQL Changelog

What's new in SQLPro for MSSQL 2024.21

Apr 11, 2024
  • Fixed an issue that could cause a crash when deleting records. [#965](https://github.com/hankinsoft/SQLPro/issues/965)
  • Fixed an issue that could cause a crash when removing the 'format query' shortcut. [#964](https://github.com/hankinsoft/SQLPro/issues/964)

New in SQLPro for MSSQL 2024.15 (Apr 11, 2024)

  • Performance improvements with the query editor.
  • Crash fix related to the query editor.

New in SQLPro for MSSQL 2024.11 (Apr 11, 2024)

  • Performance improvements.

New in SQLPro for MSSQL 2023.56 (Apr 11, 2024)

  • Added support for right aligning numericals. [#914](https://github.com/hankinsoft/SQLPro/issues/914)
  • Added support for importing from JSON files. [#924](https://github.com/hankinsoft/SQLPro/issues/924)
  • Added support for exporting tables directly to Json via the database tree table context menu.
  • Moved themes location on file system. [#780](https://github.com/hankinsoft/SQLPro/issues/780)
  • Added support for keyboard shortcuts to export result sets as csv/json/xml. [#913](https://github.com/hankinsoft/SQLPro/issues/913)
  • Renaming a table will instantly update the autocomplete. [#922](https://github.com/hankinsoft/SQLPro/issues/922)
  • You can refresh a tab loaded from the file system by right clicking the tab and choosing 'Reload file'. [#902](https://github.com/hankinsoft/SQLPro/issues/902)

New in SQLPro for MSSQL 2023.21 (Apr 11, 2024)

  • CSV export new remembers the previous settings. [#885](https://github.com/hankinsoft/SQLPro/issues/885)

New in SQLPro for MSSQL 2023.10 (Feb 8, 2023)

  • Fixed an issue where new connections defaulted to read-only mode.

New in SQLPro for MSSQL 2023.06 (Feb 3, 2023)

  • Improvements with connection handling.

New in SQLPro for MSSQL 2022.88 (Feb 3, 2023)

  • Added user defined type details to the database tree.

New in SQLPro for MSSQL 2022.80 (Feb 3, 2023)

  • Some additional logging for connection groups.

New in SQLPro for MSSQL 2022.72 (Feb 3, 2023)

  • Fixed an issue where GO was required to be uppercase. [#835](https://github.com/hankinsoft/SQLPro/issues/835)

New in SQLPro for MSSQL 2022.70 (Sep 14, 2022)

  • Fixed an issue with offline databases.

New in SQLPro for MSSQL 2022.46 (Sep 14, 2022)

  • Fixed a crash that could occur when filtering results.

New in SQLPro for MSSQL 2022.44 (Sep 14, 2022)

  • Fixed an issue where once the connection groups have been modified, some connections could no longer be accessible.

New in SQLPro for MSSQL 2022.33 (Sep 14, 2022)

  • Fixed a crash that could occur for some users.

New in SQLPro for MSSQL 2022.15 (Mar 15, 2022)

  • General updates.

New in SQLPro for MSSQL 2021.104 (Dec 3, 2021)

  • Made some connection improvements.

New in SQLPro for MSSQL 2021.76 (Dec 3, 2021)

  • Fixed a crash some users could see shortly after startup.

New in SQLPro for MSSQL 2021.72 (Dec 3, 2021)

  • Fixed a crash some users could see shortly after startup.

New in SQLPro for MSSQL 2021.69 (Dec 3, 2021)

  • Improvements to query formatter to use the proper indention.

New in SQLPro for MSSQL 2021.12 (May 21, 2021)

  • Fixed a crash some users were seeing at launch.

New in SQLPro for MSSQL 2021.11 (May 21, 2021)

  • Fixed an issue where duplicating connections not in the main connection group might cause 2x connections to appear. [#576](https://github.com/hankinsoft/SQLPro/issues/576).
  • Fixed a scrolling issue.
  • Autocomplete suggestion delay improvement. [#394](https://github.com/hankinsoft/SQLPro/issues/394)
  • Fixed an issue with connection groups. [#570](https://github.com/hankinsoft/SQLPro/issues/570).
  • Improvements with CSV import. [#568](https://github.com/hankinsoft/SQLPro/issues/568)
  • Fixed an issue - `Query tab color does not change when changing connection`. [#559](https://github.com/hankinsoft/SQLPro/issues/559)
  • Fixed an issue - `Query results grid reverts to default scroll position (far left) after switching tabs`. [#555](https://github.com/hankinsoft/SQLPro/issues/555)
  • Fixed an issue - `Calling proc results in `Commands out of sync error.`. [#557](https://github.com/hankinsoft/SQLPro/issues/557)
  • Fixed a crash that some users were seeing when exporting results.
  • Fixed a crash that some users were seeing when hitting 'Apply without preview' when editing results.

New in SQLPro for MSSQL 2020.106 (May 21, 2021)

  • Improvements with autocomplete and macOS Big Sur.

New in SQLPro for MSSQL 2020.104 (Nov 30, 2020)

  • Fixed a crash that some users were seeing when exporting results.

New in SQLPro for MSSQL 2020.96 (Nov 30, 2020)

  • MacOS 10.12 or above is now the minimum version supported.
  • Apple silicon support.
  • Fixed an issue with newlines on export. [#522](https://github.com/hankinsoft/SQLPro/issues/522)
  • Fixed a crash which could occur when running large queries. [#514](https://github.com/hankinsoft/SQLPro/issues/514)
  • Importing a CSV file now has the option to truncate the target table before importing. [#511](https://github.com/hankinsoft/SQLPro/issues/511)

New in SQLPro for MSSQL 2020.88 (Nov 30, 2020)

  • Fixed a crash that could occur when closing tabs.

New in SQLPro for MSSQL 2020.87 (Nov 30, 2020)

  • Fixed an issue which could cause crashes for macOS 10.11 users.
  • Fixed a keyboard shortcut issue when using Dvorak layout.
  • Multi cursor improvements with arrow up/down cursor selection.
  • Fixed an issue with query line numbers display.
  • Fixed an issue where some columns may be missing in the database tree.
  • Fixed a crash that could occur on the connections list window.

New in SQLPro for MSSQL 2020.82 (Nov 30, 2020)

  • Fixed an issue that could cause a crash when inserting/duplicating rows, deleting rows, then cancelling actions together on the results grid.
  • Added the common enter/exit full-screen keyboard shortcut. [#497](https://github.com/hankinsoft/SQLPro/issues/497).
  • Multi-cursor improvements. Cmd+Delete and Opt+Delete now work properly.
  • Fixed an issue where tables with periods were not handled properly. [#496](https://github.com/hankinsoft/SQLPro/issues/496)
  • Keyboard support added for selecting multi-cursors. Cmd+Option+Up/Down arrows.
  • Fixed a few crashes which could occur with multi-cursors.
  • Improved pasting with multi-cursors.
  • Fixed an issue when inserting rows where the string 'default' could sometimes be used rather than the default value.

New in SQLPro for MSSQL 2020.76 (Nov 30, 2020)

  • Fixed an issue where right clicking on a result set and choosing 'Edit' would sometimes show an empty dialog.
  • When connecting to a MSSQL server with an expired password, you can now set a password.
  • Some improvements with the autocomplete cache.
  • Fixed a performance issue with MSSQL connections.
  • Fixed an issue with parsing MSSQL queries.

New in SQLPro for MSSQL 2020.72 (Aug 17, 2020)

  • Fixed a performance issue with MSSQL connections.

New in SQLPro for MSSQL 2020.71 (Aug 13, 2020)

  • Fixed an issue where when creating tables, the database tree UI may show garbage values for the table name.
  • Fixed an issue with shift + click to select text.
  • Sorting results from a 'basic select' will now use the database server to perform the sort. [#381](https://github.com/hankinsoft/SQLPro/issues/381)
  • Fixed a crash that could occur when right-clicking a result and choosing 'edit'.
  • Fixed an issue where pasting was sometimes using overwrite rather than insert. [#483](https://github.com/hankinsoft/SQLPro/issues/483)
  • Multicursor support. [#200](https://github.com/hankinsoft/SQLPro/issues/200)

New in SQLPro for MSSQL 2020.68 (Aug 10, 2020)

  • Fixed an issue where autocomplete could sometimes remove newlines. [#481](https://github.com/hankinsoft/SQLPro/issues/481)
  • You can now 'reverse-cycle' the autocomplete window. [#473](https://github.com/hankinsoft/SQLPro/issues/473)
  • Working on resolving an issue where the cursor position might jump when autocomplete is entered. [#476](https://github.com/hankinsoft/SQLPro/issues/476)
  • Added some advanced connection options. You can now specify `Encryption level`, `Use NTLMv2` and `Enable TLSv1`.
  • Autocomplete delay has been reset to the default (1.25 seconds). Due to a bug which had caused some users autocomplete to set to zero.
  • Performance improvements for autocomplete cache (was causing slowdowns on startup for some users). [#468](https://github.com/hankinsoft/SQLPro/issues/468)
  • Adding or removing tables via the query editor (ie CREATE TABLE/DROP TABLE) will now update the database tree and autocomplete. [#10](https://github.com/hankinsoft/SQLPro/issues/10)
  • Improvement with SSH tunnelling. Previously, every connection created a new tunnel. Now tunnels can be reused.
  • Autocomplete now wraps when using up/down keys. [#473](https://github.com/hankinsoft/SQLPro/issues/473)
  • Selected rows in the results grid now highlight the row numbers. [#465](https://github.com/hankinsoft/SQLPro/issues/465)
  • Adding/removing/altering a table will now update the database tree and autocomplete. [#10](https://github.com/hankinsoft/SQLPro/issues/10)

New in SQLPro for MSSQL 2020.61 (Jul 6, 2020)

  • Fixed insertion text for CTEs and aliases. [#296](https://github.com/hankinsoft/SQLPro/issues/296)
  • Database names colors are now customizable for the query editor. [#404](https://github.com/hankinsoft/SQLPro/issues/404)
  • Made some attempts at fixing autocomplete window sometimes appearing in the incorrect location. [#377](https://github.com/hankinsoft/SQLPro/issues/377)
  • Autocomplete delay now has a preference. [#394](https://github.com/hankinsoft/SQLPro/issues/394)
  • Fixed a crash some MSSQL users would see.
  • Fixed an issue where importing CSVs into a new table would fail. [#447](https://github.com/hankinsoft/SQLPro/issues/447)
  • Improved support for SSH tunnelling when using 'restored UI'.

New in SQLPro for MSSQL 2020.59 (Jul 3, 2020)

  • Fixed an issue where when inserting rows, the inserted rows would not be visible once applied (until re-queried).
  • Fixed an issue where opening files created from Microsoft SQL Server would fail.
  • Added 'IS NULL' and 'IS NOT NULL' to result filters. [#402](https://github.com/hankinsoft/SQLPro/issues/402)
  • Fixed an issue which may display some newly purchased licenses as invalid.
  • Syntax highlighting and autocomplete now includes support for objects in other databases (on the same server). [#404](https://github.com/hankinsoft/SQLPro/issues/404)
  • Autocomplete now detects if a table is outside of your current schema and will add the proper schema if required. [#296](https://github.com/hankinsoft/SQLPro/issues/296)

New in SQLPro for MSSQL 2020.48 (Jul 3, 2020)

  • Fixed an issue where when inserting rows, the inserted rows would not be visible once applied (until re-queried).

New in SQLPro for MSSQL 2020.47 (May 22, 2020)

  • You can set function keys as keyboard shortcuts. [426](https://github.com/hankinsoft/SQLPro/issues/426)
  • You can now rename tabs be either double clicking a tab title, or right clicking and choosing 'Rename'.
  • Fixed a crash that could occur when updating results.
  • Fixed an issue which could cause crashes when updating results.
  • Fixed an issue which could cause crashes when expanding JSON results.
  • Fixed an issue where 'Modify' or 'Script as Alter' may display CREATE rather than alter for Stored Procedures. [#432](https://github.com/hankinsoft/SQLPro/issues/432)
  • Fixed an issue when editing results and hitting 'Apply' (without preview) would sometimes generate an error.
  • Fixed an issue when using multiple result sets and editing/deleting the resultset past the first would use the table name of the first result set.
  • If no tabs are open and the history menu item is clicked or the keyboard shortcut is activated, a new tab will be opened with the history popup visible.
  • Inserting rows via the results grid no longer pops up an insert dialog. You can still access the dialog by right clicking a row and choosing 'Edit'. [#401](https://github.com/hankinsoft/SQLPro/issues/401)
  • You can now duplicate rows in the results grid. [#57](https://github.com/hankinsoft/SQLPro/issues/57)
  • Improvements for database access.
  • Added an option to hide database the user does not have access to.

New in SQLPro for MSSQL 2020.42 (May 13, 2020)

  • Fixed an issue which could cause crashes when skipping columns during CSV import. [#424](https://github.com/hankinsoft/SQLPro/issues/424)
  • Fixed an issue which could cause crashes when cancelling a query or closing an tab with an active query running. [#416](https://github.com/hankinsoft/SQLPro/issues/416)
  • Fixed an issue where right clicking on an escaped table name in the query editor would sometimes result in a 'No object selected' issue. [#396](https://github.com/hankinsoft/SQLPro/issues/396)
  • Fixed an issue with keyboard shortcuts would not save properly if tab characters were used. [#403](https://github.com/hankinsoft/SQLPro/issues/403)
  • Fixed an issue where when importing from CSV, the focused table may not be defaulted. [#405](https://github.com/hankinsoft/SQLPro/issues/405)
  • No longer setting `SET QUOTED_IDENTIFIER OFF` when updating results.
  • You can now specify IDENTITY details when creating a new table or adding a new column. [#374](https://github.com/hankinsoft/SQLPro/issues/374)
  • You can now reorder columns when creating a table.

New in SQLPro for MSSQL 2020.35 (Apr 22, 2020)

  • Fixed an issue with tabs in the query editor. [#395](https://github.com/hankinsoft/SQLPro/issues/395)
  • Improvements with the History popup. [#400](https://github.com/hankinsoft/SQLPro/issues/400)
  • Alias improvements. [#396](https://github.com/hankinsoft/SQLPro/issues/396)
  • When modifying rows via the results-grid there is now an 'Apply' button, so that changes can be applied without needing to preview first.
  • Result messages are now monospaced.
  • Result messages now uses the same font size as the query text editor.
  • Result error messages are now more of a 'whiteish-pink' when using a dark theme (a bit easier on the eyes).
  • Fixed an issue where 'Copy as Insert' did not escape table names. [#390](https://github.com/hankinsoft/SQLPro/issues/390)
  • Additional improvements for ipv6 addresses. [#380](https://github.com/hankinsoft/SQLPro/issues/380)
  • Added a 'Read-only' intent option (currently for MSSQL). When this option is enabled, all DROP, TRUNCATE, DELETE, UPDATE, INSERT, etc related UI is hidden from the user. This will NOT prevent the user from creating and running their own SQL commands. [#386](https://github.com/hankinsoft/SQLPro/issues/386)
  • Additional improvements for ipv6 addresses. [#380](https://github.com/hankinsoft/SQLPro/issues/380)
  • Fixed an issue which could cause a crash when expanding/collapsing connections groups.
  • Improvements on handling syntax highlighting if object types conflict. [#298](https://github.com/hankinsoft/SQLPro/issues/298)
  • Fix for ipv6 addresses. [#380](https://github.com/hankinsoft/SQLPro/issues/380)
  • You can now add custom connection groups. [#119](https://github.com/hankinsoft/SQLPro/issues/119)
  • You can now expand and collapse connection groups.
  • Fix for 'blue turds' in query text view. [via twitter](https://twitter.com/danielpunkass/status/1236062931097473024?s=21)
  • Fixed an issue where autocomplete may sometimes escape object object when not required. [346](https://github.com/hankinsoft/SQLPro/issues/346)
  • Added support for SSH Tunnel keyboard authentication. [#367](https://github.com/hankinsoft/SQLPro/issues/367)
  • Fixed an issue when CSV importing when column name case did not match the csv file.
  • Failed CSV imports now have a 'view insert' option which displays the failed insert statement.
  • Fixed an issue where having cap-locks on would disable tab indent/un-indent. [#335](https://github.com/hankinsoft/SQLPro/issues/335)
  • Added support for ed25519 keys.
  • Fixed a crash with autocomplete.
  • SSH Tunnel dialog now has a 'Validate' option to verify private key and password.
  • Fixed an issue where some users may occasionally see 'Write to server failed' error message when running queries.
  • Fixed an issue where the SQL beautifier would add an extra space at the end of lines. [#362](https://github.com/hankinsoft/SQLPro/issues/362)
  • If you select a Table or Column in the database tree, hitting Copy (via ctrl-c or menu items) will copy the table schema/name or column name to the clipboard.
  • Fixed a crash that could occur with the 'Format Query' action.
  • Fixed a crash that could occur when clicking on Foreign Keys in the results data grid.
  • Improved autocomplete with 'order by' clause. Now limits to tables used in the query.
  • Autocomplete is now a background operation. If for some reason the autocomplete is slow it will no longer freeze the main UI thread. [#334](https://github.com/hankinsoft/SQLPro/issues/334).
  • Fixed an issue where closing tabs may not disconnect the client. [#353](https://github.com/hankinsoft/SQLPro/issues/353)

New in SQLPro for MSSQL 2019.70 (Dec 20, 2019)

  • Fixed a crash that could when inserting a new row.
  • Fixed a crash that could occur with autocomplete.
  • Improvements to database search.
  • Fixed an issue with CSV import into existing table.
  • Fixed an issue with state restoration. The database tree was not getting preserved when you disconnect from a database.
  • Fixed a crash that could occur when duplicating tables.
  • Fixed an issue when duplicating tables where the source table was not always the one duplicated if the source table was not the table select in the database tree.
  • Fixed an issue which could cause crashes when inserting into a result set.

New in SQLPro for MSSQL 2019.61 (Nov 29, 2019)

  • You can now duplicate tables (including data) via the database tree.
  • Autocomplete is now context sensitive when using the UPDATE command.
  • The 'current query highlighting' is now disabled by default (matches previous versions of the app). It can be enabled in the Application preferences.

New in SQLPro for MSSQL 2019.60 (Nov 28, 2019)

  • Fixed an issue with setting the current theme (the theme preference display would be incorrect upon next app launch).
  • Fixed an issue where running multiple queries with result sets may collapse the results.
  • Fixed an issue with scripting procedures which could reset QUOTED_IDENTIFIERS to the incorrect value.
  • Split `Copy as -> Formatted text` into two separate options. `Formatted text (Markdown)` and `Formatted text (Monospace)`.

New in SQLPro for MSSQL 2019.59 (Nov 26, 2019)

  • Performance improvements for autocomplete.
  • Fixed a crash which could occur with autocomplete.
  • 'Execute button' now has additional options.
  • Fixed an issue with datetime columns applying a timezone offset.
  • Improvements to state restore where not all tabs were always being restored.
  • Result grid editing - Primary keys are no longer required (but are still encouraged).
  • Result grid editing - When editing cells, changes are no longer applied until the new 'Preview and Apply' button has been pressed. A discard button is also available.
  • Result grid editing - Shift-Tab now works to move to the previous cell (and regular tab now works better due to the previously mentioned change).
  • Importing CSVs into Oracle is now quicker to list tables.
  • Improved background drawing in query text view when query execution style is 'execute query in cursor range'.
  • Quoted column names are now handled by syntax highlighting.

New in SQLPro for MSSQL 2019.54 (Nov 7, 2019)

  • Fixed an issue with some MSSQL connections which could crash when failing to determine default schemas.

New in SQLPro for MSSQL 2019.53 (Nov 6, 2019)

  • [macOS] Fixed an issue where some MSSQL users may not see tables when the database tree is expanded.
  • [macOS] Fixed an issue where the 'databases' dropdown in the new/edit connection window could cause a crash.

New in SQLPro for MSSQL 2019.46 (Oct 23, 2019)

  • [MSSQL] Fixed an issue where datetime(2) fields were not properly displaying milliseconds.

New in SQLPro for MSSQL 2019.45 (Oct 23, 2019)

  • Fixed an issue with setting values from result sets.
  • Autocomplete is now context sensitive. For example, if you enter `SELECT * FROM myTable WHERE ` autocomplete will suggest myTable and columns related to myTable.
  • Boolean fields now appear with color (green for true, red for false - this is a prefernce which can be disabled).

New in SQLPro for MSSQL 2019.09.03 (Sep 5, 2019)

  • Fixed a case where connections to a MSSQL server could fail.

New in SQLPro for MSSQL 2019.07.16 (Jul 17, 2019)

  • Fixed an issue with numeric data types not displaying scale.
  • Fixed an issue with 'Format Query' not handling GO statements.

New in SQLPro for MSSQL 2019.05.29 (Jun 26, 2019)

  • MSSQL script tables now includes foreign keys.
  • Fixed an issue where many 'Untitled files' would appear in iCloud Drive.
  • Resolved some issues with SSH Tunneling.
  • You can now duplicate connections.
  • You can now customize results grid appearance.

New in SQLPro for MSSQL 1.0.460 (Apr 19, 2019)

  • Fixed an issue where the app could close for some users when opening preferences.
  • The connections window is now resizable on systems running macOS 10.14 and above.
  • Autocomplete no longer requires the AS keyword to detect table aliases.

New in SQLPro for MSSQL 1.0.456 (Apr 11, 2019)

  • Added a new 'keyboard' preferences panel:
  • Query execute shortcut has been moved to this panel.
  • Comment/uncomment keyboard shortcut has been added.
  • Default separator and qualifier for copying results can now be specified. It defaults to comma and double quote, but you can change it as needed.
  • You can now use CTRL + ] to switch between the beginning/end of control statements.

New in SQLPro for MSSQL 1.0.425 (Mar 15, 2019)

  • Stability improvements - fixed a long standing crash that only occurred occasionally.

New in SQLPro for MSSQL 1.0.401 (Feb 13, 2019)

  • Dragging tables from the database tree into the query editor will prepend the schema name if required.

New in SQLPro for MSSQL 1.0.317 (Jan 11, 2019)

  • Fixed a crash that could occur on macOS High Sierra or earlier.

New in SQLPro for MSSQL 1.0.316 (Jan 11, 2019)

  • Added a lifetime purchase option.

New in SQLPro for MSSQL 1.0.315 (Nov 16, 2018)

  • Fixed an issue with results display for certain column types

New in SQLPro for MSSQL 1.0.308 (Oct 15, 2018)

  • Fixed a crash that could occur when cancelling queries.

New in SQLPro for MSSQL 1.0.300 (Sep 20, 2018)

  • Support for Mojave and dark mode.

New in SQLPro for MSSQL 1.0.213 (Aug 28, 2018)

  • Select now defaults to 1,000 records rather than 100.

New in SQLPro for MSSQL 1.0.211 (Aug 16, 2018)

  • Resolved a few performance issues.
  • Made some changes in preparations for an upcoming os.

New in SQLPro for MSSQL 1.0.210 (Aug 9, 2018)

  • SQLPro for MSSQL is now free to use for a single connection.
  • Added a color picker for connections. Selecting a color is a great way to identify development vs production servers.

New in SQLPro for MSSQL 1.0.204 (May 4, 2018)

  • You can now disable sample connections in the app preferences.
  • Fixed some issues with resolving connection ip/port from server name.
  • Fixed a crash that could occur on connection.
  • Closing multiple tabs now prompts with an option to review unsaved changes ignoring any changes.

New in SQLPro for MSSQL 1.0.200 (Apr 6, 2018)

  • Added a context option for scripting indexes.
  • Scripting tables will now include calculated field definitions.

New in SQLPro for MSSQL 1.0.196 (Feb 15, 2018)

  • Fixed an issue which could cause connections to hang when specifying both a named instance and a port.

New in SQLPro for MSSQL 1.0.195 (Feb 8, 2018)

  • The connection window now includes a sample server.
  • Fixed 'User table type' -> 'Script as' actions. (They were always returning 'unhandled').

New in SQLPro for MSSQL 1.0.189 (Oct 12, 2017)

  • Images & PDF's can now be previewed in the results grid.
  • Results grid better displays images & pdfs.
  • Json export improvements for nulls and numeric values.

New in SQLPro for MSSQL 1.0.186 (Oct 2, 2017)

  • Improvements to database searching.
  • Added support for High Sierra.
  • Yosemite is no longer supported.

New in SQLPro for MSSQL 1.0.171 (Aug 4, 2017)

  • Fixed an issue with keyboard navigation/selection.

New in SQLPro for MSSQL 1.0.170 (Jul 24, 2017)

  • Greatly improved memory + performance when selecting results.
  • Fixed an issue where 'shift left' + 'shift right' (cmd + [, cmd + ]) were not using tab style.

New in SQLPro for MSSQL 1.0.165 (Jul 5, 2017)

  • Added support for nested multiline comments.
  • Fixed a crash that could occur related to multiline comments in general.

New in SQLPro for MSSQL 1.0.164 (Jun 29, 2017)

  • Improvements to connection handling.
  • Easier access menu for result sets.

New in SQLPro for MSSQL 1.0.152 (May 5, 2017)

  • Fixed a crash some users could see when closing tabs.
  • Added a keyboard shortcut (ctrl + ]) to move between matching brackets.

New in SQLPro for MSSQL 1.0.135 (Dec 21, 2016)

  • Fixed an autocomplete issue where some table names could be missing from the completion list.
  • Resolved an issue with window authentication not always working.

New in SQLPro for MSSQL 1.0.127 (Nov 16, 2016)

  • Fixed an issue where deleting from results grid may not prepend a tables schema.

New in SQLPro for MSSQL 1.0.122 (Nov 7, 2016)

  • Connection screen now properly detects port for named instances.
  • Netbios lookup via smbutil is only used if the system is unable to detect a host. (Previously netbios was resolved first).

New in SQLPro for MSSQL 1.0.113 (Oct 12, 2016)

  • Improvements for data loading.

New in SQLPro for MSSQL 1.0.110 (Sep 30, 2016)

  • Improvements for Sierra.

New in SQLPro for MSSQL 1.0.106 (Sep 3, 2016)

  • Added an option for a 'darker results grid'. Its in the preferences -> appearance settings.
  • Improvements to Azure support.
  • Added support for SQL 2000 to the database tree. The table designer is still not supported for SQL 2000.

New in SQLPro for MSSQL 1.0.95 (Jul 28, 2016)

  • Fixed an issue where the application would not launch on certain OS versions.
  • Fixed an issue with XML columns appearing as 'unknown type'.

New in SQLPro for MSSQL 1.0.86 (Jul 17, 2016)

  • Resolved an crash for users without a default schema.
  • Resolved a crash that could cause crashes if scrolling happens before a result set has finalized.

New in SQLPro for MSSQL 1.0.82 (Jun 23, 2016)

  • Fixed an issue where date columns were not being displayed correctly.
  • Fixed a crash that could occur if a CSV import fails.

New in SQLPro for MSSQL 1.0.80 (Jun 22, 2016)

  • Fixed an issue where sorting large result sets (generally ten million plus) by a date column could cause a crash.
  • Improvements for handling non-default schemas in the table designer.
  • A few internal performance improvements.

New in SQLPro for MSSQL 1.0.76 (Jun 11, 2016)

  • SQL confirmation dialog for deleting indexes both in table designer and database tree.
  • If a database tree node fails to expand an error node will be added with failure details.
  • Fixed an issue where expanding large database nodes would cause the database tree to 'draw over itself'.
  • Fixed an issue with the 'execute procedure' dialog which may not accept an entered procedure argument.
  • Fixed a crash when attempting to right click and insert into a result set.
  • Fixed a crash that could occur when creating a new table.
  • Fixed an issue where some database connections could be left open.

New in SQLPro for MSSQL 1.0.68 (May 26, 2016)

  • A few users were having crashes as soon as a connection is established. This version should resolve the issue. If you still see it, please contact kyle @ hankinsoft.com.

New in SQLPro for MSSQL 1.0.64 (May 20, 2016)

  • Auto complete now shows column data types.
  • Added crash recovery. In the event of a system shutdown, or application cash,
  • queries should be recovered on next launch.
  • Fixed a freezing issue that could happen when selecting to the start of the previous line (cmd + shift + left keyboard shortcut).
  • Fixed an issue with renaming tables.
  • Improved support for schemas in autocomplete (and syntax highlighting).
  • Fixed an issue with autcomplete that could use the previous word.

New in SQLPro for MSSQL 1.0.23 (Dec 4, 2015)

  • Added a new improved connection screen.
  • Added a new sql history viewer.
  • Added import from CSV (with create new table option).
  • Fixed multiple issues with date formatting.
  • Improved user notifications.
  • Fixed a crash when starting/stopping query execution quickly.
  • Fixed a crash that could happen when closing a tab happened before a query had loaded.
  • The database tree now has a few new keyboard shortcuts:
  • Cmd + Down on an table or view will select the first 100 rows.
  • Cmd + Right will open the entry in the designer.

New in SQLPro for MSSQL 1.0.21 (Sep 7, 2015)

  • New app icon.
  • Streaming results - Previously when executing queries, data would not be available until all of the data (pre query) had returned. Now data will begin to appear and update as the data becomes available.
  • You can now inline sort query results.
  • Fixed an issue where closing an unsaved tab (and choosing save) may sometimes cause the tab to stay open.
  • Added keyboard shortcuts for switching tabs. (Cmd+Shift+[ for previous tab, Cmd+Shift+] for next tab).
  • Fixed an issue where closing many tabs quickly (cmd+w repeatedly) could cause crashes.
  • Improved multiple result-set auto resizing.
  • Added support for 'Execute current query' mode (rather than executing all queries only the current query as split by delimiters will be executed).
  • Return key now works as a shortcut for the connection screen.
  • Improvements to syntax highlighting performance.
  • Fixed an issue which could sometimes cause crashes during syntax highlight.
  • Added a pully on the results view for easier resizing.
  • Added a query history dropdown, plus keyboard shortcut (Cmd-Shift-H).
  • Added a toolbar with hide/show sidebar and results options.
  • Line breaks in table results now get replaced with a ΒΆ character to make the details easier to see.
  • Query execution now stops on the first error.
  • Warning/Error icon on tab when a query fails.
  • Double clicking text in a quote (such as "helloworld" no longer selects the quotes by default. You now need to be holding the alt key for the quotes to be selected.
  • Improved column display in the tree-view.
  • Copying text from the query view now includes a rich copy (specifically rtf and html both get includeded).
  • Hitting space with autocomplete is visible now inserts a space rather than adds the completed word. This is to match default mac (and ssms) behaviour. Rather the enter key or tab must be used to trigger completion.
  • Window size/position should now be saved through connections.
  • Mouse drag to select multiple rows in the results view.
  • Schema and table names are no longer escaped in the tree view display.
  • Improvements to variable detection + highlight.
  • Fixed a datetime/epoch issue.
  • Fixed an issue which could cause a crash when users filter, then modify a function.
  • Fixed an issue where cmd + right could go to the next line rather than the current line.
  • Added tab context menus 'New query tab', 'Close tab' and 'Close other tabs'.

New in SQLPro for MSSQL 1.0.20 (Apr 17, 2015)

  • Toolbar style updated on Yosemite.
  • Fixed an issue where altering stored procedures may not load.
  • Improved database tree display for single schema databases.
  • Fixed a few issues with changing a columns data type via the table designer.
  • Improvements to auto-complete.
  • Fix for line numbers in OS X Yosemite 10.10.3.

New in SQLPro for MSSQL 1.0.18 (Feb 26, 2015)

  • Fixed an issue where closing a background tab would prompt to save the current tab.
  • Fixed an issue that could cause crashes when deleting a column or table.
  • Fixed an issue which could cause crashes when expanding encrypted triggers.
  • Fixed an issue that could sometimes cause problems when typing queries in non-engligh keyboards.
  • Support for blank passwords.
  • Binary data in results grid now displays as it would in Microsoft Management studio.
  • Improved initial connection performance.

New in SQLPro for MSSQL 1.0.16 (Feb 7, 2015)

  • Connect now uses the current window if there is one, otherwise it uses a new document.
  • Added keyboard shortcut for connect button (Command-Shift-C).
  • Updated logic for the new tab shortcut.
  • Fixed a crashing issue that could happen during query editor undo/redo.
  • Fixed an issue with connecting to Azure databases.

New in SQLPro for MSSQL 1.0.15 (Feb 5, 2015)

  • Picking a database via the database dropdown now closes the selection window.
  • Auto complete fixes.
  • Improved application state saving.
  • Added support for NTMLv2.
  • Fixed a crash that could happen when editing data.
  • Fixed an issue that could cause the save and save as menus to become disabled.

New in SQLPro for MSSQL 1.0.14 (Jan 19, 2015)

  • Product renamed to SQLPro for MSSQL.
  • Fixed an issue where column 'scale' did not show up properly in the columns view or when scripting a table.