Navicat™ for SQL Server Version is released – Course Information

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

The database conversion from older formats to MySQL is seamless. Transferring data from one server to other is very convenient. Of particular importance to this choosing this solution was the strong CSV upload and export tools. It also proved really useful to be able to store queries and share them between users. The query builder was a big plus too. Even after weeks of having a standard process of managing the database we utilize Navicat’s import mechanism to handle unique data updates coming from our customer.

Without this ability we would be weeks behind schedule. Navicat is relative ease of use, and flexibility. Also, the interface for dealing with the database is straightforward, easy to use, and powerful. The XML conversion was particularly impressive. It is going to save us tons of time and time is money!

Navicat is easy to use because the menus and tools bars are very clearly label and designed. We have never had a problem with the software crashing or corrupting data. What might take hours with the command line, Navicat can accomplish in seconds. It is quite easy to use and has very powerful features as, for instance, the query builder. The features we use most are the backup and queries, also in relation with the scheduler. A nice-to-have feature would be a mailer function where, for instance, a result of a query could be sent to a specific user.

It is by far the best product of its kind on the market. And the price is much lower than I would have expected for such a robust feature rich product.

With Navicat importing and exporting data from and to those formats is very easy and requires virtually no additional training. Moving to new technology is often intimidating to people but once I demonstrated Navicat to our staff they were pleasantly surprised.

Navicat truly makes it easier to administer mySQL than any other product I have tried. Navicat ‘s strengths are obviously its ease of setup and use. This marks a more complete feature offering for database professionals by Navicat. With Navicat Data Modeling Tool, it allows user to create graphical representations of a relational database. The Reverse Engineer in Navicat Data Modeling Tool allows user to create a conceptual model from an existing database and graphically visualize and edit the structure of the database.

Or, user can graphically create a conceptual model, and generate a database that supports the model. Besides adding new features to version 10 of Navicat, PremiumSoft has also made various changes on the software licensing and pricing. For detailed pricing on Navicat, please visit our Online Store. PremiumSoft was founded in and is a fast growing company, aiming at accelerating application development and database management with software that enhance productivity and maximize results of our customers.

With our customer-centric focus and best-of-breed products and services, PremiumSoft has been successful in making customers significantly more productive. Bug fixes of Timestamp creation problem.

Bug fixes of adding a left join to existing View. Bug fixes of data transfer problem. New features: Data Synchronization. Jul 6 Navicat for Windows version 6. This new version includes a new feature – SSH Tunnel. Apr 20 Navicat for Windows version 6. Bug fixes on SSL connection. SSL Connection setup tutorial. Nov 10 PremiumSoft Navicat Windows version 5. Oct 1 Survey for New Features: In order for us to further enhance our Navicat, please tell us your comment through [ Navicat Survey ].

Sep 29 PremiumSoft Navicat Windows version 5. Aug 20 PremiumSoft Navicat Windows version 5. New features: foreign keys unicode support bugfix on displaying hidden popup windows.

Aug 5 PremiumSoft Navicat Windows version 5. New features: Foreign Keys – support to configure Foreign Keys. Unicode support. Apr 6 Version 5. New features: Process priority – loading table can be faster if priority is set to High. Improve the user-friendliness of Data Transfer feature.

There will be numerous performance and manageability improvements. New features: improve performance on multiple simultaneous jobs. The performance of running large queries will be greatly improved.. Function group creation issue. Hanged when updating records in some cases. Bug-fixes: Chart title display issue.

Query listing issue when loading cloud queries. Bug-fixes: Crashed when opening a table in some cases. Bug-fixes: Crashed when hovering over tabs.

Crashed when moving a connection from Navicat Cloud to My Connections. Crashed when running Automation in some cases. Bug-fixes: Crashed when using table viewer. Crashed when closing Navicat in some cases. Hanged when designing table. Unable to scroll through the fields with the mouse wheel in Query Builder. Duplicate options in the user Plugin dropdown menu. Connection coloring did not work on subtabs. Crashed when importing invalid json files. Line numbers disappeared when scrolling in Query Editor.

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. Crashed when running query in some cases.

Bug-fixes: Unable to update data in some cases. Crashed when using Data Transfer in some cases. 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.

