Navicat for SQL Server Changelog

What's new in Navicat for SQL Server 16.3.6

Feb 21, 2024
  • Bug-fixes:
  • Crashed when presenting dashboard in some cases.
  • Unable to change data types when creating tables.
  • Focus moved to the upper level after deleting an object in Navigation Pane.
  • "Invalid cursor state" error occurred in SQL Server connection.
  • Some labels disappeared after adding the chart to the dashboard.
  • Unable to display proportion percentages in the chart axis.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.3.5 (Feb 21, 2024)

  • Bug-fixes:
  • Crashed when closing Server Monitor.
  • Crashed when switching tabs on Information Pane.
  • The percentage values shown in the chart were incorrect.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.3.4 (Dec 12, 2023)

  • Bug-fixes:
  • Crashed when opening Navicat on older macOS versions.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.3.3 (Dec 12, 2023)

  • Bug-fixes:
  • Column widths were not retained when opening tables/views.
  • Crashed when scheduling batch jobs in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.3.2 (Nov 7, 2023)

  • Bug-fixes:
  • COMMAND-F shortcut did not work in the main window.
  • Refresh button did not work in Server Monitor.
  • Text in the Search box was hidden in some cases.
  • Advanced options in Structure Synchronization cannot be displayed.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.3.1 (Oct 30, 2023)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.3.0 (Oct 17, 2023)

  • Bug-fixes:
  • Crashed when transferring large tables using SSH connection.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.2.9 (Sep 21, 2023)

  • Bug-fixes:
  • "The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values." error occurred when importing data to SQL Server.
  • Crashed on macOS 14.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.2.7 (Aug 29, 2023)

  • Bug-fixes:
  • Beautify SQL incorrectly added spaces between the function name and parentheses.
  • "Parameters supplied for object 'xxx' which is not a function" error occurred when adding record in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.2.6 (Aug 29, 2023)

  • Bug-fixes:
  • Syntax error occurred when creating SQL Server database.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.2.5 (Jul 14, 2023)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.2.3 (Jun 21, 2023)

  • Bug-fixes:
  • Copy and paste shortcuts did not work in Navigation pane.
  • The focus jumped to the top level after renaming an object in Navigation pane.
  • Table tree loading issue in Navigation Pane.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.2.2 (Jun 9, 2023)

  • Improvements:
  • Improve SQL Server Trigger editor.
  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.2.1 (Jun 9, 2023)

  • Main New Features:
  • Show fields, indexes and more under tables in Navigation Pane.
  • Minor bug fixes and improvements.
  • Navicat for Redis is released.

New in Navicat for SQL Server 16.1.10 (May 31, 2023)

  • Bug-fixes:
  • High CPU usage when using SSH connection.
  • Unable to save the schedule changes.
  • TAB key did not work when adding field.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.1.9 (Apr 18, 2023)

  • Bug-fixes:
  • Crashed when opening Preferences in some cases.
  • Unable to save changes in SQL Server View.
  • Crashed when importing database to model in some cases.
  • Crashed when saving table after changing field comment.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.1.7 (Mar 2, 2023)

  • Bug-fixes:
  • Memory utilization issue.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.1.6 (Mar 2, 2023)

  • Bug-fixes:
  • Unable to backup if database folder did not exist.
  • "SET IDENTITY_INSERT [TableName] ON" was not run before importing in some cases.
  • Unable to load cloud connection info when opening data transfer profile.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.1.5 (Dec 12, 2022)

  • Bug-fixes:
  • Default value did not show when adding new records.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.1.4 (Nov 26, 2022)

  • Bug-fixes:
  • Bar chart label display issue.
  • BLOB data was truncated in Console.
  • Table columns were not aligned in Console.
  • Chart value labels disappeared after reopening Navicat in dark mode.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.1.3 (Sep 29, 2022)

  • Bug-fixes:
  • Query Builder did not recognize the selected fields.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.1.2 (Sep 29, 2022)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.1.1 (Aug 21, 2022)

  • Bug-fixes:
  • Unable to open the objects in the "Find in Database" window.
  • Crashed when renaming a connection in a group.
  • Cannot show the new group unless Navicat was restarted.
  • Checks were not imported when using "Reverse Database to Model".
  • Unable to sort columns in table viewer.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.1.0 (Jul 21, 2022)

  • Main New Features:
  • Support Trend Line for several chart types.
  • Support adding On-Prem Server with URI.
  • Allow skip preview of changes in data sync.
  • Enhanced responsiveness and performance.
  • Improved UI/UX.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.0.14 (Jun 15, 2022)

  • Bug-fixes:
  • Query parameters did not work in some cases.
  • Function group creation issue.
  • Hanged when updating records in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.0.13 (May 10, 2022)

  • Bug-fixes:
  • Chart title display issue.
  • Query listing issue when loading cloud queries.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.0.12 (Mar 28, 2022)

  • Bug-fixes:
  • Crashed when opening a table in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.0.11 (Mar 16, 2022)

  • Bug-fixes:
  • Add/Delete Foreign Key issue in ER diagram.
  • "Show bar labels" setting cannot be saved in Charts.
  • Crashed when moving a connection from Navicat Cloud to My Connections.
  • Crashed when running Automation in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.0.9 (Mar 1, 2022)

  • Bug-fixes:
  • Crashed when using table viewer.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.0.8 (Mar 1, 2022)

  • Bug-fixes:
  • Crashed when closing Navicat in some cases.
  • Hanged when designing table.
  • Unable to scroll through the fields with the mouse wheel in Query Builder.
  • Connection coloring did not work on subtabs.
  • Crashed when importing invalid json files.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.0.7 (Jan 13, 2022)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.0.6 (Jan 3, 2022)

  • Bug-fixes:
  • Line numbers disappeared when scrolling in Query Editor.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.0.5 (Dec 15, 2021)

  • Bug-fixes:
  • Crashed in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 16.0.3 (Nov 23, 2021)

  • Main New Features:
  • New Data Generation Tool
  • Enhanced Charts Feature
  • Support of Navicat On-Prem Server
  • Additional Features:
  • Connection Profiles
  • Field Information Pane
  • Query Execution Summary
  • Navicat On-Prem Server is released
  • Many other new features and improvements

