1. Horizontal scrollbar is now reset to the left position after applying Beautify SQL feature.

Bug Fixes:

1. "Access violation" error sometimes occurred when running an invalid syntax in Query Editor.
2. "Access violation" error occurred when opening a search report in Report Viewer.

Upgrade Procedure : click here to upgrade

1. Horizontal scrollbar is now reset to the left position after applying Beautify SQL feature.

Bug Fixes:

1. "Access violation" error sometimes occurred when running an invalid syntax in Query Editor.
2. "Error in updating task" error occurred when saving a scheduled task.
3. Error occurred when schedule name and path contained unicode string.

Upgrade Procedure : click here to upgrade

1. "Test Connection" action can now be canceled in Connection Properties.
2. Text Qualifier can now be freely set to any characters during Import Wizard.

Bug Fixes:

1. If a group contained more than two connections, error would occur when trying to delete the group.
2. Updated rows in Query Viewer were reverted back to their previous value after highlighting another rows.
3. Navicat hanged when importing multiple files using Import Wizard.
4. Error message could not be displayed if "Continue on Error" was not checked in Data Transfer.
5. Foreign keys transferred from one schema to another were mistakenly referring to the source schema during Data Transfer.
6. Memory allocation problem when the manual was opened.

Upgrade Procedure : click here to upgrade

1. Brackets in FROM clause could not be parsed between Query Editor and Query Builder.
2. When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
3. When exporting numeric data to excel file, it would be exported as string type.
4. Sort by time could not work properly in Server Monitor.
5. Process ID became negative value in Server Monitor.

Upgrade Procedure : click here to upgrade

1. Brackets in FROM clause could not be parsed between Query Editor and Query Builder.
2. When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
3. When exporting numeric data to excel file, it would be exported as string type.
4. Sort by time could not work properly in Server Monitor.
5. Process ID became negative value in Server Monitor.

Upgrade Procedure : click here to upgrade

1. Changes on SSH settings in Connection Properties would only be applied after Navicat restarted.
2. In Mac OS X 10.4, Navicat would crash when opening tables with foreign keys.
3. Menu bar did not display properly when running in Mac OS X 10.4.
4. Navicat hanged when switching to some object pages in main window when running in Mac OS X 10.4.
5. Some buttons and text were not displayed properly in Mac OS X 10.4.

Upgrade Procedure : click here to upgrade

1. Added highlight keywords - ELSIF in SQL Beautifier.

Bug Fixes:

1. "Access Violation" error occured when printing database/table structure to PDF, HTML etc.
2. "Open Table (Quick)" could not work properly in some machines issues.
3. "List Index our of bounds (58)" error occured when trying to enter/edit SQL in query Definition tab.
4. Foreign Key link position in Visual Builder were not accurate enough.
5. Fixed bug when parsing FROM clause with brackets in Visual Builder, e.g. select ... from ((...)).
6. Privileges tab in Table Designer was unable to toggle check box using keyboard.
7. Server Monitor would crash if being opened for a while.
8. The info column in Server Monitor only showed (WIDEMEMO).

Upgrade Procedure : click here to upgrade

1. Added highlight keywords - ELSIF in SQL Beautifier.

Bug Fixes:

1. "Access Violation" error occured when printing database/table structure to PDF, HTML etc.
2. "Open Table (Quick)" could not work properly in some machines issues.
3. "List Index our of bounds (58)" error occured when trying to enter/edit SQL in query Definition tab.
4. Foreign Key link position in Visual Builder were not accurate enough.
5. Fixed bug when parsing FROM clause with brackets in Visual Builder, e.g. select ... from ((...)).
6. Privileges tab in Table Designer was unable to toggle check box using keyboard.
7. Server Monitor would crash if being opened for a while.
8. The info column in Server Monitor only showed (WIDEMEMO).

Upgrade Procedure : click here to upgrade

1. Connection name is now shown in the title bar of Console window.
2. Keyword "elsif" can now be recognized.

Bug Fixes:

1. If the decimal symbol was not set as period (.), incorrect decimal values may be imported for excel files.

Upgrade Procedure : click here to upgrade

1. Please refer to Navicat Premium, Navicat for MySQL, Navicat for PostgreSQL and Navicat for SQLite release notes for the bug fixes of version 9.0.7.

Upgrade Procedure : click here to upgrade

1. Beautify SQL would cause error if extra spaces existed in aggregate function.
2. Fixed error when importig XML files from the Interent.
3. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
4. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

