1. Connection name is now shown in the title bar of Console window.

Bug Fixes:

1. Query results were unable to be edited under HTTP Tunnel connection.
2. Failed to display Unsigned bigint values properly.
3. The referencing database of foreign keys were not properly transferred to files.
4. 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. 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. Connection name is now shown in the title bar of Console window.
2. Oracle keyword "elsif" can now be recognized.

Bug Fixes:

1. Query results were unable to be edited under MySQL HTTP Tunnel connection.
2. Failed to display MySQL unsigned bigint values properly.
3. The referencing database of MySQL/PostgreSQL foreign keys were not properly transferred to files.
4. 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. Connection name is now shown in the title bar of Console window.

Bug Fixes:

1. The referencing database of foreign keys were not properly transferred to files.
2. 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. Connection name is now shown in the title bar of Console window.

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. HTTP Tunnel did not work properly when some specific characters appeared in username or password.
2. Failed to prompt for entering HTTP authentication password even password was not saved.
3. MySQL Bit fields were not displayed properly in Console.

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. HTTP Tunnel did not work properly when some specific characters appeared in username or password.
2. Failed to prompt for entering HTTP authentication password even password was not saved.
3. MySQL Bit fields were not displayed properly in Console.
4. Newline characters were imported improperly into PostgreSQL text fields.
5. Data Synchronization did not work for SQLite databases.

Upgrade Procedure : click here to upgrade

1. HTTP Tunnel did not work properly when some specific characters appeared in username or password.
2. Failed to prompt for entering HTTP authentication password even password was not saved.
3. Newline characters were imported improperly into PostgreSQL text fields.

Upgrade Procedure : click here to upgrade

1. HTTP Tunnel did not work properly when some specific characters appeared in username or password.
2. Failed to prompt for entering HTTP authentication password even password was not saved.
3. Data Synchronization did not work for SQLite databases.

Upgrade Procedure : click here to upgrade

1. Structure Synchronization will now not compare MySQL table comment.

Bug Fixes:

1. Auto-reconnection did not work on SSH tunnel connection to MySQL server.
2. Fixed the unicode display problem on Text field with MySQL 4.0 or below.
3. Beautify SQL would cause error if extra spaces existed in aggregate function.
4. Fixed error when importig XML files from the Interent.
5. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
6. "Access Violation" error occured in Manage User when MySQL user did not have enough privilege.
7. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

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.
2. Structure Synchronization will now not compare MySQL table comment.

Bug Fixes:

1. Auto-reconnection did not work on SSH tunnel connection to MySQL server.
2. Fixed the unicode display problem on Text field with MySQL 4.0 or below.
3. Beautify SQL would cause error if extra spaces existed in aggregate function.
4. Fixed error when importig XML files from the Interent.
5. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
6. "Access Violation" error occured in Manage User when MySQL user did not have enough privilege.
7. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

Upgrade Procedure : click here to upgrade

1. Structure Synchronization will now not compare MySQL table comment.

Bug Fixes:

1. Auto-reconnection did not work on SSH tunnel connection to MySQL server.
2. Fixed the unicode display problem on Text field with MySQL 4.0 or below.
3. Beautify SQL would cause error if extra spaces existed in aggregate function.
4. Fixed error when importig XML files from the Interent.
5. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
6. "Access Violation" error occured in Manage User when MySQL user did not have enough privilege.
7. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

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. 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. libcurl.dll library updated.
2. Structure Synchronization will now not compare MySQL table comment.

Bug Fixes:

1. Auto-reconnection did not work on SSH tunnel connection to MySQL server.
2. Fixed the unicode display problem on Text field with MySQL 4.0 or below.
3. Beautify SQL would cause error if extra spaces existed in aggregate function.
4. Fixed error when importig XML files from the Interent.
5. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
6. "Access Violation" error occured in Manage User when MySQL user did not have enough privilege.
7. "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. 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. Failed to transfer Foreign Key to target server if the target database name was different to the source database name.
2. Memory allocation problem which may cause Navicat to crash when transferring data using Data Transfer.
3. Incorrect values were synchronized during Data Synchronization.
4. Crashed easily when running queries in Query Viewer.

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. Show the host information under Connection Information view.

Bug Fixes:

1. Failed to transfer MySQL Foreign Key to target server if the target database name was different to the source database name.
2. Memory allocation problem which may cause Navicat to crash when transferring data using Data Transfer.
3. Incorrect values were synchronized during Data Synchronization.
4. Crashed easily when running queries in Query Viewer.

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. 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. "700 - Invalid response: 417" error occured when connecting to server over HTTP Tunnel.
2. "Duplicate name 'Field11' in TFieldDefs" error occured if a table contained more than 11 fields in which the first ten field names include "Field1".
3. Tab order in Import Wizard was set up incorrectly.

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. "700 - Invalid response: 417" error occured when connecting to server over HTTP Tunnel.
2. Each SQLite field was limited to 65536 bytes.
3. "Duplicate name 'Field11' in TFieldDefs" error occured if a table contained more than 11 fields in which the first ten field names include "Field1".
4. Tab order in Import Wizard was set up incorrectly.

Upgrade Procedure : click here to upgrade

1. "700 - Invalid response: 417" error occured when connecting to server over HTTP Tunnel.
2. "Duplicate name 'Field11' in TFieldDefs" error occured if a table contained more than 11 fields in which the first ten field names include "Field1".
3. Tab order in Import Wizard was set up incorrectly.

Upgrade Procedure : click here to upgrade

1. "700 - Invalid response: 417" error occured when connecting to server over HTTP Tunnel.
2. Each field was limited to 65536 bytes.
3. "Duplicate name 'Field11' in TFieldDefs" error occured if a table contained more than 11 fields in which the first ten field names include "Field1".
4. Tab order in Import Wizard was set up incorrectly.

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. Individual database objects backup.
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. Import/Export connection.
2. Significant Improvements made in code/word completion.
3. Code Folding.
4. Matched Brace/Bracket Highlighting.
5. Parameter Tips.
6. Zoom In/Out for SQL editors.
7. SQL Beautifier.
8. Favorites.
9. Object Filter.
10. Individual database objects backup.
11. Auto save in Query, Function etc.
12. Custom sort in Tabler Viewer.
13. Significant Improvements made in editor and data grid searching.
14. Notification email supports SSL/TLS in Schedule.
15. History Log Viewer.

Upgrade Procedure : click here to upgrade

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

Upgrade Procedure : click here to upgrade

Common SQLite support:

1. Work with SQLite 2 and SQLite 3.
2. Support of all SQLite objects and subobjects
3. Support of character set and unicode.

Connection Management:

1. Multiple local/remote SQLite server connections.
2. Connection to SQLite database through HTTP.
3. Import/Export connections settings.

Well-designed user interface:

1. Virtual Grouping for connections and objects.
2. Customize of connection order.
3. Grid View and Form View support.
4. Well-described Wizard System.
5. Provide well-vision for users in table grid.
6. Support dock windows.

Powerful data management tool:

1. Foreign Key Data Selection.
2. Supports Parameter Query.
3. Import and Export support.
4. Data Transfer support.
5. Data Synchronization support.
6. Support of Backup and Restore.

Visual Designer:

1. Support Code-Completion in SQL editors.
2. Support Views in Query Builder.
3. Support of Views Builder.
4. Support SQL Previewer.

Additional features:

1. Print Schema / Table Structure.
2. Support of setting global Row Height and Column Width in table grid.
3. Support of Word Wrap.
4. Provides a short-cut to terminate a running query.
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. Auto save in Query, Function etc.
13. Custom sort in Tabler Viewer.
14. Notification email supports SSL/TLS in Schedule.
15. History Log Viewer.

Download here

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. 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. 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. 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. 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.
4. Wrong bit field default values were displayed in Table Designer for MySQL version 5.1.31 or above.

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. Support encrypted SQLite file (wxSQLite3).
2. Support to browse SQLite library path.
3. SQLite Console now uses Navicat's console instead of using the SQLite binary.
4. SQLite Transaction is now used when changing some existing object, preventing accidental dropping of objects.
5. If the row is selected, Filter Wizard will now display the words in white color.
6. 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.
4. Wrong bit field default values were displayed in Table Designer for MySQL version 5.1.31 or above.

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. Support encrypted SQLite file (wxSQLite3).
2. Support to browse SQLite library path.
3. SQLite Console now uses Navicat's console instead of using the SQLite binary.
4. SQLite Transaction is now used when changing some existing object, preventing accidental dropping of objects.
5. If the row is selected, Filter Wizard will now display the words in white color.
6. 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. "1054 unknown column error" occured when updating or inserting a record in MySQL View that has Alias names in the Select statement.
3. The automatic word wrap in TEXT fields not working properly in Form View.
4. "Navicat is not able to prase SQL" error occured in Query Editor.
5. Navicat freezed when applying "Beautify SQL" on some 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. Support encrypted SQLite file (wxSQLite3).
2. Improved smart quote identifier for SQLite.
3. Improved virtual grouping rename issue - e.g. group like "ITem" and it didn't allow to change into "Item".
4. Changed to use Ctrl+MouseWheel instead of LeftClick+MouseWheel for zoom in/out function in Query Editor.
5. Query Builder is now able to handle incomplete SQL statement when switching between Query Editor and Query Builder.
6. SELECT clause is now able to be generated when dragging a table to Query Builder without selecting any columns, and switching to Query Editor.
7. Improved export data to excel spreadsheet - number/float data is now being export to number format instead of string format.
8. Widen the width of the saved profiles list under Data Transfer and Data/Structure Synchronization windows.
9. 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. "1054 unknown column error" occured when updating or inserting a record in MySQL View that has Alias names in the Select statement.
3. The automatic word wrap in TEXT fields not working properly in Form View.
4. "Navicat is not able to prase SQL" error occured in Query Editor.
5. Navicat freezed when applying "Beautify SQL" on some 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. Support encrypted SQLite file (wxSQLite3).
2. Improved smart quote identifier for SQLite.
3. Improved virtual grouping rename issue - e.g. group like "ITem" and it didn't allow to change into "Item".
4. Changed to use Ctrl+MouseWheel instead of LeftClick+MouseWheel for zoom in/out function in Query Editor.
5. Query Builder is now able to handle incomplete SQL statement when switching between Query Editor and Query Builder.
6. SELECT clause is now able to be generated when dragging a table to Query Builder without selecting any columns, and switching to Query Editor.
7. Improved export data to excel spreadsheet - number/float data is now being export to number format instead of string format.
8. Widen the width of the saved profiles list under Data Transfer and Data/Structure Synchronization windows.

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. Wrong Bit field default value got from MySQL Server 5.1.30 or below.

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. Wrong Bit field default value got from MySQL Server 5.1.30 or below.
2. Crashed when importing to Oracle Server with comma as decimal separator during Import Wizard.