New in Navicat for SQL Server 15.0.32 (Nov 14, 2021)

  • Bug-fixes:
  • Crashed when running scripts in some cases.
  • Crashed when copying records in some cases.
  • The TEXT pane did not retain when running queries.
  • Cannot connect to Microsoft Azure Database in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.30 (Aug 20, 2021)

  • Bug-fixes:
  • Unable to show the cursor when editing TEXT data using Form View in Dark Mode.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.29 (Jun 29, 2021)

  • Bug-fixes:
  • Crashed when running query in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.28 (May 3, 2021)

  • Bug-fixes:
  • Crashed when using Data Transfer in some cases.
  • Cursor did not focus to the Search box after pressing CMD-F.
  • Crashed when selecting the "Group by Object Type" in Structure Synchronization.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.26 (Mar 8, 2021)

  • Bug-fixes:
  • Unable to read grid data in Dark mode.
  • Unable to sort the last column by clicking the column header in Table Viewer.
  • Duplicate entry error occurred when editing the pasted records.
  • Hanged when starting Navicat in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.25 (Jan 15, 2021)

  • Bug-fixes:
  • 'Primary key needs to be integer' error occurred when synchronizing data.
  • Unable to sort by clicking the column header in Table Viewer.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.24 (Dec 16, 2020)

  • Improvements:
  • Set the values of a column to NULL.
  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.22 (Oct 12, 2020)

  • Bug-fixes:
  • Only the last selected table was printed when printing multiple tables.
  • The SQL Editor was flickered and repainted when saving the query.
  • Crashed when using Query Builder on Big Sur.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.21 (Sep 15, 2020)

  • Bug-fixes:
  • The "Set to Null" option was applied to a wrong column when some columns were hidden in Table Viewer.
  • The field size was incorrect in Form View.
  • Crashed when opening/testing a connection after changing "Settings Location" to a folder in Documents.
  • "Dump SQL File" stopped running in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.20 (Aug 4, 2020)

  • Bug-fixes:
  • Schedule did not trigger when using Navicat App Store version.
  • The "Close Database" option in the context menu was dimmed when a query tab was focused.
  • The entire connection tree was collapsed when searching.
  • Crashed when deleting a data source in Charts.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.18 (Jun 23, 2020)

  • Improvements:
  • Improvement on resizing Information pane.
  • Bug-fixes:
  • No records were imported in some cases when Import Wizard displayed "Finished Successfully".
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.17 (Jun 5, 2020)

  • Bug-fixes:
  • Unable to show full table names in the Data Synchronization window.
  • Field names in the Join dialog were truncated.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.16 (May 18, 2020)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.15 (May 6, 2020)

  • Bug-fixes:
  • Jumped to the first record when refreshing in Form View.
  • Unable to set SET IDENTITY_INSERT ON in Data Synchronization.
  • The list of the reference tables for foreign key was empty in Model.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.14 (Apr 16, 2020)

  • Bug-fixes:
  • The state of the pane in model was not retained.
  • Crashed when synchronizing SQL Server data.
  • Field count was missing in Table Designer.
  • Crashed when opening Console.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.12 (Mar 23, 2020)

  • Bug-fixes:
  • "9015: Error Moving Error" error occurred when using Navicat Cloud.
  • Crashed when clicking the Next button without choosing a target database in Data Transfer.
  • Unable to show the whole Trial Reminder dialog.
  • Crashed when editing/composing new queries in some cases.
  • Invalid XML error occurred when importing connections.
  • Crashed when starting Data Transfer in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.11 (Feb 28, 2020)

  • Bug-fixes:
  • Console was missing in Standard eidtion.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.10 (Feb 28, 2020)

  • Bug-fixes:
  • Crashed when using Data Transfer in some cases.
  • Inserted records to the target server when transferring views.
  • CPU usage was high when using Query Builder.
  • Unable to open the main window when starting Navicat.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.8 (Jan 16, 2020)

  • Bug-fixes:
  • Crashed when starting Navicat.
  • Dates before 1900 were exported as numeric values when exporting to Excel.
  • The Search feature did not work properly in the Data Transfer window.
  • Icon and text were not aligned well in the Navigation pane
  • The unchecked "Includes anonymous system profile" option was reverted to check after restarting Navicat.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.7 (Jan 6, 2020)

  • Bug-fixes:
  • Crashed when starting Navicat.
  • Crashed when running Data Transfer in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.6 (Dec 24, 2019)

  • Bug-fixes:
  • Unable to run selected query in some cases.
  • Crashed when using Data Transfer.
  • Unable to show which database is active.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 15.0.4 (Dec 9, 2019)

  • Bug-fixes:
  • Data Synchronization options were unable to save in profile.
  • Auto Layout feature separated notes and labels from layers.
  • Unable to copy SQL query from Process List in Server Monitor.

New in Navicat for SQL Server 15.0.3 (Nov 25, 2019)

  • New Features:
  • New Charts
  • Advanced Data Transfer
  • Brand new Query Builder
  • Enhanced Data Modeling Tool
  • Dark theme UI and Diagram
  • Many other new features and improvements