Upgrade Procedure : click here to upgrade

1. libcurl.dll library updated.

Bug Fixes:

1. Beautify SQL would cause error if extra spaces existed in aggregate function.
2. Fixed error when importig XML files from the Interent.
3. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
4. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

Upgrade Procedure : click here to upgrade

1. Show the host information under Connection Information view.

Bug Fixes:

1. Memory allocation problem which may cause Navicat to crash when transferring data using Data Transfer.
2. Incorrect values were synchronized during Data Synchronization.
3. Crashed easily when running queries in Query Viewer.

Upgrade Procedure : click here to upgrade

1. Support of SQLite.
2. Import/Export connection.
3. PL/SQL Code Debugger.
4. Code outline for Oracle functions/procedures/packages/types.
5. Significant Improvements made in code/word completion.
6. Code Folding.
7. Matched Brace/Bracket Highlighting.
8. Parameter Tips.
9. Zoom In/Out for SQL editors.
10. SQL Beautifier.
11. Favorites.
12. Object Filter.
13. Auto save in Query, Function etc.
14. Custom sort in Tabler Viewer.
15. Significant Improvements made in editor and data grid searching.
16. Notification email supports SSL/TLS in Schedule.
17. History Log Viewer.

Upgrade Procedure : click here to upgrade

1. "Duplicate name 'Field11' in TFieldDefs" error occured if a table contained more than 11 fields in which the first ten field names include "Field1".
2. Tab order in Import Wizard was set up incorrectly.

Upgrade Procedure : click here to upgrade

1. Added more popup option for Where and Having clauses in Query Builder.

Bug Fixes:

1. In Navicat main, View -> Sort did not work properly.
2. In Navicat main, copying action would not work properly after certain user actions.
3. In Navicat main, Window -> Next Window did not work properly.
4. When adding new field and tabbing across cloumns in Table Designer, bule hash would appear at the end of the columns.
5. When tabbing betweem columns in Table Deisgner, some columns would be skipped.
6. Beautify SQL feature did not compatible with Navicat Query Parameter syntax, so that error would occur when running the parameter query.

Upgrade Procedure : click here to upgrade

1. If the row is selected, Filter Wizard will now display the words in white color.
2. Query Builder supports to show diagram for some incomplete statement.

Bug Fixes:

1. Crashed when getting server Information on Information View if connection failed.
2. Improper join lines were displayed when joining multiple tables in Query Builder.
3. Crashed when parsing some improper SQL statements.

Upgrade Procedure : click here to upgrade

1. Improved virtual grouping rename issue - e.g. group like "ITem" and it didn't allow to change into "Item".
2. Changed to use Ctrl+MouseWheel instead of LeftClick+MouseWheel for zoom in/out function in Query Editor.
3. Query Builder is now able to handle incomplete SQL statement when switching between Query Editor and Query Builder.
4. SELECT clause is now able to be generated when dragging a table to Query Builder without selecting any columns, and switching to Query Editor.
5. Improved export data to excel spreadsheet - number/float data is now being export to number format instead of string format.
6. Widen the width of the saved profiles list under Data Transfer and Data/Structure Synchronization windows.
7. Added shortcuts for Structure Synchronization - [ctrl+a] to select all scripts, [ctrl+c] to copy selected scripts, right click the popup menu to copy the selected scripts.

Bug Fixes:

1. Access Violation error occured when exporting chart report to excel file.
2. The automatic word wrap in TEXT fields not working properly in Form View.
3. "Navicat is not able to prase SQL" error occured in Query Editor.
4. Navicat freezed when applying "Beautify SQL" on some SQL statements.

Upgrade Procedure : click here to upgrade

1. Crashed when importing to Oracle Server with comma as decimal separator during Import Wizard.

Upgrade Procedure : click here to upgrade

1. Added Java and XML syntax highlighting for Oracle.

Bug Fixes:

1. The font size used in Query grid was smaller than in View grid.
2. "Set Display Format" option in Table Viewer did not work in numerical field.
3. Fixed the wrong positioning issue of main menu items.

Upgrade Procedure : click here to upgrade

1. Added a section in Query View Result tab so that it can now show the sql and the query time.
2. Query result data can now be exported even if the sql is not saved.

Bug Fixes:

1. Failed to edit table data under HTTP Tunnel connection.
2. Failed to edit data in Views.
3. View Builder could not generate the corresponding GUI component from the query in View Editor.
4. Crashed when running SQL query under HTTP tunnel connections.
5. Failed to delete data inside the cells in Table Viewer by pressing Delete button.
6. SSH Password box disappeared in Connection Properties windows for Oracle connections.

Upgrade Procedure : click here to upgrade

1. Improved the performance for opening Table Viewer with huge amount of columns.

Bug Fixes:

1. 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.
2. When applied "Auto save" function, recover window would not launched if multiple Navicat instances started.
3. "Access violation" error occured when creating function using Function wizard.
4. "Not enough storage is available to complete this operation" error occured when exporting field values start with "=" to Excel file.
5. Fixed the drag & drop problem on Select, Where, Group By, Having, Order By, Limit regions in Query Builder.
6. 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.
7. "Access violation" error occured for code/word completion feature.

Upgrade Procedure : click here to upgrade

1. Added shortcut keys for bottom bar buttons in Table Viewer.
2. Adjusted the cell editable only when those data is allowed to update in Query Viewer.
3. Improved the dynamic width for Code/Word completion window.
4. New lines are now not exported as \n during Export Wizard.
5. Added Java and XML syntax highlighting.
6. In Code Outline, included parameters in the list under proc/func in simple view.
7. In Code Outline, showed parameters in the label of proc/func in detail view.
8. Added button to choose sorting option in Code Outline.

Bug Fixes:

1. Dragging images into Image Editor were converted to tiff format.
2. "Format" menu flashed frequently on Mac 10.5.
3. Some SQL statements would cause Navicat crashed when switching to Query Builder.

Upgrade Procedure : click here to upgrade

1. Better handle case sensitive of object identifier for Query Builder.
2. Support "select ... from ... group by left(..., ...)" when switching from Query Editor to Query Builder.
3. Reviewed default Keyword/Function for Oracle.
4. Improved keywords list for Code/Word Completion.
5. Attached hot keys to the navigation bar in Table Viewer.
6. In Code Outline, supports parameter as node for simple view.
7. In Code Outline, supports sort by position, sort by type/name.

Bug Fixes:

1. Toolbar buttons did not refresh after maximized/minimized and changed size of panes.
2. Toolbar would blink when toggling taskbar auto hide option.
3. Oracle debugger window could not be closed when debug running error occured.
4. When sweithed between Query Builder ad Query Editor, ";" would be inserted into the middle of the statement.
5. "Select All" and "UnSelect All" buttons missing in Data Synchronization window.

Upgrade Procedure : click here to upgrade

1. Crashed when comparing non-ascii table name during Structure Synchronization.
2. Failed to support the case that second is omitted in Oracle Import Wizard (e.g. "YYYY-MM-DD HH:MM").
3. Failed to handle Oracle Environmental Path with spaces.
4. Hangged when executing some SQL file using Execute SQL File function in Mac 10.6.

Upgrade Procedure : click here to upgrade

1. Import/Export connection.
2. PL/SQL Code Debugger.
3. Code outline for Oracle functions/procedures/packages/types.
4. Significant Improvements made in code/word completion.
5. Code Folding.
6. Matched Brace/Bracket Highlighting.
7. Parameter Tips.
8. Zoom In/Out for SQL editors.
9. SQL Beautifier.
10. Favorites.
11. Object Filter.
12. Unicode Character Report.
13. Auto save in Query, Function etc.
14. Custom sort in Tabler Viewer.
15. Significant Improvements made in editor and data grid searching.
16. Notification email supports SSL/TLS in Schedule.
17. History Log Viewer.

Upgrade Procedure : click here to upgrade

1. Import/Export connection.
2. PL/SQL Code Debugger.
3. Code outline for Oracle functions/procedures/packages/types.
4. Significant Improvements made in code/word completion.
5. Code Folding.
6. Matched Brace/Bracket Highlighting.
7. Parameter Tips.
8. Zoom In/Out for SQL editors.
9. SQL Beautifier.
10. Favorites.
11. Object Filter.
12. Individual database objects backup.
13. Unicode Character Report.
14. Auto save in Query, Function etc.
15. Custom sort in Tabler Viewer.
16. Significant Improvements made in editor and data grid searching.
17. Notification email supports SSL/TLS in Schedule.
18. History Log Viewer.

Upgrade Procedure : click here to upgrade

1. Maintain Table will now show the full message reported by the server after operation.

Bug Fixes:

1. Failed to import xml file with values inside xml attributes during Import Wizard.
2. Failed to backup the server in schedules.
3. Wrong File menu would be shown sometimes in main window.

Upgrade Procedure : click here to upgrade

1. "ORA-00932" error occured when opening Oracle 9i table, which contained FLOAT type, in Table Viewer.
2. Word Wrap status did not save in the Query Editor.
3. "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
4. When import from ODBC with empty tables, "BOF/EOF access" error would occur.
5. Error dialog occured when selecting target connection in Data Transfer.

Upgrade Procedure : click here to upgrade

1. "ORA-00932" error occured when opening Oracle 9i table, which contained FLOAT type, in Table Viewer.
2. Word Wrap status did not save in the Query Editor.
3. "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
4. When import from ODBC with empty tables, "BOF/EOF access" error would occur.
5. Error dialog occured when selecting target connection in Data Transfer.

Upgrade Procedure : click here to upgrade

1. Improved the support of bigger data in each cell of Excel file during Export Wizard.
2. It now has no restriction on jointing the data type fields in Query Builder.

Bug Fixes:

1. Deadlock occured when opening new windows using SSH Connection.
2. Fixed crash problem during Import Wizard.
3. The "Run" button would be disabled in some cases even the SQL stopped running in Query Editor.

Upgrade Procedure : click here to upgrade

1. Connections were not freed before quitting Navicat.
2. Timestamp field properties text box was not shown in Oracle Table Designer.
3. Form View would crash when editing with no row selected.
4. Data were uneditable in Oracle Form View.
5. Wrong linkage was shown for field name with capital letters in Query Builder.

Upgrade Procedure : click here to upgrade

1. Restore function could not work properly.
2. Insert Field did not work in Table Designer.

Upgrade Procedure : click here to upgrade

1. Restore function could not work properly.
2. Insert Field did not work in Table Designer.

Upgrade Procedure : click here to upgrade

1. Sequence checkbox status and counter did not work properly in Data Transfer.

Upgrade Procedure : click here to upgrade

1. Connection Name in Connection Properties sometime would show empty value.
2. Sequence checkbox status and counter did not work properly in Data Transfer.

Upgrade Procedure : click here to upgrade

1. Improved the internal code to avoid some crash that would occur.

Bug Fixes:

1. Error would occur when importing date with 2 digit with "Four Digit Years" checked in Import wizard.

Upgrade Procedure : click here to upgrade

1. When launched Oracle Console, Terminal window would popup twice.
2. Some data would be truncated when getting data from Oracle server.
3. Data Transfer, Data Synchronization and Structure Synchronization Profiles selection box would display improperly if Toolbar Appearance was set as "Text Only".
4. Navicat Import Wizard was unable to recognize some xml attributes properly.
5. When modified Index in Table Designer, Some changes could not be recognized.
6. Failed to display the referencing table list when editing existing Foreign Key in Table Designer.
7. The first record could not be selected in Table Form View under Mac OS 10.6.
8. Navicat crashed if the network drive could not be found during the Backup process.

Upgrade Procedure : click here to upgrade

1. In step 6 of Import Wizard, Source field name would be truncated if longer than 255 characters. Now, Navicat supports up to 5000 field name characters.

Bug Fixes:

1. Refresh did not work for getting update data.
2. When import text-based file using Import Wizard, Navicat was unable to get the number of columns correctly if the file did not contain field name row or there were empty lines existed before first data row.

Upgrade Procedure : click here to upgrade

1. In step 6 of Import Wizard, Source field name would be truncated if longer than 255 characters. Now, Navicat supports up to 5000 field name characters.

Bug Fixes:

1. When a schedule is set by a root user, other user which did not contain privileges enough would be unable to modified that schedule profile.
2. Refresh did not work for getting update data.
3. When import text-based file using Import Wizard, Navicat was unable to get the number of columns correctly if the file did not contain field name row or there were empty lines existed before first data row.

Upgrade Procedure : click here to upgrade

1. Primary Key were defined improperly under SQL Preview tab in Table Designer.
2. The cursor position moved to end-of-line after saved the Stored Procesure/Function.
3. "'x,x' is not a valid floating point value" error occured when opening a table that contains floats data type together with the regional settings were set to Dutch environment.
4. Failed to establish SSH connection when the private key path contained unicode.
5. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
6. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
7. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
8. When resizing the Data Transfer/Data Synchronization/Structure Synchronization window, all data fields expanded to display longer content except the "profile" drop down list.

Upgrade Procedure : click here to upgrade