Upgrade Procedure : click here to upgrade

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

Upgrade Procedure : click here to upgrade

1. When unchecked MySQL "Include other table options" in Data Transfer, engine/table type, character set, auto increment settings were not transferred properly.
2. The font size used in Query grid was smaller than in View grid.
3. "Set Display Format" option in Table Viewer did not work in numerical field.
4. Fixed the wrong positioning issue of main menu items.
5. MySQL character set/collation type issue in Query Builder or View Builder.

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 Java and XML syntax highlighting for Oracle.
2. Support Cancel action in copying SQLite objects, table and query.

Bug Fixes:

1. When unchecked MySQL "Include other table options" in Data Transfer, engine/table type, character set, auto increment settings were not transferred properly.
2. The font size used in Query grid was smaller than in View grid.
3. "Set Display Format" option in Table Viewer did not work in numerical field.
4. Fixed the wrong positioning issue of main menu items.
5. MySQL character set/collation type issue in Query Builder or View Builder.

Upgrade Procedure : click here to upgrade

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. Support Cancel action in copying SQLite objects, table and query.

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.

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. 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. 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.

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.

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. Error would occur when switching between Query Editor and Query Builder with MySQL INTERVAL clause included.
8. "Access violation" error occured for code/word completion feature.

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. 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. "Access violation" error occured in Foreign Key Data Selection feature if SQLite reference table did not exist.
5. Fixed the column width of SQLite Foreign Key Data Selection window.
6. "Not enough storage is available to complete this operation" error occured when exporting field values start with "=" to Excel file.
7. Fixed the drag & drop problem on Select, Where, Group By, Having, Order By, Limit regions in Query Builder.
8. 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.
9. Error would occur when switching between Query Editor and Query Builder with MySQL INTERVAL clause included.
10. Fixed GUI problem when opened Edit -> Options in SQLite Table Designer.
11. "Access violation" error occured for code/word completion feature.

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. 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 in Foreign Key Data Selection feature if SQLite reference table did not exist.
4. Fixed the column width of SQLite Foreign Key Data Selection window.
5. Schedule profile could not be loaded in main window.
6. "Not enough storage is available to complete this operation" error occured when exporting field values start with "=" to Excel file.
7. Fixed the drag & drop problem on Select, Where, Group By, Having, Order By, Limit regions in Query Builder.
8. 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.
9. Fixed GUI problem when opened Edit -> Options in SQLite Table Designer.
10. "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.

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. 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. 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 for Oracle version.
6. In Oracle Code Outline, included parameters in the list under proc/func in simple view.
7. In Oracle Code Outline, showed parameters in the label of proc/func in detail view.
8. Added button to choose sorting option in Oracle 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. SQLite table could not be duplicated if the table name was quoted by `` or [] in the ddl of that table.
4. Some SQL statements would cause Navicat crashed when switching to Query Builder.

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.

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. 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.

Bug Fixes:

1. Dragging images into Image Editor were converted to tiff format.
2. "Format" menu flashed frequently on Mac 10.5.
3. Table could not be duplicated if the table name was quoted by ` ` or [ ] in the ddl of that table.
4. 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. Improved keywords list for Code/Word Completion.
4. Attached hot keys to the navigation bar in Table Viewer.

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. Incompleted Stored Procedure SQL statement showed in Stored Procedure Designer.
4. When sweithed between Query Builder ad Query Editor, ";" would be inserted into the middle of the statement.
5. Auto-increment and character set would not be transtered during Data Transfer function.
6. "Select All" and "UnSelect All" buttons missing in Data Synchronization window.

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. 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 Oracle Code Outline, supports parameter as node for simple view.
7. In Oracle 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. Incompleted MySQL Stored Procedure SQL statement showed in Stored Procedure Designer.
5. When sweithed between Query Builder ad Query Editor, ";" would be inserted into the middle of the statement.
6. MySQL auto-increment and character set would not be transtered during Data Transfer function.
7. "Select All" and "UnSelect All" buttons missing in Data Synchronization window.

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. Improved keywords list for Code/Word Completion.
4. Attached hot keys to the navigation bar in Table Viewer.

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. When sweithed between Query Builder ad Query Editor, ";" would be inserted into the middle of the statement.
4. "Select All" and "UnSelect All" buttons missing in Data Synchronization window.

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. Improved keywords list for Code/Word Completion.
4. Attached hot keys to the navigation bar in Table Viewer.

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. When sweithed between Query Builder ad Query Editor, ";" would be inserted into the middle of the statement.
4. "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. MySQL Event status shown incorrectly in Detail View/Information View.
3. Hangged when executing some SQL file using Execute SQL File function in Mac 10.6.

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. Crashed when comparing non-ascii table name during Structure Synchronization.
2. MySQL Event status shown incorrectly in Detail View/Information View.
3. Failed to support the case that second is omitted in Oracle Import Wizard (e.g. "YYYY-MM-DD HH:MM").
4. Failed to handle Oracle Environmental Path with spaces.
5. Hangged when executing some SQL file using Execute SQL File function in Mac 10.6.

Upgrade Procedure : click here to upgrade

1. Crashed when comparing non-ascii table name during Structure Synchronization.
2. Hangged when executing some SQL file using Execute SQL File function in Mac 10.6.

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

Upgrade Procedure : click here to upgrade

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

Upgrade Procedure : click here to upgrade

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

Upgrade Procedure : click here to upgrade

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

Upgrade Procedure : click here to upgrade

Common SQLite support:

1. Work with SQLite 2 and SQLite 3.
2. Support of all SQLite objects and subobjects
3. Support of character set and unicode.

Connection Management:

1. Multiple local/remote SQLite server connections.
2. Connection to SQLite database through HTTP.
3. Import/Export connections settings.

Well-designed user interface:

1. Virtual Grouping for connections and objects.
2. Customize of connection order.
3. Grid View and Form View support.
4. Well-described Wizard System.
5. Provide well-vision for users in table grid.
6. Support dock windows.

Powerful data management tool:

1. Foreign Key Data Selection.
2. Supports Parameter Query.
3. Import and Export support.
4. Data Transfer support.
5. Data Synchronization support.
6. Support of Backup and Restore.

Visual Designer:

1. Support Code-Completion in SQL editors.
2. Support Views in Query Builder.
3. Support of Views Builder.
4. Support SQL Previewer.

Additional features:

1. Print Schema / Table Structure.
2. Support of setting global Row Height and Column Width in table grid.
3. Support of Word Wrap.
4. Provides a short-cut to terminate a running query.
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. Notification email supports SSL/TLS in Schedule.
16. History Log Viewer.

Download here

Common SQLite support:

1. Work with SQLite 2 and SQLite 3.
2. Support of all SQLite objects and subobjects
3. Support of character set and unicode.

Connection Management:

1. Multiple local/remote SQLite server connections.
2. Connection to SQLite database through HTTP.
3. Import/Export connections settings.

Well-designed user interface:

1. Virtual Grouping for connections and objects.
2. Customize of connection order.
3. Grid View and Form View support.
4. Well-described Wizard System.
5. Provide well-vision for users in table grid.
6. Support dock windows.

Powerful data management tool:

1. Foreign Key Data Selection.
2. Supports Parameter Query.
3. Import and Export support.
4. Data Transfer support.
5. Data Synchronization support.
6. Support of Backup and Restore.

Visual Designer:

1. Support Code-Completion in SQL editors.
2. Support Views in Query Builder.
3. Support of Views Builder.
4. Support SQL Previewer.

Additional features:

1. Print Schema / Table Structure.
2. Support of setting global Row Height and Column Width in table grid.
3. Support of Word Wrap.
4. Provides a short-cut to terminate a running query.
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. Notification email supports SSL/TLS in Schedule.
16. History Log Viewer.

Download here

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. 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. 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.
4. Failed to create PostgreSQL index on fields using names with reserved word in Table Designer.

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.
4. Failed to create PostgreSQL index on fields using names with reserved word in Table Designer.

Upgrade Procedure : click here to upgrade

In Table Viewer, MySQL Limit clause will now exclude from the Update/Delete statement if primary key does not exist.

Bug Fixes:

1. Collations could not be changed for MySQL 4.1.
2. When altered MySQL View definer, wrong quoting applied.
3. Word Wrap status did not save in the Query Editor.
4. "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
5. When import from ODBC with empty tables, "BOF/EOF access" error would occur.
6. 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

In Table Viewer, MySQL Limit clause will now exclude from the Update/Delete statement if primary key does not exist.

Bug Fixes:

1. Collations could not be changed for MySQL 4.1.
2. When altered MySQL View definer, wrong quoting applied.
3. When altered Function (PostgreSQL 8.0 or before), all its parameters would be lost after saved.
4. When running backup for PostgreSQL database, duplicate/missing records would happen.
5. "ORA-00932" error occured when opening Oracle 9i table, which contained FLOAT type, in Table Viewer.
6. Word Wrap status did not save in the Query Editor.
7. "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
8. When import from ODBC with empty tables, "BOF/EOF access" error would occur.
9. Error dialog occured when selecting target connection in Data Transfer.

Upgrade Procedure : click here to upgrade

1. When altered Function (PostgreSQL 8.0 or before), all its parameters would be lost after saved.
2. When running backup for PostgreSQL database, duplicate/missing records would happen.
3. Word Wrap status did not save in the Query Editor.
4. "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
5. When import from ODBC with empty tables, "BOF/EOF access" error would occur.
6. Error dialog occured when selecting target connection in Data Transfer.

Upgrade Procedure : click here to upgrade

1. When altered Function (PostgreSQL 8.0 or before), all its parameters would be lost after saved.
2. When running backup for PostgreSQL database, duplicate/missing records would happen.
3. Word Wrap status did not save in the Query Editor.
4. "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
5. When import from ODBC with empty tables, "BOF/EOF access" error would occur.
6. Error dialog occured when selecting target connection in Data Transfer.

Upgrade Procedure : click here to upgrade

In Table Viewer, MySQL Limit clause will now exclude from the Update/Delete statement if primary key does not exist.

Bug Fixes:

1. Collations could not be changed for MySQL 4.1.
2. When altered MySQL View definer, wrong quoting applied.
3. When altered Function (PostgreSQL 8.0 or before), all its parameters would be lost after saved.
4. When running backup for PostgreSQL database, duplicate/missing records would happen.
5. "ORA-00932" error occured when opening Oracle 9i table, which contained FLOAT type, in Table Viewer.
6. Word Wrap status did not save in the Query Editor.
7. "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
8. When import from ODBC with empty tables, "BOF/EOF access" error would occur.
9. 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

In Table Viewer, MySQL Limit clause will now exclude from the Update/Delete statement if primary key does not exist.

Bug Fixes:

1. Collations could not be changed for MySQL 4.1.
2. When altered MySQL View definer, wrong quoting applied.
3. Word Wrap status did not save in the Query Editor.
4. "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
5. When import from ODBC with empty tables, "BOF/EOF access" error would occur.
6. Error dialog occured when selecting target connection in Data Transfer.

Upgrade Procedure : click here to upgrade

1. Improved the compatibility in MySQL SSL connection.
2. Improved the support of bigger data in each cell of Excel file during Export Wizard.
3. 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. 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. Improved the compatibility in MySQL SSL connection.
2. Improved the support of bigger data in each cell of Excel file during Export Wizard.
3. 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. 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. Failed to establish MySQL SSL connection.
3. Form View would crash when editing with no row selected.
4. Wrong linkage was shown for field name with capital letters in Query Builder.

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. Connections were not freed before quitting Navicat.
2. Failed to establish MySQL SSL connection.
3. Form View would crash when editing with no row selected.
4. Timestamp field properties text box was not shown in Oracle Table Designer.
5. Data were uneditable in Oracle Form View.
6. Improper Ctrl-click menu would be displayed in Table Viewer.
7. Wrong linkage was shown for field name with capital letters in Query Builder.

Upgrade Procedure : click here to upgrade

1. Connections were not freed before quitting Navicat.
2. Form View would crash when editing with no row selected.
3. 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. 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. 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. 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. If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.

Bug Fixes:

1. When using MySQL HTTP Tunnel connection and user tried to add/duplicate an user. After pressing OK to close the user form, Navicat would sometimes causes "Access Violation" error.
2. When altered a MySQL data type that contains unsigned/zerofill properties into BIT type, table could not be saved in Table Designer.
3. BIT type default value could not be handled properly in some MySQL server.
4. "1055" errod occured when running MySQL queries after the SQL mode was set into 'TRADITIONAL,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO'.
5. "1045 - Access denied" error occured when a target server was not selected during MySQL Data Transfer.
6. Events and Sequences could not shown under Object Selection tab in Restore form.

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. If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.

Bug Fixes:

1. When using MySQL HTTP Tunnel connection and user tried to add/duplicate an user. After pressing OK to close the user form, Navicat would sometimes causes "Access Violation" error.
2. When altered a MySQL data type that contains unsigned/zerofill properties into BIT type, table could not be saved in Table Designer.
3. BIT type default value could not be handled properly in some MySQL server.
4. When set the DEFAULT NULL property in PostgreSQL table, Navicat used "SET DEFAULT NULL" rather than "DROP DEFAULT"
5. "1045 - Access denied" error occured when a target server was not selected during MySQL Data Transfer.
6. "1055" errod occured when running MySQL queries after the SQL mode was set into 'TRADITIONAL,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO'.
7. "Append/Update" mode did not work properly in Import Wizard.
8. Sequence checkbox status and counter did not work properly in Oracle and PostgreSQL Data Transfer.
9. PostgreSQL SQL statement - "select * from table" would return result set in unexpected order, so that Data Transfer and Export functions would return incorrect result.
10. Events and Sequences could not shown under Object Selection tab in MySQL and PostgreSQL Restore form.

Upgrade Procedure : click here to upgrade

1. When set the DEFAULT NULL property in PostgreSQL table, Navicat used "SET DEFAULT NULL" rather than "DROP DEFAULT"
2. Sequence checkbox status and counter did not work properly in Data Transfer.
3. "select * from table" would return result set in unexpected order, so that Data Transfer and Export functions would return incorrect result.
4. Events and Sequences could not shown under Object Selection tab in Restore form.

Upgrade Procedure : click here to upgrade

1. If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.

Bug Fixes:

1. Connection Name in Connection Properties sometime would show empty value.
2. When using MySQL HTTP Tunnel connection and user tried to add/duplicate an user. After pressing OK to close the user form, Navicat would sometimes causes "Access Violation" error.
3. When altered a MySQL data type that contains unsigned/zerofill properties into BIT type, table could not be saved in Table Designer.
4. BIT type default value could not be handled properly in some MySQL server.
5. "1055" errod occured when running MySQL queries after the SQL mode was set into 'TRADITIONAL,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO'.
6. "1045 - Access denied" error occured when a target server was not selected during MySQL Data Transfer.
7. Events and Sequences could not shown under Object Selection tab in Restore form.

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. If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.

Bug Fixes:

1. Connection Name in Connection Properties sometime would show empty value.
2. When using MySQL HTTP Tunnel connection and user tried to add/duplicate an user. After pressing OK to close the user form, Navicat would sometimes causes "Access Violation" error.
3. When altered a MySQL data type that contains unsigned/zerofill properties into BIT type, table could not be saved in Table Designer.
4. BIT type default value could not be handled properly in some MySQL server.
5. When set the DEFAULT NULL property in PostgreSQL table, Navicat used "SET DEFAULT NULL" rather than "DROP DEFAULT"
6. "1045 - Access denied" error occured when a target server was not selected during MySQL Data Transfer.
7. "1055" errod occured when running MySQL queries after the SQL mode was set into 'TRADITIONAL,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO'.
8. "Append/Update" mode did not work properly in Import Wizard.
9. Sequence checkbox status and counter did not work properly in Oracle and PostgreSQL Data Transfer.
10. PostgreSQL SQL statement - "select * from table" would return result set in unexpected order, so that Data Transfer and Export functions would return incorrect result.
11. Events and Sequences could not shown under Object Selection tab in MySQL and PostgreSQL Restore form.

Upgrade Procedure : click here to upgrade

1. Connection Name in Connection Properties sometime would show empty value.
2. When set the DEFAULT NULL property in PostgreSQL table, Navicat used "SET DEFAULT NULL" rather than "DROP DEFAULT"
3. Sequence checkbox status and counter did not work properly in Data Transfer.
4. "select * from table" would return result set in unexpected order, so that Data Transfer and Export functions would return incorrect result.
5. Events and Sequences could not shown under Object Selection tab in Restore form.

Upgrade Procedure : click here to upgrade

1. MySQL Triggers will now include in Dump SQL file.
2. 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.
2. Failed to list MySQL Views in Manage User window.
3. MySQL Table Viewer would crash after added a row without changing its value.
4. Crashed when saving views with name in capital letter on MySQL server with lower_case_table_names variable not equal to 0.
5. MySQL syntax error occurred when creating tables with foreign key in Table Designer.

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. MySQL Triggers will now include in Dump SQL file.
2. 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.
2. Failed to list MySQL Views in Manage User window.
3. MySQL Table Viewer would crash after added a row without changing its value.
4. Crashed when saving views with name in capital letter on MySQL server with lower_case_table_names variable not equal to 0.
5. MySQL syntax error occurred when creating tables with foreign key in Table Designer.
6. Failed to connect to PostgreSQL server on "localhost" but without socket file.

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.
2. Failed to connect to PostgreSQL server on "localhost" but without socket file.

Upgrade Procedure : click here to upgrade

1. Failed to change the definition of an existing MySQL Foreign Key in Table Designer.
2. The SQL statement to create foreign key mistakenly included the name of source database in MySQL Structure Synchronization.
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. 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. Failed to change the definition of an existing MySQL Foreign Key in Table Designer.
2. The SQL statement to create foreign key mistakenly included the name of source database in MySQL Structure Synchronization.
3. When launched Oracle Console, Terminal window would popup twice.
4. Some data would be truncated when getting data from Oracle server.
5. When created PostgreSQL database, privileges could not be set at the same time.
6. Data Transfer, Data Synchronization and Structure Synchronization Profiles selection box would display improperly if Toolbar Appearance was set as "Text Only".
7. Navicat Import Wizard was unable to recognize some xml attributes properly.
8. When modified Index in Table Designer, Some changes could not be recognized.
9. Failed to display the referencing table list when editing existing Foreign Key in Table Designer.
10. The first record could not be selected in Table Form View under Mac OS 10.6.
11. Navicat crashed if the network drive could not be found during the Backup process.

Upgrade Procedure : click here to upgrade

1. When created PostgreSQL database, privileges could not be set at the same time.
2. Data Transfer, Data Synchronization and Structure Synchronization Profiles selection box would display improperly if Toolbar Appearance was set as "Text Only".
3. Navicat Import Wizard was unable to recognize some xml attributes properly.
4. When modified Index in Table Designer, Some changes could not be recognized.
5. Failed to display the referencing table list when editing existing Foreign Key in Table Designer.
6. The first record could not be selected in Table Form View under Mac OS 10.6.
7. 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. MySQL Auto increment value could not be altered if "Use DDL from SHOW CREATE TABLE" option was disabled with "Include Auto Increment" option being checked in Data Transfer.
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. 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. MySQL Auto increment value could not be altered if "Use DDL from SHOW CREATE TABLE" option was disabled with "Include Auto Increment" option being checked in Data Transfer.
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. 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. MySQL Auto increment value could not be altered if "Use DDL from SHOW CREATE TABLE" option was disabled with "Include Auto Increment" option being checked in Data Transfer.
3. Refresh did not work for getting update data.
4. 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. 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. MySQL Auto increment value could not be altered if "Use DDL from SHOW CREATE TABLE" option was disabled with "Include Auto Increment" option being checked in Data Transfer.
3. Refresh did not work for getting update data.
4. 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. The cursor position moved to end-of-line after saved the Stored Procesure/Function.
2. "Access Violation" error occured when getting the Event information from Linux server.
3. Failed to establish SSH connection when the private key path contained unicode.
4. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
5. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
6. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
7. 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. Primary Key were defined improperly under SQL Preview tab in PostgreSQL/Oacle Table Designer.
2. The cursor position moved to end-of-line after saved the Stored Procesure/Function.
3. "Access Violation" error occured when getting the MySQL Event information from Linux server.
4. "'x,x' is not a valid floating point value" error occured when opening an oracle table that contains floats data type together with the regional settings were set to Dutch environment.
5. Failed to establish SSH connection when the private key path contained unicode.
6. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
7. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
8. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
9. 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 Function.
3. Failed to establish SSH connection when the private key path contained unicode.
4. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
5. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
6. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
7. 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. The cursor position moved to end-of-line after saved the Stored Procesure/Function.
2. "Access Violation" error occured when getting the Event information from Linux server.
3. Failed to establish SSH connection when the private key path contained unicode.
4. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
5. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
6. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
7. 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. Primary Key were defined improperly under SQL Preview tab in PostgreSQL/Oacle Table Designer.
2. The cursor position moved to end-of-line after saved the Stored Procesure/Function.
3. "Access Violation" error occured when getting the MySQL Event information from Linux server.
4. "'x,x' is not a valid floating point value" error occured when opening an oracle table that contains floats data type together with the regional settings were set to Dutch environment.
5. Failed to establish SSH connection when the private key path contained unicode.
6. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
7. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
8. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
9. 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 Function.
3. Failed to establish SSH connection when the private key path contained unicode.
4. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
5. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
6. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
7. 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. Incorrect use of hexadecimal format in MySQL data types other than BLOB in Data Transfer.
2. Data grid was unable to be opened properly when some kind of text were displayed.
3. Removed some internal SQL run by Navicat in Query Viewer.
4. 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. 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. Improved compatibility to some ODBC drivers for Import Wizard.