New in Navicat for SQL Server 12.1.27 (Oct 16, 2019)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.26 (Oct 9, 2019)

  • Bug-fixes:
  • Unable to change the Settings Location path of Navicat Cloud connections.
  • A red exclamation mark was incorrectly displayed on the Navicat Cloud query icon.
  • "Add Object Privileges" UI issue when using Dark Mode.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.25 (Sep 17, 2019)

  • Bug-fixes:
  • Unable to search in menu bar / Help.
  • Unable to show the database list when there was more then 255 databases.
  • Data Transfer process was stopped in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.24 (Jul 24, 2019)

  • Bug-fixes:
  • Error occurred when running multiple SQL Server queries (ended with ;) in Query Editor.
  • List View was not retained in the main window after restarting Navicat.
  • The backup context menu was incorrect when the SQL Server connection was not opened.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.23 (Jun 12, 2019)

  • Crashed when running query in some cases.
  • Unable to use the Add Privilege button.
  • Connections moved out of the group after editing.
  • "Incorrect syntax near ','" occurred when importing accdb file to SQL Server.
  • Crashed when editing model in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.22 (May 24, 2019)

  • Bug-fixes:
  • Empty tables were created when importing .accdb file.
  • Run Selected option did not run all highlighted text when using shortcut to select the SQL.
  • SSH connection dropped issue.
  • Unable to retain selected columns in Foreign Key Selection window.
  • Data Synchronization data grid UI issue in Dark Mode.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.20 (Apr 18, 2019)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.19 (Apr 17, 2019)

  • Bug-fixes:
  • Missing "Tools" menu when running an infinite loop in Console.
  • Crashed when comparing databases in Structure Synchronization.
  • Login failed when connecting to Azure SQL Database.
  • Crashed when saving models.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.18 (Mar 21, 2019)

  • Bug-fixes:
  • Grid View and Form View menu options were flipped.
  • The row height of the object list did not match the font size.
  • Column order was incorrect when importing database to model.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.16 (Feb 27, 2019)

  • Improvements:
  • Enter the datetime value directly in the Filter.
  • Bug-fixes:
  • Crashed when opening a database in some case.
  • If the filter value box was opened, Navicat window disappeared when switching to another App.
  • Crashed when using Find feature after updating the data.
  • Crashed when code completion was triggered in large query.
  • Freeze when entering/exiting Full Screen.
  • Selected connection, database and schema names were missing in Data Transfer window.
  • "Directory" textbox became empty when creating SQL Server database.
  • Structure Synchronization was unable to create SQL Server primary or secondary XML indexes.
  • SQL Server Data Transfer was slow.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.15 (Feb 27, 2019)

  • Bug-fixes:
  • Unable to search the grouped queries unless the group was selected.
  • Crashed when using Find in Database/Schema if the connection was not opened.
  • Field comment font color issue when using Dark Mode.
  • SSH key file reselect issue when opening connection in App Store version.
  • Crashed when creating a project.
  • Beautify SQL feature wrongly split text which started with numbers.
  • Row highlight issue when using Dark Mode.
  • Crashed when opening Datetime picker window in Table Viewer.
  • Unable to show line number in SQL Editor on macOS 10.14.
  • Code Folding did not work properly in SQL Editor on macOS 10.14.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.13 (Feb 27, 2019)

  • Bug-fixes:
  • Crashed when opening Navicat if logged in Navicat Cloud.
  • Unable to connect using SSH private key in some cases.
  • Hanged when saving Procedure/Function.
  • Crashed when clicking Views in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.12 (Nov 22, 2018)

  • Bug-fixes:
  • Mojave's Dark Mode did not display properly.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.11 (Nov 22, 2018)

  • Bug-fixes:
  • Stored procedures was not exported properly when using Data Transfer.
  • Import Wizard was slow in some cases.
  • "Connection is in use" message prompted when restarting Navicat if connection password was not stored.
  • Crashed after Navicat was opened in a few minutes.
  • Crashed when showing Navicat Cloud Agreement.
  • Unable to copy data from Table Viewer.
  • Code Completion did not work properly in some cases.
  • Inputted text was not displayed when renaming objects on Navigation Pane in Mojave's Dark Mode.
  • Unable to list the batch jobs in some cases.
  • Connection/Database did not open when dragging tables into it.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.10 (Nov 22, 2018)

  • Bug-fixes:
  • "" tag was repeated twice when exporting HTML file.
  • Crashed when starting Navicat in some cases.
  • Foreign key data selection did not work.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.9 (Nov 22, 2018)

  • Bug-fixes:
  • HTML export did not specify charset.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.8 (Nov 22, 2018)

  • Bug-fixes:
  • Available Jobs list did not sort alphabetically in Automation.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.7 (Aug 29, 2018)

  • Bug fixes:
  • Crash occurred when adding export profile to a batch job in some cases.
  • Navicat got hanged when viewing SQL Preview in new function.
  • Crash occurred when saving new function.
  • Sync User Name with Navicat Cloud option in SSH tab did not work properly.
  • Unable to scroll horizontally in the comparison step of Data Synchronization.

New in Navicat for SQL Server 12.1.6 (Aug 23, 2018)

  • Bug fixes:
  • COMMAND-N new object shortcut did not work.
  • Not Null checkbox state was wrong in Table Designer.
  • Crashed when creating new connection in some cases.
  • Import Target and Field Mapping changed after changing the source file in profile.
  • Error occurred when editing SQL Server data.
  • Crashed when closing window in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.4 (Aug 3, 2018)

  • Bug fixes:
  • Unable to map fields in Import Wizard.
  • New Query shortcut and menu item did not work.
  • Crashed when clicking New Query button in some cases.
  • Crashed when typing in Query Editor in some cases.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.1.3 (Jul 27, 2018)

  • Brand new Filter Wizard
  • UI and UX Improvement
  • MongoDB is added in Navicat Premium
  • Navicat for MongoDB is released

New in Navicat for SQL Server 12.0.28 (Jul 13, 2018)

  • Bug fixes:
  • Unable to rename table with double-click in some cases.
  • Sorting Rows column on the Objects tab did not work properly.
  • Command-W shortcut did not close the active window in some cases.
  • Some menu items were missing in Table Designer.
  • Export Wizard did not add a leading zero to pad days and months to two digits.

New in Navicat for SQL Server 12.0.27 (Jun 8, 2018)

  • Improvements:
  • Ability to copy comparison results of Model.
  • Added thousand separators to the row count on the table objects list.
  • Bug Fixes:
  • Crashed when opening Navicat if invalid characters were used for the paths in Preferences.
  • Unable to execute Navicat commands using Automator.

New in Navicat for SQL Server 12.0.26 (May 10, 2018)

  • Improvements:
  • Supported coloring the Objects tab when a colored connection is selected.
  • Improved table mapping in Import Wizard.
  • Improved keyboard navigation with tab key in Import Wizard.
  • Bug Fixes:
  • Left single quotation mark was wrong style when inputting in Form View.
  • Extra "(" was added to INSERT statements when deploying scripts in Data Synchronization.
  • Objects list loading was slow in some cases.
  • Zero decimal place digits were not displayed in Table Viewer.

New in Navicat for SQL Server 12.0.25 (Apr 24, 2018)

  • Bug Fixes:
  • Crashed when starting Navicat.
  • Unable to edit query results when tables had alias.
  • Exported files were not attached to the notification email.
  • Procedure Parameters was missing when synchronizing structure.
  • Unable to filter connections in the Navigation Pane.
  • Profile icons did not have indicator after adding attachments in Batch Job.