1. Primary Key were defined improperly under SQL Preview tab in Table Designer.
2. The cursor position moved to end-of-line after saved the Stored Procesure/Function.
3. "'x,x' is not a valid floating point value" error occured when opening a table that contains floats data type together with the regional settings were set to Dutch environment.
4. Failed to establish SSH connection when the private key path contained unicode.
5. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
6. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
7. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
8. When resizing the Data Transfer/Data Synchronization/Structure Synchronization window, all data fields expanded to display longer content except the "profile" drop down list.

Upgrade Procedure : click here to upgrade

1. Improved compatibility to some ODBC drivers for Import Wizard.

Bug Fixes:

1. Data grid was unable to be opened properly when some kind of text were displayed.
2. Removed some internal SQL run by Navicat in Query Viewer.
3. Unable to change the default value of an existing field from NULL to other values in Table Designer.

Upgrade Procedure : click here to upgrade

1. Please refer to Navicat Premium, Navicat for MySQL and Navicat for PostgreSQL release notes for the bug fixes of version 8.2.15.

Upgrade Procedure : click here to upgrade

1. Please refer to Navicat Premium, Navicat for MySQL and Navicat for PostgreSQL release notes for the bug fixes of version 8.2.15.

Upgrade Procedure : click here to upgrade

1. Export Wizard is now able to export data filering result.

Bug Fixes:

1. "Property cannot be found" error occured when importing Access file with datatype that may involve decimal places info, e.g.currecy, number, floating point value.
2. "Access Violation" error occured when exporting data to Access file if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

1. Export Wizard is now able to export data filering result.

Bug Fixes:

1. "Property cannot be found" error occured when importing Access file with datatype that may involve decimal places info, e.g.currecy, number, floating point value.
2. "Access Violation" error occured when exporting data to Access file if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

1. Export Wizard is now able to export data filering result.

Bug Fixes:

1. Foreign Key Data Selection window was unable to show Text field data, it showed [TEXT] instead.
2. SQL*Plus was unable to activate if the paths under Environments tab in Preferences contained spaces.
3. When set criteria using BETWEEN keyword in Filter Wizard, error message would occur.

Upgrade Procedure : click here to upgrade

1. The Data Synchronization message log will not show server name rather than Host/IP.

Bug Fixes:

1. Import Wizard would be launched if the Data format was not properly set.
2. Date field was not converted correctly when exported to DBF file.
3. Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
4. Docked windows could not show in task bar under Windows 7.
5. Email attachment in Schedule could not be sent if "Add timestamp" option was enabled in Export Wizard.

Upgrade Procedure : click here to upgrade

1. The Data Synchronization message log will not show server name rather than Host/IP.

Bug Fixes:

1. Import Wizard would be launched if the Data format was not properly set.
2. Date field was not converted correctly when exported to DBF file.
3. Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
4. Email attachment in Schedule could not be sent if "Add timestamp" option was enabled in Export Wizard.

Upgrade Procedure : click here to upgrade

1. Compatible with Mac OS X Snow Leopard.
2. Stability improvement on tabbed window.

Bug Fixes:

1. Import Wizard would be launched if the Data format was not properly set.

Upgrade Procedure : click here to upgrade

1. Improve suggestion on target data type and provide a default precision and scale information in Import Wizard.
2. Support export to clipboard.

Bug Fixes:

1. When edited an Oralce user, "ORA-00904: DROPPED: invalid identified" occured.
2. When docking a console window to main window, the wheel of mouse would be no effect.
3. Month calendar Could not fully display in some system.
4. If password did not save in Connection Properties, Dump SQL File would not work propertly.

Upgrade Procedure : click here to upgrade

1. Support Oracle version 8.1, 9i, 10g and 11g.
2. Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions.
3. Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers.
4. Managing directories, tablespaces, public database links and public synonyms.
5. Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin.
6. Support of physical attributes.
7. Support of Unicode/Character Set.

Connection options:

1. Support of password and public/private key for SSH Tunnel.
2. Support of HTTP Tunnel for MySQL and PostgreSQL Servers.

Well-designed user interface:

1. Grid View and Form View support.
2. Virtual Grouping for connections and objects.

Powerful Data Manipulation Tools:

1. Import and Export tool.
2. Data Transfer tool.
3. Data and Structure synchronization.
4. Backup and Restore.
5. Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization.
6. Ability to attach Export Wizard/Report result files in Batch Job notification email.