Bug Fixes:

1. Incorrect use of hexadecimal format in MySQL data types other than BLOB in Data Transfer.
2. Data grid was unable to be opened properly when some kind of text were displayed.
3. Removed some internal SQL run by Navicat in Query Viewer.
4. 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. 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. "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

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. "Class TSciMemo not found" error occured when opening PostgreSQL Aggregate Designer.
2. Data could not be updated/added in Table Viewer when using HTTP Tunnel connection to PostgreSQL server.
3. "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

1. "Class TSciMemo not found" error occured when opening PostgreSQL Aggregate Designer.
2. Data could not be updated/added in Table Viewer when using HTTP Tunnel connection to PostgreSQL server.
3. "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

1. "Class TSciMemo not found" error occured when opening PostgreSQL Aggregate Designer.
2. Data could not be updated/added in Table Viewer when using HTTP Tunnel connection to PostgreSQL server.
3. "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

1. "Class TSciMemo not found" error occured when opening PostgreSQL Aggregate Designer.
2. Data could not be updated/added in Table Viewer when using HTTP Tunnel connection to PostgreSQL server.
3. "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

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. "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

1. "Exceed package size..." error will now occur to remind you to enlarge the max_allowed_packet variable if the records larger than the maximum packet size setting when running Data Synchronisation for MySQl server.
2. Report Builder now accepts datetime function for MySQL server.

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. BLOB data in text file was unable to import successfully.
3. When added a new field (without labelling its name) in MySQL server usng Table Designer, then click the Move Up button. The last field in the table would be disappeared.
4. "List index out of bound" error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function.
5. "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. "Exceed package size..." error will now occur to remind you to enlarge the max_allowed_packet variable if the records larger than the maximum packet size setting when running Data Synchronisation for MySQl server.
2. Report Builder now accepts datetime function for MySQL server.
3. PostgreSQL "bytea" data type will now being exported as E'...' in text-base file.

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. BLOB data in text file was unable to import successfully for MySQL and PostgreSQL servers.
3. SQL statements exported from Export Wizard was exported incorrectly.
4. When added a new field (without labelling its name) in MySQL server usng Table Designer, then click the Move Up button. The last field in the table would be disappeared.
5. "List index out of bound" error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function.
6. Crashed when running "SELECT ctid FROM table" in PostgreSQL server.
7. "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.
2. PostgreSQL "bytea" data type will now being exported as E'...' in text-base file.

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. BLOB data in text file was unable to import successfully.
3. Crashed when running "SELECT ctid FROM table" in PostgreSQL server.
4. "Access Violation" error occured when exporting data to Access file if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

1. "Exceed package size..." error will now occur to remind you to enlarge the max_allowed_packet variable if the records larger than the maximum packet size setting when running Data Synchronisation for MySQl server.

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. BLOB data in text file was unable to import successfully.
3. When added a new field (without labelling its name) in MySQL server usng Table Designer, then click the Move Up button. The last field in the table would be disappeared.
4. "List index out of bound" error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function.
5. "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. "Exceed package size..." error will now occur to remind you to enlarge the max_allowed_packet variable if the records larger than the maximum packet size setting when running Data Synchronisation for MySQl server.
2. PostgreSQL "bytea" data type will now being exported as E'...' in text-base file.

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. BLOB data in text file was unable to import successfully for MySQL and PostgreSQLservers.
3. SQL statements exported from Export Wizard was exported incorrectly.
4. When added a new field (without labelling its name) in MySQL server usng Table Designer, then click the Move Up button. The last field in the table would be disappeared.
5. "List index out of bound" error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function.
6. Crashed when running "SELECT ctid FROM table" in PostgreSQL server.
7. "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.
2. PostgreSQL "bytea" data type will now being exported as E'...' in text-base file.

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. BLOB data in text file was unable to import successfully.
3. Crashed when running "SELECT ctid FROM table" in PostgreSQL server.
4. "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.
2. Text fields are now imported with text data instead of hex to prevent potential encoding problems which may occur for MySQL server.

Bug Fixes:

1. When set Foreign Keys in MySQL Table Designer, foreign key info could not be displayed properly if the Reference Database field included dot character.
2. Foreign Key Data Selection window was unable to show Text field data, it showed [TEXT] instead.
3. When set criteria using BETWEEN keyword in Filter Wizard, error message would occur.
4. Crashed when running sql in MySQL 4.1.14.

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. Export Wizard is now able to export data filering result.
2. Text fields are now imported with text data instead of hex to prevent potential encoding problems which may occur for MySQL server.

Bug Fixes:

1. Foreign Key Data Selection window was unable to show Text field data, it showed [TEXT] instead.
2. When set Foreign Keys in MySQL Table Designer, foreign key info could not be displayed properly if the Reference Database field included dot character.
3. Crashed when saving changes to PostgreSQL Triiger Function.
4. SQL*Plus was unable to activate if the paths under Environments tab in Preferences contained spaces.
5. When set criteria using BETWEEN keyword in Filter Wizard, error message would occur.
6. Crashed when running sql in MySQL 4.1.14.

Upgrade Procedure : click here to upgrade

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

Bug Fixes:

1. Crashed when saving changes to PostgreSQL Triiger Function.
2. Foreign Key Data Selection window was unable to show Text field data, it showed [TEXT] instead.
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. When applied comma as decimal seperator, Data Synchronization would cause problem.
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. 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. When applied comma as decimal seperator, Data Synchronization would cause problem for MySQL and PostgreSQL server.
2. Date field was not converted correctly when exported to DBF file.
3. An empty field would be displayed if employed EUC_JP as database encoding in PostgreSQL server.
4. Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
5. Docked windows could not show in task bar under Windows 7.
6. 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. When applied comma as decimal seperator, Data Synchronization would cause problem.
2. Date field was not converted correctly when exported to DBF file.
3. An empty field would be displayed if employed EUC_JP as database encoding.
4. Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
5. Docked windows could not show in task bar under Windows 7.
6. 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. When applied comma as decimal seperator, Data Synchronization would cause problem.
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. The Data Synchronization message log will not show server name rather than Host/IP.

Bug Fixes:

1. When applied comma as decimal seperator, Data Synchronization would cause problem.
2. Date field was not converted correctly when exported to DBF file.
3. An empty field would be displayed if employed EUC_JP as database encoding.
4. Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
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. The Data Synchronization message log will not show server name rather than Host/IP.

Bug Fixes:

1. When applied comma as decimal seperator, Data Synchronization would cause problem for MySQL and PostgreSQL server.
2. Date field was not converted correctly when exported to DBF file.
3. An empty field would be displayed if employed EUC_JP as database encoding in PostgreSQL server.
4. Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
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. 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. 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. Compatible with Mac OS X Snow Leopard.
2. Stability improvement on tabbed window.

Bug Fixes:

1. Indexes could not work if user is not superuser.
2. Import Wizard would be launched if the Data format was not properly set.

Upgrade Procedure : click here to upgrade

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

Bug Fixes:

1. Indexes could not work if user is not superuser.
2. Import Wizard would be launched if the Data format was not properly set.

Upgrade Procedure : click here to upgrade

1. Support specify the socket name in Connection for MySQL server.
2. Improve suggestion on target data type and provide a default precision and scale information in Import Wizard.
3. Support export to clipboard.

Bug Fixes:

1. When docking a console window to main window, the wheel of mouse would be no effect.
2. Month calendar Could not fully display in some system.
3. If password did not save in Connection Properties, Dump SQL File would not work propertly.

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 specify the socket name in Connection for MySQL server.
2. Improve suggestion on target data type and provide a default precision and scale information in Import Wizard.
3. Support export to clipboard.

Bug Fixes:

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

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. It was slow to open Table Designer for PostgreSQL server.
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 PostgreSQL Server version 7.3 to 8.3.
2. Support all PostgreSQL objects: tables, views and functions.
3. Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers.
4. Managing tablespace, cast and languages.
5. Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.
6. Support of character set and Unicode.

Connection options:

1. Support of password and public/private key for SSH Tunnel.
2. Support of HTTP Tunnel for MySQL and PostgreSQL Servers.
3. Support SSL secure connection for PostgreSQL 8.4 above.

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. Compatible with any MySQL server version.
2. Support all MySQL objects: tables, views, stored procedures/functions and events.
3. Support all subobjects: fields, indices, foreign keys and triggers.
4. Support of partitioning.
5. Support of Unicode / Character Set.

Latest Oracle versions support:

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.

Latest PostgreSQL versions support:

1. Support PostgreSQL Server version 7.3 to 8.3.
2. Support all PostgreSQL objects: tables, views and functions.
3. Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers.
4. Managing tablespace, cast and languages.
5. Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.
6. Support of character set and Unicode.

Connection options:

1. Support of password and public/private key for SSH Tunnel.
2. Support of HTTP Tunnel for MySQL and PostgreSQL Servers.
3. Support SSL secure connection for PostgreSQL 8.4 above.

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. 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. Compatible with any MySQL server version.
2. Support all MySQL objects: tables, views, stored procedures/functions and events.
3. Support all subobjects: fields, indices, foreign keys and triggers.
4. Support of partitioning.
5. 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. Support quitting the Console window by "exit", "quit" or "\q" command.
2. Improved the stability when running a query.

Bug Fixes:

1. Some windows size and position were not saved after closed.
2. Recalling multi-line history commands in Console were not displayed properly.
3. "Copy to Clipboard" did not show host name.

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. Support quitting the Console window by "exit", "quit" or "\q" command for MySQL server.
2. Support quitting the Console window by "\q" command for PostgreSQL server
3. Improved the stability when running a query.
4. Now owners of objects are not compared or transferred in Structure Synchronization and Data Transfer for PostgreSQL server.
5. Improved an internal SQL which run slowly in PostgreSQL server.

Bug Fixes:

1. Some windows size and position were not saved after closed.
2. Recalling multi-line history commands in Console were not displayed properly in MySQL and PostgreSQL server.
3. "Copy to Clipboard" did not show host name for MySQL and PostgreSQL server.
4. Dump SQL File did not dump the primary key definition for PostgreSQL server.
5. Could not recognize the host by host name for PostgreSQL server.
6. User defined type fields were not showing the type properly in Table Design (for PostgreSQL server only).

Upgrade Procedure : click here to upgrade

1. Support quitting the Console window by "\q" command.
2. Now owners of objects are not compared or transferred in Structure Synchronization and Data Transfer.
3. Improved the stability when running a query.
4. Improved an internal SQL which run slowly in the past.