New in Navicat for SQL Server 12.0.24 (Mar 29, 2018)

  • Bug Fixes:
  • Unable to copy error messages in Query.
  • Database name was added to the query when using Query Builder.
  • Unable to edit data in Query result set in some cases.
  • Adjusting the height of split screen in Table Designer was not allowed.
  • Crashed when selecting or editing Procedure SQL in Query Editor.
  • Incorrect SQL was generated when changing Primary Key name in Table Designer.
  • Query column width reset after restarting Navicat.
  • Memory leak issue.
  • "Fields" and "Referenced Fields" values were vanished after saving and moving cursor to another Foreign Key.
  • Field properties were not shown when adding a field in Table Designer.
  • Incorrect field name were shown when moving a field in Table Designer.
  • UI issue in Full Screen mode.
  • Exported Excel files were corrupted in some cases.

New in Navicat for SQL Server 12.0.23 (Feb 25, 2018)

  • Bug fixes:
  • Unable to open Console if a non-tabbed window was opened in font.
  • Incorrect syntax error occurred when transferring SQL Server tables.
  • Navicat hanged when refreshing table grid after changing field names.
  • Navicat process was unable to terminate.

New in Navicat for SQL Server 12.0.22 (Jan 22, 2018)

  • Bug Fixes:
  • Error occurred when synchronizing structure in some cases.
  • Exported Excel files were corrupted in some cases.

New in Navicat for SQL Server 12.0.21 (Jan 15, 2018)

  • Bug Fixes:
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 12.0.20 (Jan 11, 2018)

  • Bug Fixes:
  • Unable to open a table twice.
  • Running multi-statement SQLs with delimiters issue.
  • Crashed when adding default value in Table Designer.
  • Crashed when clicking the Server Privileges tab in User Designer.
  • Find feature in Table Viewer was not function correctly.
  • Target object name was garbled when copying object named with non-ascii characters.
  • Crashed when executing SQL to insert emoji to table.
  • Crashed when performing Data Transfer in some cases.
  • Navicat hanged when executing scripts in Data Synchronization.
  • Unable to hide the Information pane permanently in Query.
  • Preferences settings reset when Navicat started.

New in Navicat for SQL Server 12.0.19 (Dec 1, 2017)

  • Bug Fixes:
  • Result tab was focused when explaining query.
  • Query Plan result column was too narrow in Query.
  • "t" character was appended to the end of the row when copying data to text / Excel file.
  • Unable to map fields in Import Wizard.
  • Dump SQL File process was slow.
  • Create new table wrongly when importing to existing table in some cases.
  • Use old user to connect after changing new user name in Connection window.
  • Unable to import decimal values when data has thousand separator.
  • Crashed when searching on different pages in Table Viewer.

New in Navicat for SQL Server 12.0.18 (Nov 13, 2017)

  • Bug Fixes:
  • The database/schema combo-box did not work in Query.
  • Manual refresh did not work in Server Monitor when auto-refresh was enabled.

New in Navicat for SQL Server 12.0.16 (Oct 17, 2017)

  • Bug Fixes:
  • Unable to commit the same query twice.
  • Unable to create the second filter by using context menu.
  • Unable to reload or reopen tables after connection was timeout.
  • Navicat hanged when opening large BLOB data in Hex Editor.

New in Navicat for SQL Server 12.0.15 (Oct 12, 2017)

  • Bug Fixes:
  • Save dialog prompted even no changes made in Table Designer.
  • Unable to paste Chinese in SQL Server Table Viewer.
  • Query Builder loading was slow.
  • Unable to execute query in some cases.
  • Unable to export views on High Sierra.

New in Navicat for SQL Server 12.0.14 (Sep 26, 2017)

  • Bug Fixes:
  • Table Designer UI improvements.
  • Font settings in Preferences reset to default after restarting Navicat.
  • SQL Formatting was missing in the Triggers tab of Table Designer.
  • Unable to delete fields in Table Designer.
  • View Builder button was missing in View Designer.
  • SSH connection hangs issue.
  • Objects list loading was slow.
  • Automation did not work when the profile name contained spaces.
  • Syntax error occurred when filtering with ' character in Table Viewer.
  • Navicat hanged when using normal OS user account.
  • Duplicate Entry error occurred when importing with Append/Update mode.
  • Sync Username to Navicat Cloud option was missing in Connection form.
  • Navicat hanged when connection was cut off.

New in Navicat for SQL Server 12.0.13 (Sep 11, 2017)

  • Bug Fixes:
  • Auto increment field was ignored when importing
  • System items were shown in the Import from Database window.
  • Navicat hanged when running a query export profile in some cases.
  • Crashed when viewing or editing Functions.
  • Code completion displayed unrelated items.

New in Navicat for SQL Server 12.0.12 (Aug 25, 2017)

  • Bug Fixes:
  • Replace All did not work in Table Viewer.
  • Wrong row was inserted to when selecting foreign key value in Table Viewer.
  • Memory error occurred when transferring tables.
  • Suggested wrong table column in code completion list.
  • Context menu UI issue in some cases.
  • Tables displayed as NEW in Import Wizard even it is already existed.
  • Slow issue occurred when using code completion.
  • Server name was missing in the window title bar of Console.
  • Unable to add tables/views to Query Builder.

New in Navicat for SQL Server 12.0.11 (Aug 25, 2017)

  • Bug Fixes:
  • Crashed when executing query in some cases.
  • Failed to sort by Modified Time, Created Time or Data Length in Detail view.
  • Launching Import Wizard was slow.
  • The month and day values were transposed when importing Date fields.
  • Copy/Paste context menu was missing in Table Viewer.
  • Crashed when creating new query without selecting a connection in Navigation pane.
  • Unable to stop multiple processes in Server Monitor.
  • Number of running processes was missing in Server Monitor.
  • Table mapping was not in alphabetic order in Data Synchronization.
  • Crashed when adding records in Table Viewer.
  • Exported file name did not add timestamp when using Automation.
  • Wrong SQL was generated for function in Structure Synchronization.
  • In-App Purchases did not stay activated after restarted the app.

New in Navicat for SQL Server 12.0.10 (Jul 26, 2017)

  • Crashed when exporting query result in some cases.
  • Unable to show time values in Timestamp fields in Table Viewer.
  • Error occurred when executing SQL Server procedure in some cases.
  • Table list was not sorted in Export Wizard.
  • Progress bar did not update when importing.

New in Navicat for SQL Server 12.0.9 (Jul 15, 2017)

  • Bug Fixes:
  • Unable to copy SQL in the bottom navigation bar of Table Viewer.
  • Crashed when pasting SQL in Query Editor.
  • End Process item in the context menu was disabled in Server Monitor.
  • Incorrect field names were shown in code completion suggestion list.