SQL Processing:

1. Visual query/view builder to facilitate the process of building complicated queries.
2. Ability to create parameter queries.
3. Multiple SQL editors with syntax highlighted feature.
4. Code completion for SQL editors.
5. Ability to preview SQL before execution.
6. Support to return multi-resultsets.

Upgrade Procedure : click here to upgrade

1. Improved the stability when running a query.

Bug Fixes:

1. Some windows size and position were not saved after closed.

Upgrade Procedure : click here to upgrade

1. "SSH Tunnel:''is not a valid integer value" error occured during SSH connection.
2. When exported data to MS Access, month and day values were mixed up.
3. Slow problem while transfering data from command line.
4. Access Violation error happened when creating new table with index.
5. Fixed SQL parsing problem for Oracle version.
6. Index, constraint and trigger could not be renamed in Table Designer.

Upgrade Procedure : click here to upgrade

1. Support choosing server version for SQL to be generated in Data Transfer, support more transfer options.
2. Added connection tree to support batch jobs from different databases.
3. Compatibility and speed improvement in exported excel format.
4. Notification email in batch job is now delivered in MIME format.
5. Allow setting fonts in Data Grid, and apply Editor Font to View/Edit Text.
6. Added DateTime picker in Table View for Oracle server.

Bug Fixes:

1. Navicat could not quit normally in some senarios.
2. View Builder did not display properly.
3. Slow problem when opening Query View.
4. Improper ordering of the generated SQL during Structure Synchronization.

Upgrade Procedure : click here to upgrade

1. If table names stated with number e.g. 1Table, those tables were not displayed on the Query Builder.
2. when using Find (ctrl+f) in Form View, it would jump out of Form View into Grid View.
3. When applied docking feature under Windows 7, "System Error. Code: 87. The parameter is incorrect" occured.
4. Fixed "Select" statement with empty string in Query Editor resulted in Access violation.

Upgrade Procedure : click here to upgrade

1. Improved dual monitor system support.
2. Report files are now able to copy to other dataabses.

Bug Fixes:

1. Access Violation error happened on Data Synchronization when the target connection applied HTTP Tunnel.
2. Backup failed when connection applied HTTP Tunnel.
3. When closed the Restore dialog after restored, Access violation occured.
4. User-defined schema would not show in Structure Synchronization.
5. "Not enough timers available" error occured in Structure Synchronization.
6. After saved the query in Query Editor, the cursor returned to the beginning of the script.
7. When deleted multi-cell in Table Viewer, Navicat would hang.

Upgrade Procedure : click here to upgrade

1. Support import/export from/to Access 2007 file.
2. When using "Duplicate Connection" to create a new connection, Settings Save Path won't be copied.

Bug Fixes:

1. Fixed while getting wrong Oracle sequence info during the Data Transfer process.
2. Fixed the column width not saved in Query Result tab.
3. When exporting tables with choosing "None" for Field delimiter into Text file, it now not add #0(null character) as delimiter.
4. SSH connection did not work properly.
5. Last Character would be chopped when exported data using Export Wizard.

Upgrade Procedure : click here to upgrade

1. Ability to duplicate connection.

Upgrade Procedure : click here to upgrade

1. Fixed access violation issue while reorganizing Join table for a saved query.
2. Fixed "Duplicate Field" function in Table Designer, given "unknown column..." error message.
3. Fixed access violation issue during backup process.
4. BFile/CFile not being handled.

Upgrade Procedure : click here to upgrade

1. Added BINARY_FLOAT and BINARY_DOUBLE in datatype picklist for Oracle 10 or above.
2. Improved stability in Query.
3. Ability to stop while establishing connection to server.
4. Adjusted the default Settings Save Path to "My Documents".
5. Detail View (object attributes) will now being adjusted under View menu.
6. Improved Stored Procedures/Functions Wizard as non-modal form.
7. Adjusted the file size behavior of "Use extended insert statements" when transfering to file.
8. Added execute time for Explain action under Message tab in Query.
9. Support Ctrl+Del shortcut to delete records.

Bug Fixes:

1. Fixed SSH Tunnel: BigInteger Overflow issue.
2. OCI settings was unable to be changed.
3. Fixed missing ROWID issue in Table Viewer.
4. Fixed the crash issue while doing the seach action in Query results.
5. Fixed field alias update/insert issue in Query.
6. Date became 0 while exporting to Excel.
7. Fixed password prompt issue while connecting to server in Data Transfer, Data/Structure Synchronization, Console and Server monitor.
8. Fixed GUI font size issue in Connection form.
9. Fixed columns missing while printing reports using schedule in command line
10. Fixed Virtual Grouping was unable to load.
11. When importing dbf/excel file floating values '.' or ',' as decimal separator, Navicat will now try both in order to recognize its proper floating values.
12. Navicat will now end to run the routine for Profile/Status if the Query has stopped by user.
13. Fixed access violation issue when deleted table in Query Builder after running the query.
14. Fixed file association for Windows Vista and Windows 7.

Upgrade Procedure : click here to upgrade

1. Duplicated tables are sometimes displayed in Query Builder.
2. Crash when changing the default value of bit fields in Table Design.
3. Crash when no profile name are specified in command line backup and export.
4. Code completion not working properly on unicode characters.

Upgrade Procedure : click here to upgrade

Navicat new logo design has been launched.

Upgrade Procedure : click here to upgrade

Major new features:

1. Support of Form View.
2. Support of Code Completion in all SQL Editor.
3. Support of ODBC Import.
4. Support of exporting Excel file.
5. Support of View, Store Procedure, Sequence, etc in Structure Synchronization.
6. Ability to send notification e-mail for schedule task, with an option to attach file output from Export Wizard.
7. Support of creating table, view, import/export profile shortcut on desktop.
8. Support of SQL Preview for all object design forms.

Other enhancements:

User Interface

1. Object information is now shown in pane inside Navicat main form rather than pop-up modal dialog.
2. "Comment" is now shown in a separated tab for all object design forms.
3. Support of setting font styles for object lists and editors.
4. Virtual Grouping is now supported for Tables, Views, Functions, Queries, Backups and Schedules.
5. Object Dependency Relationships shown in "Using" and "Used By" tab under Object Information pane.
6. Detail View is available for database objects under "Others" menu.
7. More shortcut keys are supported.

1. Added Data Time control in Table Viewer.
2. Added control for setting Stored Procedure parameters and return types.

1. Added Rename and Duplicate connection.
2. Ability to copy Connection Information into Clipboard.
3. Support of keeping Navicat connections alive.

1. Line breaks support for CSV and Text Import.
2. Improved recognition accuracy for XML file.
3. Options to choose which fields to export.

1. A new interface supported.
2. Support of multiple tables Export.
3. Options to choose which fields to export.
4. Additional options to set Date and Time format.

1. Increased Speed.
2. Options to choose which objects to compare.
3. Options to choose execution methods.

1. Increased Speed.

Backup

1. Support of saving profile, running schedule with specified backup options.

Upgrade Procedure : click here to upgrade

• Query Builder failed to work for JOIN statement.

Download here

Upgrade Procedure : click here to upgrade

• Added Ctrl+Q shortcut to popup new query.

Bug Fixes:

• Fixed "New Group" behavior in Schedule group setting.
• Hidden Primary Key setting for External table design.
• Fixed Access Violation error while running schedule for import in command line.
• Fixed Unicode error message issue.
• Fixed VARCHAR2 data type error in Dump SQL/Data Transfer.

Download here

Upgrade Procedure : click here to upgrade

• Fixed incorrect negative value is fetched.

Download here

Upgrade Procedure : click here to upgrade

1. Support of Oracle 8i.
2. Added smart auto-choosing Record Separator (CRLF, CR and LF) in Import Wizard.

Download here

• Support of Oracle 8i.

Download here

1. Foreign Key Data Selection - locate the available values from the reference table.
2. SQL Builder.
3. Import Wizard.
4. Export Wizard.
5. Data Transfer.
6. Data Synchronization.
7. Structure Synchronization.
8. Schedule.
9. Build in SQL*Plus.
10. Server Monitor.
11. Print Database/Table Structure.

1. Added login as SYSDBA and SYSOPER.
2. Added login with OS Authentication.
3. Added Change Password prompt dialog when password expired.
4. Support of Recycle Bin object.
5. A DBMS output tab is added in Query.
6. Added Run button in Stored Procedure.
7. Added "Refresh Materialized View" in Object Pane.
8. Added OCI settings in Preferences
9. Added font settings for SQL Editor.

Download here

1. Form View.
2. Foreign Key Data Selection - locate the available values from the reference table.
3. SQL Builder.
4. Import Wizard.
5. Export Wizard.
6. Data Transfer.
7. Data Synchronization.
8. Structure Synchronization.
9. Schedule.
10. Build in SQL*Plus.
11. Server Monitor.
12. Print Database/Table Structure.
13. Report Builder.