Bug Fixes:

1. Some windows size and position were not saved after closed.
2. Recalling multi-line history commands in Console were not displayed properly.
3. "Copy to Clipboard" did not show host name.
4. Dump SQL File did not dump the primary key definition.
5. Could not recognize the host by host name.
6. User defined type fields were not showing the type properly in Table Design.

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. Index, constraint and trigger could not be renamed in Table Designer.

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 of UUID for PostgreSQL server 8.3 or above.

Bug Fixes:

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. "permission denied for relation pg_authid" error occured when creating table for ProgreSQL server.
5. Access Violation error happened when creating new table with index.
6. Fixed SQL parsing problem for Oracle version.
7. Index, constraint and trigger could not be renamed in Table Designer.

Upgrade Procedure : click here to upgrade

1. Support of UUID for PostgreSQL server 8.3 or above.

Bug Fixes:

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. "permission denied for relation pg_authid" error occured when creating table for ProgreSQL server.
5. Access Violation error happened when creating new table with index.
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. Support Profile and Status in Query View for MySQL server.
6. Allow setting fonts in Data Grid, and apply Editor Font to View/Edit Text.

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. 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. Support of PostgreSQL server version 8.4.
2. Support choosing server version for SQL to be generated in Data Transfer, support more transfer options.
3. Added connection tree to support batch jobs from different databases.
4. Compatibility and speed improvement in exported excel format.
5. Notification email in batch job is now delivered in MIME format.
6. Allow setting fonts in Data Grid, and apply Editor Font to View/Edit Text.
7. Support Profile and Status in Query View for MySQL server.
8. 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.
5. Field lengths are not synchronized correctly for PostgreSQL server.

Upgrade Procedure : click here to upgrade

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

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.
5. Field lengths are not synchronized correctly for PostgreSQL server.

Upgrade Procedure : click here to upgrade

1. Improved connection alive issue for MySQL server.

Bug Fixes:

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

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 connection alive issue for MySQL server.

Bug Fixes:

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

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. "Not enough timers available" error occured in Structure Synchronization.
5. After saved the query in Query Editor, the cursor returned to the beginning of the script.
6. When tables contained foreigh key, "Duplicate Table" feature would not worked for Navicat for MySQL version.
7. When deleted multi-cell in Table Viewer, Navicat would hang.

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 of SSL for PostgreSQL server 8.4.
2. Improved dual monitor system support.
3. 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. "Keepalive Interval" did not work for PostgreSQL version.
8. Database/Schema privileges could not be edited for PostgreSQL server.
9. Modified existing Operator Class did not work properly for PostgreSQL server 8.4.
10. Structure Synchronization did not work properly for PostgreSQL server 7.4.
11. When tables contained foreigh key, "Duplicate Table" feature would not worked for Navicat for MySQL version.
12. When deleted multi-cell in Table Viewer, Navicat would hang.

Upgrade Procedure : click here to upgrade

1. Support of SSL for PostgreSQL server 8.4.
2. Improved dual monitor system support.
3. 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. "Keepalive Interval" did not work for PostgreSQL version.
8. Database/Schema privileges could not be edited for PostgreSQL server.
9. Modified existing Operator Class did not work properly for PostgreSQL server 8.4.
10. Structure Synchronization did not work properly for PostgreSQL server 7.4.
11. 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 the column width not saved in Query Result tab.
2. When exporting tables with choosing "None" for Field delimiter into Text file, it now not add #0(null character) as delimiter.

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. 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. Modified the default query limit to 100 for PostgreSQL server to avoid Out of Memory error during the Backup, Data Transfer and Export process.
5. SSH connection did not work properly.
6. Last Character would be chopped when exported data using Export Wizard.

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 the column width not saved in Query Result tab.
2. When exporting tables with choosing "None" for Field delimiter into Text file, it now not add #0(null character) as delimiter.
3. Modified the default query limit to 100 for PostgreSQL server to avoid Out of Memory error during the Backup, Data Transfer and Export process.

Upgrade Procedure : click here to upgrade

1. Ability to duplicate connection.

Bug Fixes:

1. Fixed while changing value in table grid view given "1054 - Unknown column '' in 'field list'" error message using MySQL server version 4.0.x.

Upgrade Procedure : click here to upgrade

1. Ability to duplicate connection.

Bug Fixes:

1. Fixed while changing value in table grid view given "1054 - Unknown column '' in 'field list'" error message using MySQL server version 4.0.x.

Upgrade Procedure : click here to upgrade

1. Ability to duplicate connection.

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. BFile/CFile not being handled.
4. Fixed access violation issue during backup process.
5. Fixed altering the inheritance table, given "syntax error at or near "INHERITS" at..." error message for Navicat PostgreSQL version.

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.

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. Fixed altering the inheritance table, given "syntax error at or near "INHERITS" at..." error message for Navicat PostgreSQL version.

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 execute time for Explain action under Message tab in Query.

Bug Fixes:

1. Navicat will now end to run the routine for Profile/Status if the Query has stopped by user.
2. Fixed access violation issue when deleted table in Query Builder after running the query.

Upgrade Procedure : click here to upgrade

Multi-connections Database Administration tool:

Navicat Premium allows you to perform multiple server administration to MySQL, Oracle and PostgreSQL databases from a single interface. It supports most of the features in MySQL, Oracle and PostgreSQL including:

Latest MySQL versions support

1. Compatible with any MySQL server version.
2. Support all MySQL objects: tables, views, stored procedures/functions and events.
3. Support all subobjects: fields, indices, foreign keys and triggers.
4. Support of partitioning.
5. Support of Unicode / Character Set.

Latest Oracle versions support

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.

Latest PostgreSQL versions support

1. Support PostgreSQL Server version 7.3 to 8.3.
2. Support all PostgreSQL objects: tables, views and functions.
3. Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers.
4. Managing tablespace, cast and languages.
5. Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.
6. Support of character set and Unicode.

Cross-servers Data Manipulation Tools

1. Support of transferring data across various database systems.
2. Ability to transfer data to a text file with designated SQL format.
3. Setting schedule for profiles from different kind of databases.
4. Support of sending notification e-mail and attachment for schedule task.

Connection options

1. Support of password and public/private key for SSH Tunnel.
2. Support of HTTP Tunnel for MySQL and PostgreSQL Servers.
3. Support of Oracle Basic and TNS Connection.
4. Export Registry Record(.reg) via Navicat Premium.

Well-designed user interface

1. Virtual Grouping for connections and objects.
2. Customize of connection order.
3. Data are well-shown in the tree view.
4. Grid View and Form View support.
5. Well-described Wizard System.
6. Support docking windows.

Powerful data management tool

1. Foreign Key Data Selection.
2. Supports Parameter Query.
3. Import and Export support.
4. Data Synchronization support.
5. Structure Synchronization support.
6. Support of Backup and Restore for MySQL and PostgreSQL Servers.
7. Build in MySQL and PostgreSQL Console and Oracle SQL*Plus.
8. dBaseIII memo support in DBF Import Wizard.

Visual Designer

1. Support Code-Completion in SQL editors.
2. Support Views in Query Builder.
3. Support of Views Builder.
4. Support SQL Previewer.

Additional features

1. Print Schema / Table Structure
2. Support of setting global Row Height and Column Width in table grid.
3. Support of Word Wrap.
4. Provides a short-cut to terminate a running query.
5. Manage Users.
6. Server Monitor.

Download here

Multi-connections Database Administration tool:

Navicat Premium allows you to perform multiple server administration to MySQL, Oracle and PostgreSQL databases from a single interface. It supports most of the features in MySQL, Oracle and PostgreSQL including:

Latest MySQL versions support

1. Compatible with any MySQL server version.
2. Support all MySQL objects: tables, views, stored procedures/functions and events.
3. Support all subobjects: fields, indices, foreign keys and triggers.
4. Support of partitioning.
5. Support of Unicode / Character Set.

Latest Oracle versions support

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.

Latest PostgreSQL versions support

1. Support PostgreSQL Server version 7.3 to 8.3.
2. Support all PostgreSQL objects: tables, views and functions.
3. Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers.
4. Managing tablespace, cast and languages.
5. Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.
6. Support of character set and Unicode.

Cross-servers Data Manipulation Tools

1. Support of transferring data across various database systems.
2. Ability to transfer data to a text file with designated SQL format.
3. Setting schedule for profiles from different kind of databases.
4. Support of sending notification e-mail and attachment for schedule task.

Connection options

1. Support of password and public/private key for SSH Tunnel.
2. Support of HTTP Tunnel for MySQL and PostgreSQL Servers.
3. Support of Oracle Basic and TNS Connection.
4. Export Registry Record(.reg) via Navicat Premium.

Well-designed user interface

1. Virtual Grouping for connections and objects.
2. Customize of connection order.
3. Data are well-shown in the tree view.
4. Grid View and Form View support.
5. Well-described Wizard System.
6. Support docking windows.

Powerful data management tool

1. Foreign Key Data Selection.
2. Supports Parameter Query.
3. Import and Export support.
4. Data Synchronization support.
5. Structure Synchronization support.
6. Support of Backup and Restore for MySQL and PostgreSQL Servers.
7. Build in MySQL and PostgreSQL Console and Oracle SQL*Plus.

Visual Designer

1. Support Code-Completion in SQL editors.
2. Support Views in Query Builder.
3. Support of Views Builder.
4. Support SQL Previewer.

Additional features

1. Print Schema / Table Structure
2. Support of setting global Row Height and Column Width in table grid.
3. Manage Users.
4. Server Monitor.

Download here

1. Support of new privileges for PostgreSQL 8.4.
2. Support of "ALTER DATABASE SET TABLESPACE" and "ALTER TABLE SET WITH OIDS" for PostgreSQL 8.4
3. Support of parameter default value in Stored Procedure.
4. Improved stability in Query.
5. Ability to stop while establishing connection to server.
6. Adjusted the default Settings Save Path to "My Documents".
7. Detail View (object attributes) will now being adjusted under View menu.
8. Improved Stored Procedures/Functions Wizard as non-modal form.
9. Adjusted the file size behavior of "Use extended insert statements" when transfering to file.
10. Added execute time for Explain action under Message tab in Query.
11. Support Ctrl+Del shortcut to delete records.

Bug Fixes:

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

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. Fixed file association for Windows Vista and Windows 7.
2. Fixed BINARY and VARBINARY displayed issue in Grid View.
3. When importing dbf/excel file floating values '.' or ',' as decimal separator, Navicat will now try both in order to recognize its proper floating values.
4. Fixed password prompt issue while connecting to server in Data Transfer, Data/Structure Synchronization, Console and Server monitor.
5. Fixed field alias update/insert issue in Query.

Upgrade Procedure : click here to upgrade