New in Navicat for SQL Server 12.0.7 (Jul 4, 2017)

  • Bug Fixes:
  • Query Table shortcut was missing in Table Viewer.
  • Foreign Key's reference database was not changed after transferring to other database.
  • Crashed when launching the application.
  • Unable to set range in Schedule Setup.
  • SSH password was not imported when upgrading to Navicat 12.
  • Memory leak issue in SQL Editor.
  • Current active server/database was not selected when using CMD-Y shortcut to open New Query window.
  • Syntax error occurred in Data Transfer.
  • Sorting by modified/create date did not work for details view in main window.
  • Unable to copy and paste data in Table Viewer.

New in Navicat for SQL Server 12.0.6 (Jun 27, 2017)

  • Bug Fixes:
  • Shift-Option-Arrow did not work for selecting a word in SQL Editor.
  • Command-R did not refresh the list when database was selected.
  • Unable to resize window in some cases.
  • Unable to type some characters in editor when using international keyboard.
  • Unable to sort the object list in the main window.
  • Unable to log in Oracle server using lower case username.
  • Exporting data with commas to CSV file issue.

New in Navicat for SQL Server 12.0.5 (Jun 16, 2017)

  • Bug Fixes:
  • Crashed when exporting large query results.
  • Connection name was missing on the tab of Table Viewer.
  • Crashed when exporting query results to CSV file.
  • Query prompted for inputting the same parameter for every occurrence.
  • Unable to accept Terms and Conditions when first login Navicat Cloud.

New in Navicat for SQL Server 11.2.18 (May 5, 2017)

  • Minor bug fixes and improvements.

New in Navicat for SQL Server 11.2.17 (Mar 1, 2017)

  • Bug fixes:
  • Failed to move procedures to a virtual group.
  • Minor bug fixes and improvements.

New in Navicat for SQL Server 11.2.16 (Dec 19, 2016)

  • Bug Fixes:
  • Unable to show errors when running query in some cases.
  • Failed to import JSON files in some cases.
  • Query Editor window has disappeared when it lost focus.
  • Some options were wrongly displayed in Essentials Edition.
  • Settings Location was wrongly copied when duplicating connection.

New in Navicat for SQL Server 11.2.15 (Oct 24, 2016)

  • Bug Fixes:
  • The default date time format and delimiter of Export Wizard did not follow Import Wizard.

New in Navicat for SQL Server 11.2.14 (Aug 31, 2016)

  • Improvements:
  • Added some common keyboard shortcuts.
  • Bug Fixes:
  • Failed to transfer tables when enabled "Convert object name" in Data Transfer.
  • Crashed when opening Query view in some cases.
  • Crashed when running backup tasks in Batch Job.

New in Navicat for SQL Server 11.2.13 (Aug 8, 2016)

  • Bug Fixes:
  • Crashed after exporting in some cases.
  • Crashed when importing files with long field name.
  • Column titles was unable to display properly in Form view when using large font size.
  • Crashed when deleting tables with relations in Diagram view.

New in Navicat for SQL Server 11.2.12 (Jul 5, 2016)

  • Improvements:
  • Support smart quotes in Query Builder.
  • Bug Fixes:
  • "DATETIME" was not displayed as SQL Server keyword in Query Editor.
  • Progress bar did not update in Data Transfer.
  • Unable to expand connection tree in some case if the corresponding tab was not selected.
  • Crashed while working with a profile in a virtual group.
  • Unable to perform data synchronization using command line.
  • Crashed when inserting record with RAW mode in Table Viewer.
  • Failed to move multiple objects into a virtual group by right-click menu in Navicat Cloud connections.

New in Navicat for SQL Server 11.2.9 (Mar 9, 2016)

  • Bug Fixes:
  • Functions were removed after editing the query in Query Builder.
  • Failed to save the SQL Server "Identify" setting in Model Table Designer.
  • Unable to remember the file path if the path contains space in Export Wizard.
  • Model History pane showed many changing color histories in some cases.

New in Navicat for SQL Server 11.2.8 (Jan 28, 2016)

  • Bug fixes:
  • Background color of keyword "SUM" did not change with non-white background in Query Editor.
  • Auto-completion did not work for 1 char alias in Query Editor.
  • Extra database name was added when drag and drop a table to Query Builder.
  • Crashed when creating backup in Cloud connections.
  • Crashed when double-clicking the "Find in Database" result in some cases.
  • Queries with "JOIN" was not parsed correctly in some case in Query Editor.
  • Navicat for SQL Server crashed when opening the second database/table.

New in Navicat for SQL Server 11.2.7 (Jan 14, 2016)

  • Bug fixes:
  • Wrongly added extra " char in the exported data when the data contained " char.
  • Unable to open the Find result in "Find in Database".
  • Unable to change the field order by dragging in the SELECT tab of View Builder.
  • "Show Result" setting of Query was not saved immediately.
  • New schema created from Query cannot show after refreshed the SQL Server connection.
  • Unable to disable the folding setting of Query Editor in Preferences.
  • Crashed when double-click to select the query and run selected.
  • Drop stored proc/function statements were missing for SQL Server in Data Transfer.
  • Crashed when loading server preferences from preference.plist file on launching Navicat.
  • Unable to open the saved import profile.
  • Unable to show [] with black background in Query Editor.
  • Shortcuts CTRL-A, CTRL-E were missing in Query Editor.

New in Navicat for SQL Server 11.2.6 (Dec 28, 2015)

  • Bug Fixes:
  • Adding multiple relations issue in Model's Table Designer.
  • Unable to uncheck the "Limit records per page" box in Table Viewer.
  • Crashed when pasting SQL to Query Editor.
  • Error occurred when saving views after applying Beautify SQL.

New in Navicat for SQL Server 11.2.5 (Dec 23, 2015)

  • Bug Fixes:
  • Crashed when opening SQL Server Role Designer.
  • Unable to save the "Show Object List" option in Query.
  • There was no syntax highlight in the SQL Preview tab.
  • Unable to show the cursor in Query Editor with black background.
  • Failed to drag and drop connection in some cases.
  • Smart quote issue in Query Editor.
  • Font issue in Query Editor.
  • Find feature issue in Query Editor.
  • Unable to copy more than 30 rows in Table/Query Viewer.

