Navicat for MySQL Release Note | Navicat.
Looking for:
Navicat premium 12.1.22 key free.JohnHubcr/navicat-keygen |
- Navicat Premium Win / macOS / Linux
Your email address will not be published. Notify me of follow-up comments by email. Notify me of new posts by email. Furthermore, with this package, you can execute different SQL queries without concern about syntax. It allows you to convert database content from one piece of information to others within a few seconds.
This software allows you to synchronize all of your data a lot faster and conveniently. Sorting columns with numeric values was not working properly in Server Monitor. When scheduling an export job with sending mail attachment, the attachment failed when the exported file name contained datetime. When the column set to datetime field having second decimal in timestamp, zeros would be exported in Export Wizard. Table rows could not shown correctly when the number of rows were too large.
Bug Fixes: Scintilla font size doubled in Apple retina display. Function returned incorrect table type. Popup window did not show while clicking on Delete item button with no rows being selected in Table Designer.
Improvements: Increased the limit of number of joins allowed in Query Builder. Improved the working area on Query Builder. Bug Fixes: Fixed a crash issue when re-running a query in Query Viewer. Fixed the failure of sending email in Schedule.
Fixed the bug of disabled definition box in function. Fixed the bug on running functions in function window. Fixed a crash issue when using Beautify SQL. Fixed the crash issue when quitting process in Server Monitor. Improvements: Update the SQLite version to 3. Bug Fixes: Fixed the crash issue when clicking on an object inside a virtual group, having "Click to refresh object list" option was enabled in Preferences.
Fixed the bug in Query Builder where functions were not displayed properly. Improvements: SQL scripts copy from Structure and Model Synchronization comparison results are now formatted properly.
Fixed the problem of importing null values into newly created fields in Import Wizard. Bug Fixes: Fixed the refresh problem after reordered the fields in ER diagram view. Fixed the reload time issue after saving table. Fixed the bug occurred when selecting weekday in Schedule setup panel. New Feature: Support connection coloring. Support of dumping SQL file with selected tables. Bug Fixes: Fixed the Structure Synchronization index and default problem.
Fixed the missing Foreign Keys when reversing tables to model. Fixed the issue of selecting wrong database type when reversing tables to model. Bug Fixes: Fixed the problem of wrong encoding used when loading queries. Fixed the issue of not saving a Data Synchronization advanced setting as profile.
Fixed the crash problem when started with the main toolbar hidden. Fixed the syntax error when transferring index in PostgreSQL. Bug Fixes: Fixed the occasionally hang problem in Query Builder. Fixed the problem of failing to run Data Synchronization batch job. Fixed the problem of improperly quoted index expressions in Backup and Table Designer.
Fixed the problem of occasionally displaying blank cell in Table Viewer. Fixed the problem of continuously adding row when pressing Down Arrow button in Table Viewer. Unable to open SQL files with some encodings. Bug Fixes: Failed to drop existing objects before creating the objects in connections during the restore process. Improvements: More accurately to determine the system objects.
Elapsed time is now shown for each query in Query Viewer. 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. Mode selections were ignored under "Advanced Settings" tab in Data Synchronization. Bug Fixes: Crashed when trying to add row in Form Viewer. Crashed if failed to open view in View Designer. Improvements: Shortcut keys are now added back in Query Viewer. Text Qualifier can now be manually set during Export Wizard.
Bug Fixes: Rename databases did not work properly. Crashed if the returned error messages contain specific character in Query Viewer. Long column names were truncated in Query Builder. Incorrect time values were sometimes imported during Import Wizard. Improvements: "Test Connection" action can now be canceled in Connection Properties.
Text Qualifier can now be freely set to any characters during Import Wizard. Bug Fixes: If a group contained more than two connections, error would occur when trying to delete the group. Null values were inserted on non-edited timestamp field in Table Viewer may cause errors. Updated rows in Query Viewer were reverted back to their previous value after highlighting another rows. Navicat hanged when importing multiple files using Import Wizard.
Error message could not be displayed if "Continue on Error" was not checked in Data Transfer. Memory allocation problem when the manual was opened. In Mac OS X Sequence is now created before creating table during Structure synchronization. Menu bar did not display properly when running in Mac OS X Navicat hanged when switching to some object pages in main window when running in Mac OS X Some buttons and text were not displayed properly in Mac OS X Improvements: Connection name is now shown in the title bar of Console window.
Bug Fixes: The referencing database of foreign keys were not properly transferred to files. If the decimal symbol was not set as period. Failed to prompt for entering HTTP authentication password even password was not saved. Newline characters were imported improperly into PostgreSQL text fields.
Improvements: Show the host information under Connection Information view. Bug Fixes: Memory allocation problem which may cause Navicat to crash when transferring data using Data Transfer. Incorrect values were synchronized during Data Synchronization. Crashed easily when running queries in Query Viewer.
Improvements: If the row is selected, Filter Wizard will now display the words in white color. Query Builder supports to show diagram for some incomplete statement. Improper join lines were displayed when joining multiple tables in Query Builder.
Crashed when parsing some improper SQL statements. Improvements: Added a section in Query View Result tab so that it can now show the sql and the query time. Query result data can now be exported even if the sql is not saved.
Failed to edit data in Views. Failed to delete data inside the cells in Table Viewer by pressing Delete button. Improvements: Added shortcut keys for bottom bar buttons in Table Viewer. Adjusted the cell editable only when those data is allowed to update in Query Viewer. Bug Fixes: Dragging images into Image Editor were converted to tiff format. Bug Fixes: Crashed when comparing non-ascii table name during Structure Synchronization.
Improvements: Maintain Table will now show the full message reported by the server after operation. Bug Fixes: Failed to import xml file with values inside xml attributes during Import Wizard. Failed to backup the server in schedules. Wrong File menu would be shown sometimes in main window. Improvements: Improved the support of bigger data in each cell of Excel file during Export Wizard. It now has no restriction on jointing the data type fields in Query Builder.
Fixed crash problem during Import Wizard. Bug Fixes: Connections were not freed before quitting Navicat. Form View would crash when editing with no row selected. Wrong linkage was shown for field name with capital letters in Query Builder. Improvements: Improved the internal code to avoid some crash that would occur.
Failed to connect to PostgreSQL server on "localhost" but without socket file. Navicat Import Wizard was unable to recognize some xml attributes properly. When modified Index in Table Designer, Some changes could not be recognized. Failed to display the referencing table list when editing existing Foreign Key in Table Designer. Navicat crashed if the network drive could not be found during the Backup process.
Bug Fixes: Data grid was unable to be opened properly when some kind of text were displayed. Stability improvement on tabbed window. Bug Fixes: Indexes could not work if user is not superuser. Import Wizard would be launched if the Data format was not properly set. Now owners of objects are not compared or transferred in Structure Synchronization and Data Transfer. Improved the stability when running a query.
Improved an internal SQL which run slowly in the past. Bug Fixes: Some windows size and position were not saved after closed. Recalling multi-line history commands in Console were not displayed properly. Dump SQL File did not dump the primary key definition. Could not recognize the host by host name. User defined type fields were not showing the type properly in Table Design.
Support choosing server version for SQL to be generated in Data Transfer, support more transfer options. Added connection tree to support batch jobs from different databases. Compatibility and speed improvement in exported excel format.
Notification email in batch job is now delivered in MIME format. Bug Fixes: Navicat could not quit normally in some senarios. View Builder did not display properly. Slow problem when opening Query View.
Field lengths are not synchronized correctly for PostgreSQL server. Bug Fixes: Duplicated tables are sometimes displayed in Query Builder. Crash when changing the default value of bit fields in Table Design. Crash when no profile name are specified in command line backup and export. Code completion not working properly on unicode characters. Backup Support of saving profile, running schedule with specified backup options. Object list sorting now follows Finder's convention. Floating point values are now displayed in the same format as what PostgreSQL returns.
Stability problem in Import Wizard. Problem when importing data from formula in Excel file. Crash when creating the stored procedures. Better handling when SSH connection is lost. Ciient Encoding is now always set to UTF Server password not being saved in the Connection Properties.
Lite version. The button to trigger the Field Selection panel in Table Design sometimes disappear when running in Leopard. An useless sql was executed after running sql in Query View. Enhancements: Tabbed Windows - Support dragging tabs in and out of the tabbed windows. SSH Connection - Support public key authentication.
Other minor improvements and bug-fixes. For the current 7. Major new features: New Import Wizard - support Excel file; Improves performance, usability, and much more. Tabbed Window - perform multiple operations in a single window. Virtual Grouping - provide better categorization for objects. Improved memory managment in Import Wizard. Keyboard shortcut Control-Tab to switch between tabs.
Support dumping and transferring foreign keys. Supports of multiple SQL editors with syntax highlighted feature. Bug-fixes: Unable to launch Navicat after upgrading the system to use GLib Bug-fixes: Crashed when viewing or adding emoji data.
Bug-fixes: The Stop button did not work when processing deletion in the table viewer. Error occurred when editing data in query results. Bug-fixes: Crashed when the query returned a large result set. Not all matching data was highlighted when searching the query results.
Crashed after refreshing the table. Unable to set privileges for PostgreSQL functions. Crashed when importing PostgreSQL database to the model. Hanged when dragging a table from the main window to the model window. Incorrect default field size issue in Table Designer. Unable to show the input text in Table Viewer when using Dark Mode. Missing the primary key warning in Table Viewer.
Bug-fixes: Unable to export the fractional part when the decimal separator was comma. Unable to select privileges in the "Add Privilege" window by using the Space key. Bug-fixes: Crashed when restoring the backup file to another database. Bug-fixes: Crashed when using Charts in some cases.
Bug-fixes: The number of processes was missing in the Server Monitor window. Unable to delete multiple fields in Table Designer. Some buttons were disabled at all times in New Query. Unable to copy and paste multiple rows data to another table. Right-clicking a row header in data grid highlighted the corresponding column. Bug-fixes: Crashed when editing functions.
No server, database and schema were selected when opening query. Bug-fixes: An empty diagram was created when reversing a database to a model. Unable to change font for Editor and Records. Query returned different results for an empty row. Unable to copy the selected text with shortcut in Console. Crashed when importing tables to a model. Unable to add a table to the model using the mouse. Unable to duplicate model files.
Navicat was not responded when performing Structure Synchronization. Set task schedule in Batch Job did not work. Fixed UI font issue in Ubuntu Bug Fixes: Please refer to Navicat Premium release notes for the bug fixes of version Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding. Create, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.
Compile professional high-quality reports in minutes using an interactive design interface and efficient workflow, and set an automation for repeatable deployment processes like report generation, database backup, MapReduce job, and script execution at a specific time or day.
No matter where you are, you can always get the job done. Discover and explore your MongoDB schema with our built-in schema visualization tool. Synchronize your connection settings, models, queries, and virtual groups to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity.
Save my name, email, and website in this browser for the next time I comment. Home Programming Navicat Premium Share 0. Next IntraWeb Ultimate Edition DecSoft App Builder Sep 1 Navicat Premium Windows version Oracle unicode characters in Export handled incorrectly. Data started with single quote issue in exported Excel file.
Aug 25 Navicat Premium Windows version New Features: Support to sync selected connection settings, queries, model files and virtual group information to Navicat Cloud.
For more information, please visit here. Support SQLite 3. Support parameter in Report command line. Support adding shapes in Model. May 21 Navicat Premium Windows version Query profile now support to show in server level. Database properties for SQL Server not able to alter proper compatibility levels. Crashed when loading and parsing a long incorrect syntax SQL in Query. Import Paradox not able to import data properly in Navicat 64bits. ORA invalid character error occured when exporting Oracle query results.
Backup not able to backup MySQL table with foreign key. Feb 25 Navicat Premium Windows version All records are now able to show under the Fixed Width window in step 3 of Import Wizard. Connection was deleted after renamed to capitalized name. Bug Fixes: Lose focus in Table Viewer. Function parser error. Access Violation error occurred when designing MariaDB tables with foreign keys.
Access Violation error occurred when importing invalid connections. ERegistry Exception error occurred when starting Navicat. Oracle reconnection problem. Wrong Date Editor frame size in Table Viewer. Stack Overflow error when running Query. Permissions issue of the Updater. Cursor was missing in Stored Procedure. Failed to create MySQL user with special characters password. Nov 8 Navicat Premium Windows version Improvements: Support of MariaDB 5. Bug Fixes: Missed to mark quotation on keywords in Query Builder.
Process was unable to stop while running query in Essentials version. Failed to include auto increment column setting for floating point data types in MySQL. Failed to get the accurate fraction part of date time data for SQL Server. Failed to scroll horizontally for wide content after applying Filter Wizard in Table Viewer. Fixed some issues on Query and Export features under Oracle level. Aug 7 Navicat Premium Windows version Access violation occured while copying and pasting field in Table Designer.
No respond from Filter Wizard in Table Viewer after execution error of filter query. Failed to replace text with an empty string using the Find and Replace feature. Fixed the scrolling issue in docking window on secondary display. Failed to display unicode user name and organization in Navicat About box. Jul 3 Navicat Premium Windows version Column width not able to be reset after showing the hidden column in Table Viewer. Query message in status bar not updated if no result return after Run.
Fixed issues on cross transfer. May 27 Navicat Premium Windows version Access violation occured while running report in command line. Losing searched position in Memo editor after first searching or clicked into the Memo editor.
Fixed query parser error. Invalid relation cardinality not showed in red color in Data Modeling Tool. May 9 Navicat Premium Windows version Notification email not sent with an unsaved batch job. SQLite query result table not able to update while having zero and padding integer. Apr 30 Navicat Premium Windows version Feb 4 Navicat Premium Windows version The current value of PostgreSQL Sequence object was unable to synchronize properly and returned incorrect nextval value in Structure Synchronization.
Improvements: Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5. Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.
Synchronize to Database function in Data Modeling Tool genarated incorrect comparison result for equivalent source and target foreign keys. When "Run multiple queries in each execution" option is checked for SQL Server, character data was unable to import correctly in Import Wizard.
Sep 19 Navicat Premium Windows version Wrong time unit ms was shown under Messages tab in Query function. Table Designer in Data Modeling Tool was unable to save newly added index and foreign key. Aug 23 Navicat Premium Windows version Jul 27 Navicat Premium Windows version Bug Fixes: Minimized docked window could not restore normally. Jul 19 Navicat Premium Windows version Jul 6 Navicat Premium Windows version Empty string was identified as Null in SQLite.
Build model with multiple schemas. New wizard "Import from Database". New wizard "Synchronize to Database". Search filter. Bug Fixes: Data truncated when exporting pdf file from Report Builder. Navicat got hanged while performing a search in Table Viewer. Incorrect excel file format was exported while having data started with 0 in Export Wizard.
Auto-increment info was missing while preforming cross data transfer. Jan 31 Navicat Premium Windows version Import speed has been improved in Import Wizard. Export speed has been improved in Export Wizard.
Bug Fixes: 'column d. Navicat generated 'Not Implemented' error when running under replacement shell UI. Jan 4 Navicat Premium Windows version Not able to open schema for databases with non-default database collation in SQL Server Oracle long Number could not shown in Table Designer. Crash occurred when closing Synchronize to Database in Modeler during the comparison in progress. Crash occurred while renaming table failed with server error in ER-diagram view. Data Transfer would hang in Navicat Scheduler.
Nov 24 Navicat Premium Windows version Nov 14 Navicat Premium Windows version Fixed-width and row delimiter were unable to retrieve from a profile in Import Wizard. Structure Synchronization produced invalid pointer exception error when comparing SQL Server stored procedures. Non-latin characters with different collation columns in MySQL table were unable to search in "Find in Database" feature. Print report to PDF file would generate a blank file. Oct 17 Navicat Premium Windows version Support table comment up to characters for MySQL 5.
Bug Fixes: Data Modeling Tool was unable to set the reference field of foreign key. Data Modeling Tool was unable to print with landscape page setting. When importing data from an URL, it failed to create a temporary file if the same temporary file was being accessed.
Restore didn't work with the. Connection Information could not display properly in large font size. Foreign Keys is now able to be imported into Model. Spacing issue has been improved in Beautify SQL. Import from paradox file was unable to get signed short integer values.
User Privileges typo was fixed. Sep 12 Navicat Premium Windows version 9. Bug Fixes: The highlighted items from the previous searching results in Table Designer was failed to clear for the next searching. MySQL foreign key was unable to be created in Table Designer when referencing a destination field requiring index. Restored bytea data in PostgreSQL was failed.
Sep 6 Navicat Premium Windows version ER Diagram view. SQL Minifier. Database Wide Search. Added object list in Query Editor. Jun 1 Navicat Premium Windows version 9. Bug Fixes: Wrong table would be copied while running "Duplicate Table" function.
Foreign Key Check box under Table Designer was unable to be toggled using space bar. Searching in Table Viewer would freeze when no record showed on the existing view. Apr 11 Navicat Premium Windows version 9. Bug Fixes: Scroll bar in Trigger Definition editor was missing. Object List frozen. The size of the width in Run Result columns were too large in Stored Procedure form. Connection combo box showed wrongly in Data Synchronization.
SQL Server permission denied on object 'sysproperties'. Import Wizard was unable to import SQL Server string data to varchar, varchar max , text field properly. Feb 21 Navicat Premium Windows version 9. Navicat was unable to list function which returning table of PostgreSQL 9. Table with Oracle object array was unable to be opened in Table Viewer. Imported text-based file with UTF-8 encoded data to blob field incorrectly.
Failed to run multiple Data Synchronization at the same time. Table with identity fields was not working correctly in Data Synchronization. Jan 17 Navicat Premium Windows version 9.
Improvements: Improved sorting order in Connection Tree and Object list. MySQL Table Designer was unable to insert a field as first since Navicat modifies the second field to reference the not yet inserted field. Jan 12 Navicat Premium Windows version 9. Improvements: Improved the compatibility of third party plugin eg. Ultramon, Hardcopy etc. SQL Server export view profile did not show in list. Multiple files with files delimited as ' ' were unable to be recognized during Import Wizard. Dec 28 Navicat Premium Windows version 9.
DBF character field length would be set to if table field length is 0 while exporting to DBF file. Tree node was unable to be highlighted when Connection Coloring feature was applied under Windows XP.
Dec 14 Navicat Premium Windows version 9. Bug Fixes: Any SQLite unique constraints set at a column level were lost if a previously created table was opened. When adding fields in a table with SQLite foreign key constraint in Table Designer, the reference table field would be renamed. Code Completion did not work properly with field name if tables were from different database. Exported data string to Excel file did not work properly, e. Structure Synchronization showed wrong compare option caption after changing connection to different kinds of database.
Fixed no permission returned when getting row count of SQL Server table. Nov 30 Navicat Premium Windows version 9. Nov 25 Navicat Premium Windows version 9. New Privilege Manager. Data Synchronization performance improved with new engine. Connection Coloring. Oct 4 Navicat Premium Windows version 9. SQLite Foreign Key did not work properly.
Result form showed in Query Editor would be closed after a new query was run. Sep 15 Navicat Premium Windows version 9. SQLite indexes were unable to be removed in Table Designer. In Structure Synchronization, when the queries generated in the "Queries for Modification" list were too long e. Error occurred for Oracle and PostgreSQL server when primary key constraint name in source table conflicted with the unique index which was created as the same name as the primary key in Structure Synchronization.
Field names for some tables with special names were unable to be listed in Report Builder. Aug 30 Navicat Premium Windows version 9. Improvements: Horizontal scrollbar is now reset to the left position after applying Beautify SQL feature. Aug 2 Navicat Premium Windows version 9. When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
Failed to transfer database objects to different server type when transfering to sql file in Data Transfer. When exporting numeric data to excel file, it would be exported as string type. Jul 15 Navicat Premium Windows version 9. Fixed "mysql. Foreign Key link position in Visual Builder were not accurate enough. Server Monitor would crash if being opened for a while. Jun 23 Navicat Premium Windows version 9. Beautify SQL would cause error if extra spaces existed in aggregate function.
Fixed error when importig XML files from the Interent. When exported data to Excel spreadsheet, string start with zero e. Jun 8 Navicat Premium Windows version 9. Each SQLite field was limited to bytes. Tab order in Import Wizard was set up incorrectly. May 31 Navicat Premium Windows version 9. In Navicat main, copying action would not work properly after certain user actions.
When adding new field and tabbing across cloumns in Table Designer, bule hash would appear at the end of the columns. When tabbing betweem columns in Table Deisgner, some columns would be skipped. Beautify SQL feature did not compatible with Navicat Query Parameter syntax, so that error would occur when running the parameter query.
May 17 Navicat Premium Windows version 9. Improved smart quote identifier for SQLite. Improved virtual grouping rename issue - e. Bug Fixes: Access Violation error occured when exporting chart report to excel file. May 10 Navicat Premium Windows version 9. Support Cancel action in copying SQLite objects, table and query. The font size used in Query grid was smaller than in View grid. Fixed the wrong positioning issue of main menu items. May 3 Navicat Premium Windows version 9. Improvements: Improved the performance for opening Table Viewer with huge amount of columns.
Bug Fixes: When selecting a particular entry in an enum select box by typing the first letters of the item, the wrong value would be saved if confirmed the changes using the check mark. When applied "Auto save" function, recover window would not launched if multiple Navicat instances started. When trying to determine if the dataset were editable in Query, error would occur if user contained privilege on View, but did not have select privilege for Table.
Comments
Post a Comment