1. Improved stability in Query.
2. Ability to stop while establishing connection to server.
3. Adjusted the default Settings Save Path to "My Documents".
4. Detail View (object attributes) will now being adjusted under View menu.
5. Improved Stored Procedures/Functions Wizard as non-modal form.
6. Adjusted the file size behavior of "Use extended insert statements" when transfering to file.
7. Support Ctrl+Del shortcut to delete records.

Bug Fixes:

1. Fixed SSH Tunnel: BigInteger Overflow issue.
2. Fixed the crash issue while doing the seach action in Query results.
3. Fixed VARBINARY and BINARY columns were exported incorrectly.
4. Date became 0 while exporting to Excel.
5. Fixed "show database" privilege problem - avoid to have alert box pop out when user using Navicat.
6. Fixed columns missing while printing reports using schedule in command line.
7. Fixed GUI font size issue in Connection form.
8. Fixed parse set/enum value in Table Designer.
9. Fixed password prompt for Data Transfer, Data/Structure Synchronization.
10. Fixed Virtual Grouping was unable to load.

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

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

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

Navicat new logo design has been launched.

Upgrade Procedure : click here to upgrade

Navicat new logo design has been launched.

Upgrade Procedure : click here to upgrade

1. Added keyboard interactive authentication for SSH.
2. Adjusted the AutoFill from picklist behavior for Grid View.
3. Supported to import Visual Foxpro memo fields to tinytext/blob.

Bug Fixes:

1. Fixed export excel spreadsheet with datetime was set to 0.
2. Fixed Move up/Move Down issue in Table Designer.
3. Fixed ampersand not show in Memo view.
4. Employed the last dataset for report when multi-dataset.
5. No need validate the expiry date while using SSL.

Upgrade Procedure : click here to upgrade

1. Added keyboard interactive authentication for SSH.
2. Adjusted the AutoFill from picklist behavior for Grid View.

Bug Fixes:

1. Fixed export excel spreadsheet with datetime was set to 0.
2. Fixed wrongly treat empty string as null.
3. Fixed access violation when select BLOB/TEXT issue.
4. Disable KeepAliveTimer before executing SQL.

Upgrade Procedure : click here to upgrade

1. Fixed the save problem while pasting field from clipbosrd in Table Designer.
2. Password was wrongly trimmed while using SSH connection.

Upgrade Procedure : click here to upgrade

1. Added Control-click menu on Form View of Table View.

Bug Fixes:

1. Crash when running some custom queries in Query View.
2. Backup failed to restore after renaming.

Upgrade Procedure : click here to upgrade

Major new features:

1. Enhanced support of PostgreSQL versions 7.3 to 8.3.
2. Support of Form View.
3. Support of Code Completion in all SQL Editor.
4. Support of ODBC Import.
5. Support of exporting Excel file.
6. Support of View, Store Procedure, Sequence, etc in Structure Synchronization.
7. Ability to send notification e-mail for schedule task, with an option to attach file output from Export Wizard.
8. Support of creating table, view, import/export profile shortcut on desktop.
9. 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

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

Major new features:

1. Enhanced support of new MySQL server versions.
2. Partitioning support for MySQL 5.1.
3. Support of Show Profile and Status in Query.
4. Support of multi-resultset in Query, Stored Procedure.
5. Ability to attach Export Wizard/Report result files in Batch Job notification email.
6. Support of SQL Preview for all object design forms.
7. More table properties can be adjusted in Table design form.
8. Support Preview and Explain in View Design form.

Other enhancements:

User Interface

1. Object information is now shown in pane inside Navicat main form rather than pop-up modal dialog.
2. Support of drag and drop files (e.g. csv, excel....) to connection tree/table pane, Import Wizard will be launched.
3. Support of drag and drop SQL files to connection tree - Excute SQL Batch Wizard will be launched.
4. Added confirm checkbox when delete system object (e.g. databse mysql, information schema, current user in Manage User).
5. Changed to use "Delete" instead of "OK" in delete confirm dialog.
6. Added "Go to setting save path" in connection tree popup menu.
7. Support shortcut key(Ctrl+Q) to quick launch Query form.
8. Support shortcut key(Ctrl+H) to open history log file.

1. Added Stored Procedure Wizard to generate procedure template.

1. Ability to copy Connection Information into Clipboard.

1. Improved support of Unique, Index, Foreign Key in Access/ODBC.
2. Improved support of auto-increment.

1. Added "Compress Backup" and "Decompress Backup".

1. More options to choose which objects to compare.
2. Improved support of synchronizing auto-increment column.

1. More options to choose for creating table.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

1. Improved speed to open a Query View window.

Bug Fixes:

1. Only one Foreign Key Data Selection button is shown even when multiple Foreign Key fields are found.
2. "Copy to Clipboard" feature crash Navicat if Advanced Connection is set.
3. Slow loading large sql into Query View.
4. Error generating SQL in some cases.
5. Crash when running empty statements.

Upgrade Procedure : click here to upgrade

1. Navicat hung when running Data Transfer in Batch Job.
2. Decimal value cannot be set inside the Parameter edit control in Stored Procedure.
3. Failed to synchronize views in Structure Synchronization.
4. Failed to re-create the original trigger if error occured when saving in Table Designer.
5. The status of Grid View/Form View cannot be saved in Table Viewer.

Upgrade Procedure : click here to upgrade

1. Query Builder failed to work for JOIN statement.
2. Query Explain not working properly.

Upgrade Procedure : click here to upgrade

• Query Builder failed to work for JOIN statement.

Download here

Upgrade Procedure : click here to upgrade

1. Data synchronization does not working properly when synchronizing tables with multiple fields.
2. Cannot alter stored procedures in MySQL server versions below 5.0.20.
3. Some connection info are not displayed in HTTP tunnel connections.
4. Null values are not properly handled in ODBC Import.
5. Error messages cannot be displayed if xml files failed to parse.

Upgrade Procedure : click here to upgrade

1. Failed to export excel files in PPC mac.
2. SQL generated from query builder included database names.
3. Improper length for text fields in Form View.
4. Error when exporting queries which are not yet saved.
5. Failed to display escaped characters in stored procedures.
6. Numbers are imported improperly.

Upgrade Procedure : click here to upgrade

Major new features:

1. Enhanced support of new MySQL server versions.
2. Partitioning support for MySQL 5.1.
3. Support of Form View.
4. Support of Code Completion in all SQL Editor.
5. Support of ODBC Import.
6. Support of exporting Excel file.
7. Support of View, Store Procedure and Event in Structure Synchronization.
8. Ability to send notification e-mail for schedule task, with an option to attach file output from Export Wizard or Data Transfer.
9. Support of creating table, view, import/export profile shortcut on desktop.
10. Support of SQL Preview for all object design forms.
11. More table/column properties can be adjusted in Table design form.

Other enhancements:

User Interface

1. Object information is now shown in pane inside Navicat main form rather than pop-up modal dialog.
2. Support of drag and drop files (e.g. csv, excel....) to connection tree/table pane, Import Wizard will be launched.
3. Support of drag and drop SQL files to connection tree - Excute SQL Batch Wizard will be launched.
4. Tabs are scrollable, having a button on the right side to select the tab.
5. "Comment" is now shown in a separated tab for all object design forms.
6. Support of setting font styles for object lists and editors.
7. More shortcut keys are supported.

1. Added Data Time control in Table Viewer.
2. Added "Definer" property in Event.
3. Added control for setting Stored Procedure parameters and return types.

1. Added Rename and Duplicate connection.
2. Ability to copy Connection Information into Clipboard.

1. Line breaks support for CSV and Text Import.
2. Improved recognition accuracy for XML file.
3. Unlimited import record sizes supported.

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. Added option to disable Foreign Key checking.

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.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Major new features:

1. Support of PostgreSQL version 7.3 to 8.3.
2. Support of keeping Navicat connections alive.
3. Object Dependency Relationships shown in "Using" and "Used By" tab under Object Information pane.
4. Support of Tablespace object list.
5. Support of SQL Preview for all object design forms.
6. Virtual Grouping is now supported for Tables, Views, Functions, Queries, Reports, Backups and Schedules.
7. Support of “Preview” and “Explain” in View.
8. ENUM Data Type support for PostgreSQL 8.3.

Other enhancements:

User Interface

1. Object information is now shown in pane inside Navicat main form rather than pop-up modal dialog.
2. Support of Thumb Tracking in Grid View.
3. Detail View is available for database objects under "Others" menu.
4. Shortcut to launch History Log (Ctrl+H).

1. Support of auto-increment in Access/Paradox/Dbase Import.
2. Support of foreign key/index/unique constraints in Access/ODBC Import.
3. Support of MS Access Password security.
4. Improved Field Type mapping accuracy.

1. Improved Field Type mapping accuracy.

1. Added "Explain" button.
2. Added "Message" tab for error and message log

1. Increased Speed.
2. Improved cross-version synchronization.
3. Support of Sequence.
4. Options to choose which objects to compare.

1. Support of Sequence.
2. Additional options to choose which constraints to transfer.

1. Support of Sequence and Table Index.
2. Ability to compress a decompressed backup, and vice versa.

Bug Fixes:

1. Fixed Access Violation error when right-clicking on empty Connection tree.
2. Fixed "New Group" behaviour in Schedule group setting.
3. Fixed Access Violation error while running schedule for import in command line.

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

1. Query Builder failed to work for JOIN statement.
2. Query Explain not working properly.

Upgrade Procedure : click here to upgrade

1. Changed the default cipher specification in SSH Connection.
2. Data Transfer failed to drop views which exist in the target server.
3. Multi-lines parameter lists are not displayed properly.
4. Non ascii password failed in Test Connection.
5. Zero value is not updated for auto-increment columns in Table View.
6. Wrong date imported for excel files using 1904 date system.
7. Failed to import xml files with empty tag.

Upgrade Procedure : click here to upgrade

1. Fixed timeout problem during the Backup run in Command Line.
2. Fixed Data Transfer (without target database name) access violation in Command Line.
3. Fixed system color shows in grid.

Upgrade Procedure : click here to upgrade

1. Fixed timeout problem during the Backup run in Command Line.
2. Fixed Data Transfer (without target database name) access violation in Command Line.
3. Fixed system color shows in grid.

Upgrade Procedure : click here to upgrade

1. Changed the default cipher specification in SSH Connection.
2. Data Transfer failed to drop views which exist in the target server.
3. Multi-lines parameter lists are not displayed properly.
4. Non ascii password failed in Test Connection.
5. Zero value is not updated for auto-increment columns in Table View.
6. Wrong date imported for excel files using 1904 date system.
7. Failed to import xml files with empty tag.

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. Crash when parameter query is executed for the second time.
2. Stored Procedure - Text fields not properly aligned when resizing the windows.
3. Data Transfer - transferring all procedures/functions may not work in some situations.
4. Structure Sync - fields character sets are not compared.
5. Backup - Crash when user does not have enough privileges on the Stored Procedure/Function.
6. Bit type not displayed properly in Table View.
7. Failed to create user in MySQL 4.x.
8. A useless SQL executed during Data Transfer.
9. Username with more than 16 characters are cut off.
10. File menu is not properly displayed after a window is closed.