New in Navicat for SQL Server 11.2.2 (Dec 10, 2015)

  • MAJOR NEW FEATURES:
  • Navicat Cloud Collaboration:
  • Create/Modify/Delete projects.
  • Add members to project for sharing connection settings, queries and models.
  • View Project Activity Log.
  • Data Modeling Tool:
  • Support Model Conversion.
  • Support Views.
  • Enhanced Table Designer.
  • Others:
  • Enhanced Filter Wizard.
  • Enhanced Query Designer.

New in Navicat for SQL Server 11.1.16 (Nov 3, 2015)

  • Bug Fixes:
  • Crashed when running Data Transfer more than once on OS X 10.11.
  • Crashed when running stored procedures on OS X 10.11.
  • Crash when running SQL multi times in Console.
  • Unable to login SQL Server with password contains ";".

New in Navicat for SQL Server 11.1.15 (Sep 16, 2015)

  • Showed wrong database in Connection Tree.
  • Execute SQL file did not output errors in some cases.
  • Lost local connections after Navicat crashed during synchronizing to Navicat Cloud.
  • App Store version: In-App Purchase did not work in Mac OS X 10.11.

New in Navicat for SQL Server 11.1.14 (Aug 4, 2015)

  • Improvements:
  • Supported format strings in Schedule email body.
  • Bug Fixes:
  • Unable to send notification email in Schedule.
  • Wrongly updated the SQL Server table identity columns in Import Wizard.
  • Created a new connection when previewing a view.
  • Syntax error occurred when updating SQL Server tables in Table Viewer.
  • Crashed when dumping SQL Server tables to a SQL file.
  • Lost connections in some cases.

New in Navicat for SQL Server 11.1.13 (May 21, 2015)

  • Bug Fixes:
  • Unable to show error messages when saving SQL Server procedures.
  • Crashed when importing connections.
  • SQL Server connection would hang when the connection was disconnected.
  • Crashed when reversing database to model.

New in Navicat for SQL Server 11.1.12 (Apr 27, 2015)

  • Bug Fixes:
  • Object List tab did not change when selecting nodes from connection tree.
  • Unable to synchronize or export model to SQL Azure.
  • Unable to send email when running batch jobs using Command Line.
  • Failed to save the order of connections in Navicat Cloud.

New in Navicat for SQL Server 11.1.11 (Mar 27, 2015)

  • Bug Fixes:
  • Unable to edit BLOB field's text data on TEXT editor.
  • Error occurred when opening SQL Server 2005 and SQL Azure connections.
  • Unable to use CMD-Y New Query shortcut after selecting Tables, Views, etc nodes on Connection Tree.
  • Failed to run schedule for connections in Navicat Cloud.
  • Cursor did not focus on Query Editor when opening a query.

New in Navicat for SQL Server 11.1.10 (Mar 13, 2015)

  • Bug Fixes:
  • Unable to insert/update/delete money type in Table Viewer and Data Transfer for SQL Server 2000.
  • Fixed import DBF file with empty datetime value issue.
  • Crashed when typing "create function test (in_" in Query Editor.
  • Error occurred when opening SQL Server 2008 R2 schemas.

New in Navicat for SQL Server 11.1.9 (Feb 6, 2015)

  • Improvements:
  • Added the ability to copy column name with data and copy records as Insert/Update statements in Query/View Result.
  • Bug Fixes:
  • Fixed the SQL Azure connection hang issue.
  • Fixed the time interval setting issue in Schedule.
  • Fixed the multi headers issue when exporting multi SELECT query to XML file.
  • Fixed the warning issue when renaming query.

New in Navicat for SQL Server 11.1.8 (Feb 6, 2015)

  • Improvements:
  • Added the ability to copy column name with data in Table Viewer.
  • Bug Fixes:
  • Crashed in SSH re-connection.
  • Fixed the smart quotes/dashes issue in Query Builder.
  • Fixed the data type issue when importing xlsx in Import Wizard.
  • Fixed the creation of database/schema issue when no target database/schema name provided in Data Transfer.

New in Navicat for SQL Server 11.1.7 (Dec 17, 2014)

  • Improvements:
  • Show popup message if errors occur during dumping tables/databases/schemas to SQL file.
  • Bug Fixes:
  • Crashed when using "Reverse Database to Model" feature.
  • Crashed when the connection between server and client is disconnected.
  • Unable to scroll on long query.
  • Unable to re-send Navicat Cloud verification email.
  • Result set scrolled to line 2 after executing the query in OS X 10.10 .

New in Navicat for SQL Server 11.1.6 (Dec 2, 2014)

  • Improvements:
  • Support NTLMv2 in Windows Authentication for SQL Server.
  • Supported copy data as INSERT/UPDATE statements in Table Viewer.
  • Bug Fixes:
  • Error occurred when changing the case of the connection name.
  • Crashed when importing database/schema to Model.
  • Crashed when creating Navicat Cloud account.
  • Wrongly applied "Use smart quotes and dashes" setting in Console.

New in Navicat for SQL Server 11.1.5 (Oct 22, 2014)

  • Bug Fixes:
  • Navicat Cloud login checking restriction.
  • The Select/Where/Group By/Having/Order By clasue bar disappeared in Query/View Builder.
  • Connections are moved out from virtual groups after upgrading from version 11.0.
  • Crashed when saving profiles.
  • Select fields panel in Table Designer did not update after the table was saved.
  • INT type values were rounded up when importing XLS files.

New in Navicat for SQL Server 11.1.4 (Sep 25, 2014)

  • Improvements:
  • Customized column width and column order in Table Design are saved.
  • Bug Fixes:
  • Generated wrong query for field name with "." in Filter Wizard.
  • Crashed when removing connection from a virtual group.
  • Unable to save the Word Wrap setting in Table Text Editor.
  • Crashed when creating a new virtual group in fresh installed Navicat.
  • Connection list did not refresh automatically after dragging connections between Navicat Cloud and My Connections.

New in Navicat for SQL Server 11.1.00 (Aug 26, 2014)

  • Support to sync selected conntection settings, queries, model files and virtual group information to Navicat Cloud.

New in Navicat for SQL Server 11.0.20 (Aug 1, 2014)

  • Bug Fixes:
  • Crashed when adding foreign key under Table Designer in Data Modeling Tool.
  • Paging buttons did not work after applied sorting in Table Viewer.