1. Added choosing of ServiceName/SID for connection string.
2. Added login as SYSDBA and SYSOPER.
3. Added login with OS Authentication.
4. Added Change Password prompt dialog when password expired.
5. Support of Recycle Bin object.
6. Code Completion for SQL Editors.
7. A DBMS output tab is added in Query.
8. Added Run button in Stored Procedure.
9. Added "Refresh Materialized View" in Navicat Main.

Download here

1. Support of Java object (Source/Class/Resource).
2. Support of XML Schema object.
3. Support of External and Index Organized table.
4. Support of Physical Attributes in Table Design, Tablespace Design, Index Design, Materialized View Design and Materialized View Log Design.
5. Included options to choose Service Name or SID in connection properties.
6. Added Tablespace Objects in Object Information.
7. Added Dependencies in Object Information.

Upgrade Procedure : click here to upgrade

1. Support of OCI setting in Options.
2. Support of Java object (Source/Class/Resource).
3. Support of XML Schema object.
4. Support of External and Index Organized table.
5. Support of Physical Attributes in Table Design, Tablespace Design, Index Design, Materialized View Design and Materialized View Log Design.
6. Added syntax highlight for objects SQL Preview and DDL.
7. Added Object Information in object Popup menu under Others item.
8. Added Tablespace Objects in Object Information.
9. Added Dependencies in Object Information.
10. Added password prompt dialog for opening Table Shortcut when password not saved in Connection Properties.

1. Fixed the connect string problem for Oracle Client 9.
2. Fixed of binding multiple BLOB fields.

Upgrade Procedure : click here to upgrade

1. Edit Directory privileges provided.

1. When got focus on Connection icon in Navigation Pane, delete on database objects will not working.
2. Fixed privilege SQL creation while altering Collection Type.
3. Set DYNAMIC_FETCH_SIZE to 65536.
4. Fixed Max Size settings in Tablespace.
5. Fixed bug of dropping field

Upgrade Procedure : click here to upgrade

Lastest Oracle versions support:

1. Compatible with Oracle servers version 9i, 10g and 11g.
2. Support of all Oracle objects and subobjects.
3. Support of character set and unicode.

Connection Management:

1. Multiple local/remote Oracle server connections.
2. Support of Basic (OCI) and TNS connection.
3. Connection to Oracle server through SSH.
4. Backup connection settings.

Well-designed user interface:

1. Customize of connection order.
2. Data are well shown in the tree view.
3. Provide well-vision for users in table grid.
4. Support dock windows.

Powerful data management tools:

1. Grid view.
2. Support of TEXT, Hex and BLOB/BFile viewer/editor.
3. Support of Copying and pasting selected records.
4. Customize display formats.
5. Incremental search, sorting and formatting table grid.
6. Ability to show/hide ROWID.
7. Ability to set number of records showing on each page.
8. Multiple SQL editors with syntax highlighted feature
9. Ability to preview SQL before execution.
10. Support of Query and Parameter Query.
11. Executing SQL script.

Additional features:

1. Support of Manage User.
2. Create table/view shortcut on desktop .
3. Support of Log files - keep track on the actions have been performed in Navicat.

Main features:

Lastest Oracle versions support:

1. Compatible with Oracle servers version 9i, 10g and 11g.
2. Support of all Oracle objects and subobjects.
3. Support of character set and unicode.

Connection Management:

1. Multiple local/remote Oracle server connections.
2. Support of Basic (OCI) and TNS connection.
3. Connection to Oracle server through SSH.

Well-designed user interface:

1. Customize of connection order.
2. Data are well shown in the tree view.
3. Provide well-vision for users in table grid.
4. Support dock windows.

Powerful data management tools:

1. Grid view.
2. Support of TEXT, Hex and BLOB/BFile viewer/editor.
3. Support of Copying and pasting selected records.
4. Customize display formats.
5. Incremental search, sorting and formatting table grid.
6. Ability to show/hide ROWID.
7. Ability to set number of records showing on each page.
8. Multiple SQL editors with syntax highlighted feature.
9. Ability to preview SQL before execution.
10. Support of Query and Parameter Query.
11. Backing up database/table to SQL script.
12. Executing SQL script.

Additional features:

1. Support of Manage User.
2. Support of Log files - keep track on the actions have been performed in Navicat.