Upgrade Procedure : click here to upgrade

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. Fixed e-mail sending with authentication setting in Schedule.
2. Fixed Print Database/Table issue, while printing non-english field name, table name etc.
3. Fixed dbf import,while importing Float type with NULL value.
4. Fixed Open Table shortcut issue.
5. Fixed Command Line crash.

Upgrade Procedure : click here to upgrade

1. Fixed e-mail sending with authentication setting in Schedule.
2. Fixed Print Database/Table issue, while printing non-english field name, table name etc.
3. Fixed dbf import,while importing Float type with NULL value.
4. Fixed Open Table shortcut issue.
5. Fixed Command Line crash.

Upgrade Procedure : click here to upgrade

1. Fixed e-mail sending with authentication setting in Schedule.
2. Fixed Print Database/Table issue, while printing non-english field name, table name etc.
3. Fixed dbf import,while importing Float type with NULL value.
4. Fixed Open Table shortcut issue.
5. Fixed Command Line crash.
6. Fixed Report Builder, error message while moving String value with DBText control.
7. Fixed Data Transfter with Lock enabled under General tab, no structure or records being transfered to SQL file while running schedule.

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. Crash when creating table for MySQL version 4 or below.
2. foreign_key_check is not set in data transfer when using HTTP tunnel.

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.

1. New Query button now creates a new query based on the database you are working on as in Query View Window.
2. The Cancel button in Backup Window has now been changed to Close.
   

Bug Fixes:

1. Test Connection failed if socket file is set.
2. Records with multi-lines cannot be copied in Table Designer (e.g. Trigger statements).
3. Foreign Key Data Selection/Set selection panel sometimes disappear immediately after showing (bug in Mac OS X 10.5 only).
4. Import Wizard crashs easily if the message log display many messages within a short period.
5. Failed to create user in Manage User if no password is specified in a specifc mode of MySQL.
6. Some privileges are not duplicated in Duplicate User in Manage User.

Upgrade Procedure : click here to upgrade

1. Support to design operators in PostgreSQL 8.3.
2. Object list sorting now follows Finder's convention.
3. Floating point values are now displayed in the same format as what PostgreSQL returns.
4. Enlarged Stored Procedure editor, with support of enabling/disabling word wrap.

Bug Fixes:

1. Occasionally crash when using "Run Statements From Here" in Query.
2. Query View failed to display results when a SELECT query start with a blanket.
3. Stability problem in Import Wizard.
4. Problem when importing data from formula in Excel file.
5. Crash when creating the stored procedures.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

1. Object list sorting now follows Finder's convention.
2. Floating point values are now displayed in the same format as what MySQL returns.
3. Disallow using socket file if SSH Tunnel or HTTP Tunnel is used.
   

Bug Fixes:

1. Failed to backup functions in MySQL 5.1.
2. Occasionally crash when using "Run Statements From Here" in Query.
3. Data accuracy problem when importing data from formula in Excel file.
4. Query View failed to display results when a SELECT query start with a blanket.
5. Failed to create index if the relevant fields are composed of MySQL reserved words.

Upgrade Procedure : click here to upgrade

1. Fixed the backup problem while establishing connection using HTTP tunnel. (please feel save that all your data have already been backup in your backup files. No data are lost. If you are encountering problem during the restore process, please provide us your backup file.)

Upgrade Procedure : click here to upgrade

]]> http://www.navicat.com Wed, 30 Apr 2008 00:00:00 -0400 Bug Fix:

1. Fixed the backup problem while establishing connection using HTTP tunnel. (please feel save that all your data have already been backup in your backup files. No data are lost. If you are encountering problem during the restore process, please provide us your backup file.)
   

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

1. Provide better error log system for Data Synchronization.

1. Fixed "Invalid class typecast" error in Server Monitor.
2. Closed the docking windows using Alt+F4 would give Access Violation error.
3. Structure Synchronization will not synchronize field comments.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

1. Provide better error log system for Data Synchronization.

1. Fixed "Invalid class typecast" error in Server Monitor.
2. Closed the docking windows using Alt+F4 would give Access Violation error.
3. Structure Synchronization will not synchronize field comments.

Upgrade Procedure : click here to upgrade

1. Provide better error log system for Data Synchronization.

1. Structure Synchronization will not synchronize view correctly.
2. Fixed "Invalid class typecast" error in Server Monitor.
3. Closed the docking windows using Alt+F4 would give Access Violation error.
4. Structure Synchronization will not synchronize field comments.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

1. The outcome from Navicat "Dump SQL File" feature (both database and table) includes "drop table if exists" statement.
2. Ability to remember size and position for "New Query" window.
3. Set focus on Query Editor when opening a new query.

1. Fixed the backup problem which would generate error if object name contains apostrophe(').
2. No need to save the query before export to excel file.
3. Scheduled Job does not populate "from" field in email.
4. Restore window position problem.
5. Export dbf with or without memo issue.
6. Fixed uppercase StoredProc in Manage users.
7. Overflow in Server Monitor.
8. Unicode problem in StoredProc designer.
9. Comment are not shown in StoredProc designer after save.
10. Fixed import dbf float/double issue.
11. Fixed Import xml issue - while xml file contains ampersands(&).
12. Fixed popup position with dual monitor.
13. File association problem between MYSQL and PGSQL version.
14. Fixed number of crashes from query.

Upgrade Procedure : click here to upgrade

1. The outcome from Navicat "Dump SQL File" feature (both database and table) includes "drop table if exists" statement.
2. Ability to remember size and position for "New Query" window.
3. Ability to stop a running query.
4. Set focus on Query Editor when opening a new query.

1. Fixed the comparison between function bodies during the StructureSync process.
2. Fixed the backup problem which would generate error if object name contains apostrophe(').
3. No need to save the query before export to excel file.
4. Scheduled Job does not populate "from" field in email.
5. Restore window position problem.
6. Export dbf with or without memo issue.
7. Fixed uppercase StoredProc in Manage users.
8. Overflow in Server Monitor.
9. Unicode problem in StoredProc designer.
10. Comment are not shown in StoredProc designer after save.
11. Fixed import dbf float/double issue.
12. Fixed Import xml issue - while xml file contains ampersands(&).
13. Fixed popup position with dual monitor.
14. File association problem between MYSQL and PGSQL version.
15. Fixed number of crashes from query.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

1. The outcome from Navicat "Dump SQL File" feature (both database and table) includes "drop table if exists" statement.
2. Ability to remember size and position for "New Query" window.
3. Set focus on Query Editor when opening a new query.

1. Fixed the backup problem which would generate error if object name contains apostrophe(').
2. No need to save the query before export to excel file.
3. Scheduled Job does not populate "from" field in email.
4. Restore window position problem.
5. Export dbf with or without memo issue.
6. Fixed uppercase StoredProc in Manage users.
7. Overflow in Server Monitor.
8. Unicode problem in StoredProc designer.
9. Comment are not shown in StoredProc designer after save.
10. Fixed import dbf float/double issue.
11. Fixed Import xml issue - while xml file contains ampersands(&).
12. Fixed popup position with dual monitor.
13. Fixed number of crashes from query.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

1. Ability to stop while establishing connection to PostgreSQL server.
2. Better handling when SSH connection is lost.
3. Ciient Encoding is now always set to UTF-8.

Bug Fixes:

1. Ths tab note holds the previous query/procedure name during the Save As process.
2. Server password not being saved in the Connection Properties. (Lite version).
3. The button to trigger the Field Selection panel in Table Design sometimes disappear when running in Leopard.
4. An useless sql was executed after running sql in Query View.
5. Error showing process list in Server Monitor for PostgreSQL Server 8.3.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

1. Timeout reconnection - auto-reconnection will be made to the MySQL server.
2. Ability to stop while establishing connection to MySQL server.
   

Bug Fixes:

1. Better handling when SSH connection is lost.
2. Deleting existing trigger while encountering error on modification.
3. Ths tab note holds the previous query/procedure name during the Save As process.
4. Indentation problem for stored procedures.
5. Server password not being saved in the Connection Properties. (Lite version)
6. The button to trigger the Field Selection panel in Table Design sometimes disappear when running in Leopard.

Upgrade Procedure : click here to upgrade

1. Tabbed Windows - Support dragging tabs in and out of the tabbed windows.
2. SSH Connection - Support public key authentication.
3. Other minor improvements and bug-fixes.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

1. Improve the memory management for drag and drop in Virtual Grouping.
2. Re-order the SQL to be executed during Structure Synchronization.
   
3. Improved the connection management. Freed up connections when they are not used.
4. Export Wizard - remove the limitation on the size of each cell.
5. Table View - allow skipping the auto-increment column when pasting data to Table View.
6. Sort Connection list by name in Data Transfer.
   

Bug Fixes:

1. Fixed problem on Batch Job (Schedule) while connecting via SSH connection.
2. Fixed the improper behavior when SSH connection is lost.
3. Execute Batch File not work in some special cases.

Upgrade Procedure : click here to upgrade

1. Event Scheduler - new MySQL feature as of MySQL 5.1.
2. Virtual Grouping - provides better categorization for objects.
3. Form View - enjoy a clear display of field name and its value with focus on current record.
4. Code Completion - speedup your sql writing.
5. New Profile System - open profile on your desktop directly.
6. Print Report to Files - export report to pdf, html and more.
7. E-mail Notification - send notification e-mail for schedule task.

1. Compatible with any MySQL server version up to 5.1.x.
2. Incremental Search and more supports in Table View.
3. Usability enhancement in Table Design.
4. Many other improvements on features and user-friendliness.

Upgrade Procedure : click here to upgrade

]]> http://www.navicat.com Mon, 28 Jan 2008 00:00:00 -0500

Major new features:

1. Code Completion - speedup your sql writing.
2. Form View - enjoy a clear display of field name and its value with focus on current record.
3. New Profile System - Open profile on your desktop directly.
4. Print Report to Files - export report to pdf, html and more.

Other enhancements:

1. Incremental Search and more supports in Table View.
2. Usability enhancement in Table Design.
3. Many other improvements on features and user-friendliness.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

1. Support of connection to MySQL Server through SSH.
2. Support of character set and unicode.
3. Support all MySQL objects: tables, views, stored procedures/functions and events.
4. Support data and structure synchronization.
5. Virtual Grouping - provides better categorization for objects.
6. Form View - enjoy a clear display of field name and its value with focus on current record.
7. Code Completion - speedup your sql writing.
8. E-mail Notification - send notification e-mail for schedule task.

Other enhancements:

1. Compatible with any MySQL server version up to 5.1.x.
2. Enhanced Import and Export Wizard.
3. Incremental Search, Hex Editor and more supports in Table View.
4. Usability enhancement in Table Design.
5. Further data are shown in the tree view.
6. Support of raw mode edit: apply MySQL built-in function.
7. Timeout reconnection - auto-reconnection will be made to the SQL server.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

1. Tabbed Windows - support dragging tabs in and out of the tabbed windows.
2. SSH Connection - support public key authentication.
3. Structure Synchronization - support synchronizing foreign keys and triggers.

Upgrade Procedure : click here to upgrade

Major new features:

1. New Import Wizard - support Excel file; Improves performance, usability, and much more.
2. Tabbed Window - perform multiple operations in a single window.
3. Virtual Grouping - provide better categorization for objects.

Other enhancements:

1. Compatible with any PostgreSQL server version up to 8.2.x.
2. Improved memory managment in Import Wizard.
3. Keyboard shortcut (Control-Tab) to switch between tabs.
4. Incremental Search, Hex Editor and more supports in Table View.
5. Usability enhancement in Table Design.
6. Many other improvements on features and user-friendliness.

Navicat Release Notes.

Major new features:

1. New Import Wizard - support Excel file; Improves performance, usability, and much more.
2. Tabbed Window - perform multiple operations in a single window.
3. Virtual Grouping - provides better categorization for objects.
4. Event Scheduler - new MySQL feature as of MySQL 5.1.

Other enhancements:

1. Compatible with any MySQL server version up to 5.1.x.
2. Improved memory managment in Import Wizard.
3. Keyboard shortcut (Control-Tab) to switch between tabs.
4. Incremental Search, Hex Editor and more supports in Table View.
5. Usability enhancement in Table Design.
6. Many other improvements on features and user-friendliness.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Enhancements:

1. Import improved memory allocation in Import wizard.
2. Adding shortcut keys for switching tabs.

Navicat Release Notes.
]]> http://www.navicat.com Tue, 27 Jun 2006 00:00:00 -0400 New features:

Support of HTTP Tunnel:

1. Enable [Use HTTP Tunnel] option to access PostgreSQL Server through HTTP protocol. Upload the provided php file called [ntunnel_mysql.php] to the web server and enter the URL of the tunneling script.
   
   [ntunnel_mysql.php] is available in installation directory of the program.

Other enhancements:

1. Supports of Database Roles (PostgreSQL version 8.1.0).
2. Support dumping and transferring foreign keys.
3. Supports of multiple SQL editors with syntax highlighted feature.

Upgrade Procedure : click here to upgrade

New features:

Lastest MySQL versions support:

1. Compatible with any MySQL server version up to 5.1.x.
2. Support of Triggers.
3. BINARY, VARBINARY Data Type support.
4. BIT Data Type support from MySQL 5.0.3.

Support of HTTP Tunnel:

1. Enable [Use HTTP Tunnel] option to access MySQL Server through HTTP protocol. Upload the provided php file called [ntunnel_mysql.php] to the web server and enter the URL of the tunneling script.
   
   [ntunnel_mysql.php] is available in installation directory of the program.

Support of Foreign Key Data Selection:

1. Table Viewer supports to get available value from Foreign Key Reference Table.

Upgrade Procedure : click here to upgrade

New features:

1. Compatible with any MySQL server version up to 5.X.
2. Support of Triggers.
3. BINARY, VARBINARY Data Type support.
4. BIT Data Type support from MySQL 5.0.3.

New powerful data management tools:

1. Support of Views/Stored Procedures Backup and Restore.
2. Support of Views/Stored Procedures Data Transfer.
3. Support of Delimiter in Query.
4. Support of Views in Query Builder.
5. Support of Views/Stored Procedures in Manage Users.

Upgrade Procedure : click here to upgrade

Lastest MySQL versions support:

1. Compatible with any MySQL server version up to 5.0.x.
2. Support of Triggers.
3. VARCHAR Data Type support. Length from 0 to 65,535 in 5.0.3 and later versions.
4. BIT Data Type support from MySQL 5.0.3.

Significantly improved user interface:

1. Customize of connection order.
2. Support of larger font in Filter Wizard.
3. Auto-adjustment of row height setting.

New powerful data management tools:

1. Support of Views/Stored Procedures Backup and Restore.
2. Support of Views/Stored Procedures Data Transfer.
3. Support of Delimiter in Query, Console and Execute Batch Job.
4. Support of Views in Query Builder.
5. Enhancement of Manage Users for supporting MySQL 5.x.
6. Support of Views in Manage Users.

Ehancements :

1. Support of importing Oracle to MySQL.
2. Support of importing MS SQL to MySQL.
3. Bug fixes of Timestamp creation problem.
4. Bug fixes of adding a left join to existing View.
5. Bug fixes of data transfer problem.

Upgrade Procedure : click here to upgrade

1. Support of Views/Stored Procedures Backup and Restore.
2. Support of View/Stored Procedures Data Transfer.
3. Support of View creation in Query Builder.

1. Data Synchronization.
2. Structure Synchronization.
3. Build in SQL Console.
4. View Builder.

Some features enhancements:

1. Further data are shown in the tree view.
   
2. Three colors are employed within the table grid to provide a better vision for users.
3. Supports Query Parameter. For example: Select * from table_A where id = [$id].
4. Provides a short-cut to terminate a running query.
5. Raw mode setting allows user to view the actual data value which stored in the MySQL database.
6. Export Profile -the existing Navicat setting can be exported into a .reg file. You can also reload the Navicat setting from a new machine.
7. Query Builder supports to create a query from different databases which are within the same connection.
8. View Builder is an easy-way to create view.
9. Run Selected - Query Statments can be executed partly in the Query Editor.
10. Stored Procedure - new editor window provides an easy-way to create stored procedure or stored function.
11. Timeout reconnection - Auto-reconnection will be made to the SQL server.
12. Support Private Key feature for SSH Tunnel.
13. WordWrap built for Query and View Editor.
14. Supports Stored Procedure for MySQL 5.0.13 or above.

Bug Fixes:

1. Closing Navicat without prompt to save changed.
2. Invisibility of Foreign Key constraint settings.
3. Inconsistency of importing Access file.
4. Time-Consuming for creating new query with numerous tables.
5. Prevention of modifying TIMESTAMP column type.
6. DBF Import error.
7. Excel Export error as Text fields.

New features:

1. SSH Tunnel.
2. Data Synchronization.
3. Structure Synchronization.
4. Build in SQL Console.
5. View Builder.

Enhancements:

1. Support latest version of MySQL server.
2. Support of Query Parameter. For example: Select * from table_A where id = [$id].
3. Support of Drag and Drop functionality. You can transfer table from one place to another by using mouse - drag and drop tables from a database into another database.

Bug Fixes

1. Fixed Filter Wizard Loading Profile problem in Tiger.

1. Data Synchronization.
2. Structure Synchronization.
3. Build in SQL Console.
4. View Builder.

Some features enhancements:

1. Further data are shown in the tree view.
   
2. Three colors are employed within the table grid to provide a better vision for users.
3. Supports Query Parameter.
4. Provides a short-cut to terminate a running query.
5. Raw mode setting allows user to view the actual data value which stored in the PostgreSQL database.
6. Export Profile -the existing Navicat setting can be exported into a .reg file. You can also reload the Navicat setting from a new machine.
7. Query Builder supports to create a query from different databases which are within the same connection.
8. View Builder is an easy-way to create view.
9. Run Selected - Query Statements can be executed partly in the Query Editor.
10. Functions - new editor window provides an easy-way to create function.
11. Support Private Key feature for SSH Tunnel.
12. WordWrap built for Query and View Editor.

New features:

1. SSL Connection.
2. Filter Wizard.
3. Import Wizard.
4. Export Wizard.
5. Visual Query Builder.

Enhancements

1. Supports MySQL server 4.1.14

Upgrade Procedure : click here to upgrade

New features:

1. Supports Character Set.
2. Filter Wizard.
3. History Log of executed SQL statements

Bug fixes and enhancements:

1. Support old MySQL version (version 3.22).
2. Improved XML Import feature.
3. Customizable History Log path.
4. Resizable Manage User window.
5. Bug fixed for default table type in TableDesign window.
6. Bug fixed for loading Filter Wizard profile.

1. Support View in MySQL 5.0
   
2. Enhanced Import and Export Wizard
   
   • supports to import multiple tables, primary keys and foreign keys from Access.
   • supports to import multiple spreadsheet from Excel.
   • customizable row identifier in import of XML file.
   • more options available in Exporting MySQL table.
3. Support Character Set (new function in MySQL 4.1 or above)
4. Enhance Docking
5. Options: Detail View/List View in mainwindow
6. AutoFill for enum in grid
7. Change display font in Navicat
8. TableHint on mouse rollover
9. Help in each window
10. HistoryLog of executed process in Navicat.

New features:

1. Support MySQL version 4.1.6.
2. Batch Job and Scheduling - support Backup/Restore database, Import/Export Wizard, Data Transfer.
3. Support [Set Null] in table data grid.

1. Support MySQL server version up to 4.1.
2. Support of Foreign Key.
3. Support of Stored Procedure.
4. Batch Job and Scheduling - You can create a schedule for Backup, Data Transfer or saved queries execution.
5. Execute SQL Batch file.

New features:

1. Support editing text in Blob field.
2. Support MySQL 4.1.x and MySQL 5.0 Alpha (support stored procedure).
3. Bug Fixes on decimal display.
4. Combo box for enum values.

Navicat 2004 supports to import data from ODBC, create Batch Job Scheduling (schedule of Import/Export, Data Transfer and saved queries) and print table structure of their designed database. Furthermore, it now supports MySQL 5.0 Alpha (support stored procedure).

Navicat Standalone Report Viewer will be avaliable for Enterprise Edition (will be released in Mid-May).

Upgrade Procedure : click here to upgrade

1. Foreign Keys - support to configure Foreign Keys.
2. Unicode support.
3. and more useful features, minor bugfixes and performance improvement.

1. Process priority - loading table can be faster if priority is set to High.
2. Improve the user-friendliness of Data Transfer feature.
3. There will be numerous performance and manageability improvements.

1. improve performance on multiple simultaneous jobs. The performance of running large queries will be greatly improved..
2. support SSL.
3. support custom display formats for Numeric , Date and Time Type.
4. support Mysql function in edit data.
5. improve the user-friendliness.
6. there will be numerous performance and manageability improvements.

1. creating Primary Key and Indexes would be much easier.
2. a lot of small improvements on user friendliness.
3. bugfix on Manage Users.
4. some minor bugfixes.