New in Navicat for SQL Server 11.0.19 (Jul 9, 2014)

  • Improvements:
  • Support length of SSH password/private key passphrase increased from 99 to 255.
  • Support to save name with "/" for Connection Save Path, Query, Import/Export/Backup profile, Backup, Schedule, Model, Data Transfer/Synchronization profile.
  • Bug Fixes:
  • Crashed after opening Navicat for long time.
  • Crashed when prompted to input password for SSH connection in Data Transfer, Data/Structure Synchronization and Server Monitor.
  • Reduced the time needed to wait for connection timeout when disconnected to server.
  • Non-ASCII characters not able to show in Hex Editor under Table Viewer.
  • Some operations in main window did not popup error when error occurred.
  • When generated update query, identity column did not skip in Import Wizard.
  • Website version: "SSH:Unknown Error!" error occured if doing any further action for SSH connection.
  • Table Viewer would hang when refreshing after idled for around 10 mins.

New in Navicat for SQL Server 11.0.18 (May 26, 2014)

  • Bug Fixes:
  • Crashed when copied and pasted a new row and committed the changes by clicking the "tick" button in Table Viewer.
  • Export Wizard window did not show up for exporting query results.
  • The title in Console window did not update into newly changed connection name.
  • When typing single/double quote in Console, the quote would be changed into other char that did not recognized by server.

New in Navicat for SQL Server 11.0.17 (May 12, 2014)

  • Improvements:
  • Allow drag to reorder field as default in Table Designer.
  • Bug Fixes:
  • Connection password was unable to be saved.
  • The state of running in full screen was unable to be saved, so that Navicat only started up in window mode.
  • Error message occured while viewing table structure to show the file path.
  • Disabled the vertical elastic effect to avoid wrong colour drawing for row index < 0 in Table Viewer.
  • The result dataset did not show warning messages for unknown type query in Query Viewer.
  • When previewed and enabled save queries to file, queries were not correctly written to the file in Data Synchronization.
  • The file and file size position in Model info view were wrong.
  • Crashed when right-clicked on an open area and seleted "Restore Backup".
  • The bookmark setting of saved path was incorrect in Backup schedule.

New in Navicat for SQL Server 11.0.16 (Mar 7, 2014)

  • Improvements:
  • Now only column titles of the first result included when exporting multi dataset to the same file using Export Wizard.
  • Bug Fixes:
  • Tab was unable to be dragged and reordered in full screen mode.
  • Crashed when using Find function in Table Viewer.
  • Copy and Paste did not work on tables with auto-incremented columns while saving a record by clicking "tick" icon in the Table Viewer.
  • Crashed after changed the "Use advanced connections" and press "ok" button in Table Viewer.
  • Crashed when selecting a suggested word that required quoting in Scintilla auto completion.
  • Crashed while scrolling table in Query Builder and exited Navicat.
  • int with "." as Thousand Separator did not import correctly in Import Wizard.
  • The datetime format showed in the export profile did not match the format used in the original table.
  • Date and time were exported incorrectly while using a EDT time zone.
  • Message Log was unable to save correctly for the Preview function in Data Synchronization.
  • When changing a relation's referencing schema, the relation remained in the table but the relation line in diagram was removed under Table Designer in Data Modeling Tool.
  • Crashed when double-clicking the connection tree under Synchronize to Database in Data Modeling Tool.
  • Schedele helper did not work although jobs still run in old version.
  • Website version: Typed in the export queries filepath directly would cause file creation error in Data Synchronization.
  • App Store Essentials version: Crashed when purchasing Code Completion feature without SQL Builder in View Designer.

New in Navicat for SQL Server 11.0.15 (Jan 7, 2014)

  • Improvements:
  • Improved connection tree behavior in main window.
  • Bug Fixes:
  • Database name was changed if failed to open it.
  • Popup menu was shown far away when clicking on Diagram View or Model Design in retina display.
  • Crashed when deleting active connection.
  • Crashed when typing single digit in hour/minute/second field and press OK in table viewer.
  • Unable to show error when getting database on open connection.
  • Crashed when closing the Export Wizard for exporting selected row in Table Viewer.
  • Limited the number of rows in the exported file when exporting SQL Server table.

New in Navicat for SQL Server 11.0.14 (Dec 20, 2013)

  • Improvements:
  • Disabled zooming by magic mouse in Query Editor.
  • Bug Fixes:
  • Failed to open table on Mac OS X 10.6.
  • Unable to add view's profile to the virtual group.
  • Unable to duplicate profiles.

New in Navicat for SQL Server 11.0.13 (Dec 18, 2013)

  • Improvements:
  • Added shortcut keys for "Save" and "Save As" in Data Synchronization.
  • Enhanced Data Synchronization.
  • Allow to select tag to identify data when exporting table to JSON format.
  • Saved field selection window size in Table Designer.
  • Bug Fixes:
  • Crashed when running Explain on Mac OS X 10.6.
  • Unable to close Server Monitor's popup dialog in Mac OS X 10.9.
  • Wrongly quoted the value in Export output file.
  • Failed to save connection order in main window.
  • Editor failed to show when first open the Table/View Viewer.
  • Unable to save the resultset's column width after re-run the query.
  • App Store version: Failed to list tables after connected.
  • Website version: Unable to send attachments in Schedule.

New in Navicat for SQL Server 11.0.12 (Nov 8, 2013)

  • Bug Fixes:
  • Command-F unable to close the search function in main window.
  • Export Wizard wrongly to get Time Delimiter as Decimal Delimiter.
  • Crashed while printing diagram in Data Modeling Tool.
  • Data Synchronization dialog window stayed opened.

New in Navicat for SQL Server 11.0.11 (Nov 6, 2013)

  • Improvements:
  • Compatible with Mac OS X 10.9 Mavericks.
  • Bug Fixes:
  • Crashed on tabbed window.
  • Failed to import JSON file.
  • App Store version: Error on export path during Export Wizard in Mac OS X 10.9.
  • Wrongly displayed for the time fraction part of datetime type in SQL Server Table Viewer.
  • Crashed when paring "DECLARE myCursor CURSOR FOR" in Query Viewer.
  • Fields did not compare in Structure Synchronization.
  • Crashed when opened a linked server and removed it in main window.

New in Navicat for SQL Server 11.0.10 (Sep 30, 2013)

  • Improvements:
  • Support larger row limit for xlsx version, 1048576 rows in Export Wizard.
  • Bug Fixes:
  • No popup error showed in Table Viewer.
  • Failed to find the next match in Find Next action after selecting a cell in Table Viewer.
  • Crash occurred in Query Editor.