Bug-fixes: ‘Primary key needs to be integer’ error occurred when synchronizing data. Unable to sort by clicking the column header in Table Viewer.

Bug-fixes: Data Synchronization UX issue. The modified dates of backup files were incorrect. Improvements: Prompt to change the MariaDB password when it expired. Bug-fixes: Unable to show the granted privileges if the database name contained wildcard characters. 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.

Bug-fixes: The “Set Null” option was applied to a wrong column when some columns were hidden in Table Viewer. The field size was incorrect in Form View. The “Encoding” setting was not stored when the connection was synchronized to Navicat Cloud. Bug-fixes: Unable to set the encoding of MariaDB connection. 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. Improvements: Improvement on resizing Information pane. Bug-fixes: Negative default value displayed as “-” in MariaDB. No records were imported in some cases when Import Wizard displayed “Finished Successfully”. Bug-fixes: Unable to show full table names in the Data Synchronization window. Field names in the Join dialog were truncated. Bug-fixes: Jumped to the first record when refreshing in Form View.

Unable to synchronize data to MySQL 8. The list of the reference tables for foreign key was empty in Model. Bug-fixes: Scrolling was slow in data viewer. The color picker disappeared in diagram.

Bug-fixes: The state of the pane in model was not retained. Field count was missing in Table Designer. Crashed when opening Console. Crashed when clicking the Next button without choosing a target database in Data Transfer. Unable to show the whole Trial Reminder dialog. Invalid XML error occurred when importing connections. Crashed when starting Data Transfer in some cases. Bug-fixes: Console was missing in Standard eidtion. 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. Bug-fixes: Crashed when starting Navicat. Dates before 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.

Bug-fixes: Data Synchronization options were unable to save in profile. A red exclamation mark was incorrectly displayed on the Navicat Cloud query icon. Unable to show the database list when there was more then databases. Data Transfer process was stopped in some cases. List View was not retained in the main window after restarting Navicat. Unable to use the Add Privilege button. Connections moved out of the group after editing.

Crashed when editing model in some cases. Bug-fixes: Empty tables were created when importing. 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. Missing “Tools” menu when running an infinite loop in Console. Crashed when comparing databases in Structure Synchronization. Crashed when saving models. Bug-fixes: Grid View and Form View menu options were flipped.

The row height of the object list did not match the font size. 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. Selected connection, database and schema names were missing in Data Transfer window. Bug-fixes: Unable to search the grouped queries unless the group was selected. 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. Bug-fixes: Crashed when opening Navicat if logged in Navicat Cloud. Unable to connect using SSH private key in some cases.

Crashed when clicking Views in some cases. Bug-fixes: Mojave’s Dark Mode did not display properly. Bug-fixes: Stored procedures was not exported properly when using Data Transfer. Import Wizard was slow in some cases. 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. Unable to list the batch jobs in some cases. Definition was missing when dumping Views and Functions. Crashed when starting Navicat in some cases. Foreign key data selection did not work. Bug-fixes: HTML export did not specify charset. 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. 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.

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.

Objects list loading was slow in some cases. Crashed when starting Navicat. 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.

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. Query column width reset after restarting Navicat. Memory leak issue. 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. Bug Fixes: Unable to open Console if a non-tabbed window was opened in font. Navicat hanged when refreshing table grid after changing field names. Navicat process was unable to terminate.

Enum type value returned as string in query results. Bug Fixes: Minor bug fixes and improvements. 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.

Unable to stop query when using SSL connection. Bug Fixes: Result tab was focused when explaining query. Query Plan result column was too narrow in Query. 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. Bug Fixes: Information panel retained when opening Navicat. Command-D shortcut did not open Design form when viewing View data. Syntax error occurred when editing data in table with binary primary key. Unable to resize the assistant editor in Table Viewer. Fixed cursor focus issue in Console. 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. Bug Fixes: Save dialog prompted even no changes made in Table Designer. Unable to execute query in some cases. Data synchronization crashed when HTTP connection was used. Unable to export views on High Sierra. Table Designer UI improvements. Font settings in Preferences reset to default after restarting Navicat.

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. Navicat hanged when using normal OS user account. Sync Username to Navicat Cloud option was missing in Connection form. Navicat hanged when connection was cut off. Error occurred when connecting to MariaDB in some cases.