New in Navicat for SQL Server 11.0.9 (Sep 11, 2013)

  • Improvements:
  • New tab window control.
  • Bug Fixes:
  • Crash occurred while deleting tables with foreign keys on ER diagram.
  • Options missing in Export profile.
  • Fixed support "," in schedule time setup.
  • The text color in Text Editor did not follow the "Common" colour in Preferences.
  • After selected a cell in Table Viewer, cmd + F not able to focus on the search field if search bar was already shown.
  • Failed to update setting controls immediately after guessing the field type from newly added field name in Table Designer.
  • Website version: Failed to show Navicat 10 Import file entries in Navicat 11.

New in Navicat for SQL Server 11.0.8 (Aug 7, 2013)

  • Bug Fixes:
  • Error not log during fetching rows in Data Transfer.

New in Navicat for SQL Server 11.0.7 (Jul 29, 2013)

  • This version includes a number of bug fixes and some improvements

New in Navicat for SQL Server 11.0.5 (Jul 12, 2013)

  • Improvements:
  • Updated libxl to 3.5.3.
  • Adjusted caret color same in Scintilla.
  • Support sorting items by name inside a virtual group.
  • Bug Fixes:
  • SSH connection random crashed.
  • Fixed number of virtual grouping issues.
  • Crashed in Query Viewer.
  • Select/Paste function did not work on the newly added rows in Table Viewer/Query Viewer.
  • Text/Blob Editor in Table Viewer was reallocated the data in selected cell after refreshed.
  • Values did not always change in Table Viewer if modified in Query Viewer.
  • Query not found error occured in Query Favorites feature.
  • When generating create table queries, all numeric fields came with IDENTITY in Data Modeling Tool.
  • Export failed in query result.
  • Crashed in Structure Synchronization.
  • App Store version: Error occured when adding images in Data Modeling Tool.

New in Navicat for SQL Server 11.0.4 (Jun 11, 2013)

  • Bug Fixes:
  • Bug fixed in other Navicat family.

New in Navicat for SQL Server 11.0.3 (Jun 7, 2013)

  • Bug Fixes:
  • SSH Public key settings was unable to be saved in duplicate connection.
  • Crashed occurred when deleting objects from ER Diagram view.
  • Crashed occurred when applying filter during the data loading process.
  • Crashed occurred in Query Editor when running an empty query.
  • Progress indicator in Query viewer result kept spinning after rows inserted.
  • Infinite looping in Export Wizard while exporting selected rows.
  • Crashed occurred in Server Monitor while getting the process list.
  • Data model files not opened while they were not saved in default folder.

New in Navicat for SQL Server 11.0.2 (May 27, 2013)

  • Bug Fixes:
  • SSH connection would keep asking for public key passphrase even the save passphrase/password was checked.
  • Crashed in ER Diagram when loading and showing diagrams simultaneously.
  • When exported dataset from and unsaved query, the export file name is now marked as "Untitled".
  • Duplicated queries were run when exporting result set in Query Viewer.
  • Crashed occured when closing the Export Wizard after exported the result set in Query Viewer.

New in Navicat for SQL Server 11.0.1 (May 22, 2013)

  • Improvements:
  • Improved tab behavior in Navicat main.
  • Reduced memory usage when opening Table Viewer.
  • Support to print and export PDF files with paper size that not available for the printer in Data Modeling Tool.
  • Bug Fixes:
  • Crashed in Table Designer with HTTP connection established.
  • Sorting function did not work properly.
  • Find Next/Previous in Find and Replace function went wrong after drag and drop column.
  • The result range not highlighted in Find function.
  • Blank page appeared in Table Viewer while scrollling down to the end of the page and switching to the last page, when the table contained more than 1000 rows.
  • Failed to insert record and receive update error, or crashed when clicked on a cell in Table Viewer while uuid type existed in the table.
  • Links between join tables would lost in Query/View Builder.
  • Query was unable to parse the delimiter properly.
  • Duplicated queries were run when exporting result set in Query Viewer.

New in Navicat for SQL Server 11.0.0 (Apr 30, 2013)

  • 64-Bit version
  • Brand New Design
  • Multi-Changes at Once
  • Connection enhancement
  • Stay up to date
  • Smart Find and Replace
  • Oracle Data Pump
  • SQL Server Backup
  • Search objects everywhere
  • Organize your work
  • More Import Formats
  • Enhanced Export Format

New in Navicat for SQL Server 10.1.3 (Feb 7, 2013)

  • Bug Fixes:
  • Connection kept opening even the form was closed.
  • Table names in ER Disgram view could not be renamed.
  • Font size in SQL Editors were too large in retina display.
  • Crashed while opening DBF import profile with Field Delimiter = "" in Import Wizard.
  • "Disable foreign key checks" option in Data Synchronization was ignored in Schedule.

New in Navicat for SQL Server 10.1.2 (Dec 3, 2012)

  • Minor bug fixes and improvements

New in Navicat for SQL Server 10.1.0 (Jun 15, 2012)

  • Build model with multiple schemas.
  • New wizard "Import from Database".
  • New wizard "Synchronize to Database".
  • Align/Distribute diagram objects.

New in Navicat for SQL Server 10.0.6 (Jan 24, 2012)

  • Fixed the bug of failure to print PDF in Model Design
  • Fixed the bug of DISTINCT clause disappeared in Query Editor after using Query Builder
  • Fixed the slow response when opening Execute SQL File window.
  • Fixed a crash issue when using Beautify SQL
  • Fixed the crash issue when quitting process in Server Monitor

New in Navicat for SQL Server 10.0.3 (Nov 3, 2011)

  • Data Modeling
  • ER Diagram View
  • Connection Coloring
  • Database Wide Search
  • Many other improvements

New in Navicat for SQL Server 9.1.4 (Jan 21, 2011)

  • New Feature:
  • Support of SQL Azure.
  • Improvements:
  • Elapsed time is now shown for each query in Query Viewer.
  • The first level tag in XML file is now recognized as the record indicator during Import Wizard.
  • Bug Fixes:
  • Queries list in main window was not refreshed after transferring queries.
  • Crashed when refreshing tables after Record per Page setting had changed in Table Viewer.
  • After deleting a record, the next record is now selected instead of the final record in Table Viewer.
  • Some value could not be displayed when switching from Grid View to Form View in Table Viewer.
  • Updating records improperly used extra fields as update criteria.
  • SQL results were unable to shown when some kinds of SQL statements were run in Query Viewer.
  • Mode selections were ignored under "Advanced Settings" tab in Data Synchronization.