Crashed when viewing or editing Functions. Code completion displayed unrelated items. Bug Fixes: Failed to move procedures to a virtual group. Improvements: Added some common keyboard shortcuts. Crashed when opening Query view in some cases. Crashed when running backup tasks in Batch Job. 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. Support smart quotes in Query Builder. Bug Fixes: 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. Failed to move multiple objects into a virtual group by right-click menu in Navicat Cloud connections.

Bug Fixes: Crashed when opening or closing Navicat Cloud database in some cases. Others Enhanced Filter Wizard. Enhanced Query Designer. Bug Fixes: Failed to log in Navicat Cloud in some cases. Crashed when running Structure Synchronization. Bug Fixes: Unable to copy backup files to another database by drag and drop method. Froze when operating Table Viewer with longtext data. Crashed when running stored procedures on OS X Crashed when running SQL multi times in Console.

Unable to set the default value of the bit type in Table Designer. Bug Fixes: 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. Improvements: Supported format strings in Schedule email body. Bug Fixes: Unable to send notification email in Schedule. Created a new connection when previewing a view. Unable to change the case of the backup file name.

Lost connections in some cases. Bug Fixes: Crashed when importing connections. Crashed when reversing database to model. Bug Fixes: Object List tab did not change when selecting nodes from connection tree.

Set up user access rights and restrictions by assigning roles to users. Customize the pre-defined roles to best fit your needs or create new roles with customized privileges settings to restrict access to selected pages in Navicat Monitor. Export your Monitor settings if you wish to migrate your application server from one computer to another new machine. The output of the backup script will be a zip file with all required configuration files and settings for the restoration. Set dark theme to protect your eyes from the traditionally blinding whiteness of computer.

No behavior changes with how pages look when you are in dark mode. Mac OS X Red Hat Enterprise Linux 6. Especially the query builder helps me to save time.

Navicat has a good user interface and it has perfect multitasking usability. It helps very much for our department to generate new reports. It makes working with databases fun. It’s much better than TOAD. Ease of use and the list of features make it my choice for MylL administration. My email questions were quickly and accurately answered.

The backup features and how simple it is to use cannot be compared. I recommend PremiumSoft Navicat to everyone I know. Keep up the great work guys!!!

The Speed of Navicat is very fast and its Interface is very nice. Stability has also been strengthened. Navicat is pretty much self-explanatory. Easy to use.

Nice GUI. We use Navicat to produce custom reports based on complex queries. The help file is also well organized and easy to follow. The tables are partial very big more than 50 Million records. With my favourite tool Navicat I create the queries fast and effective and with nightly schedules I get the query results on early morning. Also, your support worked quick and professional and now everything is alright.

Able to export and import easily. Very easy to use. Lightening fast. Scheduling, back-ups, Queries are all very easy to use. This does a lot more than what I expected. Didn’t really need the documentation. Navicat was so well designed and user-friendly that I just started using it. Updating without a UI from search table results.

 
 

 

Navicat for MySQL 发行说明 | Navicat.Navicat Premium Release Note | Navicat

 

PremiumSoft today free premiumsoft navicat premium 9.1 free the immediate release of version 9. Navicat for SQL Server is a new product introduced. This provides SQL Server users a tool for administering and managing database objects as well as for database migration, data import, export, synchronization, reporting, and frer, for Navocat Servers.

Navicat Premium unites all Navicat family members for database administration and development, into one powerful and easy-to-use work environment. With the new Navicat Premium version 9.

Navicat Premium v9. Navicat Lite edition is also available with limited functions and features, увидеть больше a free license for personal and non-commercial use. PremiumSoft was founded in and is a fast growing company, aiming at accelerating application development and database ppremium with software that enhance productivity and maximize results of our customers.

With our customer-centric focus and best-of-breed products and services, PremiumSoft has been successful in making customers significantly more productive. Products Support Partners About Us. Free premiumsoft navicat premium 9.1 free Us. Press Releases. Copyright – Key Topics. All Rights Reserved.