Bug Fixes:

1. Data truncated when exporting pdf file from Report Builder.
2. Navicat got hanged while performing a search in Table Viewer.
3. Incorrect excel file format was exported while having data started with 0 in Export Wizard.
4. Copy and paste was not working on index in MySQL/PostgreSQL Table Designer.
5. "80070001: PrectServer2 not connected" error occurred while transfering Oracle data to file.
6. Execute SQL File function would not run if there was a SQL Server identifier contains "GO" characters.
7. SQL Server "double" data type was not being handled properly in Export Wizard.
8. Auto-increment info was missing while preforming cross data transfer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Navicat got hanged while performing a search in Table Viewer.
2. Incorrect excel file format was exported while having data started with 0 in Export Wizard.
3. Copy and paste was not working on index in MySQL/PostgreSQL Table Designer.
4. "80070001: PrectServer2 not connected" error occurred while transfering Oracle data to file.
5. Execute SQL File function would not run if there was a SQL Server identifier contains "GO" characters.
6. SQL Server "double" data type was not being handled properly in Export Wizard.
7. Auto-increment info was missing while preforming cross data transfer.

To upgrade, please visit our Customer Center.

Improvements:

1. Increased the limit of number of joins allowed in Query Builder.
2. Improved the working area on Query Builder.

Bug Fixes:

1. Fixed the error when running Explain plan for Oracle 9i.
2. Fixed the error when importing LOB field in Import Wizard.
3. Fixed a crash issue when re-running a query in Query Viewer.
4. Fixed the failure of sending email in Schedule.
5. Fixed the bug of disabled definition box in PostgreSQL function.
6. Fixed the bug on running functions in PostgreSQL function window.

To upgrade, please visit our Customer Center.

Improvement:

1. Support editing Money type for SQL Server 2000.
2. Import speed has been improved in Import Wizard.
3. Export speed has been improved in Export Wizard.

Bug Fixes:

1. 'column d.datpath does not exist' error occurred while Navicat connecting to PostgreSQL server.
2. Navicat generated 'Not Implemented' error when running under replacement shell UI.

To upgrade, please visit our Customer Center.

Improvement:

1. Support editing Money type for SQL Server 2000.
2. Import speed has been improved in Import Wizard.
3. Export speed has been improved in Export Wizard.

Bug Fixes:

1. 'column d.datpath does not exist' error occurred while Navicat connecting to PostgreSQL server.
2. Navicat generated 'Not Implemented' error when running under replacement shell UI.

To upgrade, please visit our Customer Center.

Improvements:

1. Embedded Oracle Full Client instead of Light Client.
2. Update the SQLite version to 3.7.10.

Bug Fixes:

1. Fixed the failure of printing PDF in Model Designer.
2. Fixed the bug of DISTINCT clause disappeared in Query Editor after using Query Builder.
3. Fixed the slow response issue when opening Execute SQL File window.
4. Fixed a crash issue when using Beautify SQL.
5. Fixed the crash issue when quitting MySQL/PostgreSQL/Oracle/SQL Server process in Server Monitor.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. While scrolling MySQL index fields, the scrolled position could not be reflected in Table Designer.
2. MySQL Table Designer generated incorrect SQL statement in field ordering.
3. The comparison in MySQL columns ordering were generated incorrectly in Structure Synchronization, and Synchronize to Database in Modeler.
4. Extra SET FOREIGN_KEY_CHECKS MySQL queries were generated even if the comparison results were identical in Structure Synchronization.
5. Collation in Database Properties not able to set since wrong SQL generation.
6. Not able to open schema for databases with non-default database collation in SQL Server 2000.
7. Oracle long Number could not shown in Table Designer.
8. Synchronize to Database in Modeler generated redundant TYPE clause (PostgreSQL) while comparing a new column.
9. Synchronize to Database in Modeler did not generate SQLite index SQL properly.
10. Crash occurred when closing Synchronize to Database in Modeler during the comparison in progress.
11. Crash occurred while renaming table failed with server error in ER-diagram view.
12. Data Transfer would hang in Navicat Scheduler.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. While scrolling MySQL index fields, the scrolled position could not be reflected in Table Designer.
2. MySQL Table Designer generated incorrect SQL statement in field ordering.
3. The comparison in MySQL columns ordering were generated incorrectly in Structure Synchronization, and Synchronize to Database in Modeler.
4. Extra SET FOREIGN_KEY_CHECKS MySQL queries were generated even if the comparison results were identical in Structure Synchronization.
5. Collation in Database Properties not able to set since wrong SQL generation.
6. Not able to open schema for databases with non-default database collation in SQL Server 2000.
7. Oracle long Number could not shown in Table Designer.
8. Synchronize to Database in Modeler generated redundant TYPE clause (PostgreSQL) while comparing a new column.
9. Synchronize to Database in Modeler did not generate SQLite index SQL properly.
10. Crash occurred when closing Synchronize to Database in Modeler during the comparison in progress.
11. Crash occurred while renaming table failed with server error in ER-diagram view.
12. Data Transfer would hang in Navicat Scheduler.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed the crash issue when clicking on an object inside a virtual group, having "Click to refresh object list" option was enabled in Preferences.
2. Fixed the SQL error when using Custom Filter in Filter Wizard.
3. Fixed the bug in Query Builder where functions were not displayed properly.
4. Fixed the problem of launching Oracle SQL*Plus.
5. Fixed the crash issue in Structure Synchronization when comparing SQL Server tables and views.
6. Fixed the SQL Server connection problem when login using Windows Authentication.
7. Fixed the bug in schema selection in Execute SQL File on SQL Server connection.

To upgrade, please visit our Customer Center.

Improvement:

1. Enhanced MySQL Model transformation.

Bug Fixes:

1. "Access violation" error occurred when dragging n dropping a server node in connection tree together with the Model/Schedule object pane were opened.
2. When created a virtual group in the connection tree, it would be added under Model/Schedule object pane while they were opened.
3. Failed to execute a SQL Server Stored function with some field types.
4. "Maintain"->"Vacuum Database..." for PostgewSQL and SQLite server would randomly not shown in the connection tree.

To upgrade, please visit our Customer Center.

Improvement:

1. Enhanced MySQL Model transformation.

Bug Fixes:

1. "Access violation" error occurred when dragging n dropping a server node in connection tree together with the Model/Schedule object pane were opened.
2. When created a virtual group in the connection tree, it would be added under Model/Schedule object pane while they were opened.
3. Failed to execute a SQL Server Stored function with some field types.
4. "Maintain"->"Vacuum Database..." for PostgewSQL and SQLite server would randomly not shown in the connection tree.

To upgrade, please visit our Customer Center.

Improvements:

1. SQL scripts copy from Structure and Model Synchronization comparison results are now formatted properly.
2. MySQL field orders are now properly synchronized in Structure Synchronization.

Bug Fixes:

1. Fixed the connection issues on some SQL Servers.
2. Fixed the crash issue when importing tab-delimited file on Mac OS X 10.5.
3. Fixed the problem of importing null values into newly created fields in Import Wizard.

To upgrade, please visit our Customer Center.

Improvement:

1. Source field order is now kept in target table after running "Synchronize to Database" for MySQL server.
2. SQLite Columns with undefined data type is now able to be searched in "Find in Database" feature.

Bug Fixes:

1. Incorrect field type showed in ER Diagram.
2. Fixed-width and row delimiter were unable to retrieve from a profile in Import Wizard.
3. Structure Synchronization produced invalid pointer exception error when comparing SQL Server stored procedures.
4. Non-latin characters with different collation columns in MySQL table were unable to search in "Find in Database" feature.
5. Print report to PDF file would generate a blank file.

To upgrade, please visit our Customer Center.

Improvement:

1. Source field order is now kept in target table after running "Synchronize to Database" for MySQL server.
2. SQLite Columns with undefined data type is now able to be searched in "Find in Database" feature.

Bug Fixes:

1. Incorrect field type showed in ER Diagram.
2. Fixed-width and row delimiter were unable to retrieve from a profile in Import Wizard.
3. Structure Synchronization produced invalid pointer exception error when comparing SQL Server stored procedures.
4. Non-latin characters with different collation columns in MySQL table were unable to search in "Find in Database" feature.
5. Print report to PDF file would generate a blank file.

To upgrade, please visit our Customer Center.

Improvements:

1. Added hidden option to disable transaction in Stored Procedure in MySQL connection.

Bug Fixes:

1. Fixed Data Transfer encoding issue when MySQL charset was disabled.
2. Fixed the bug on the comparison of MySQL field character set.
3. Fixed the refresh problem after reordered the fields in ER diagram view.
4. Fixed the reload time issue after saving table.
5. Fixed the wrong listing for target tables in SQL Server Data Synchronization.
6. Fixed the bug occurred when selecting weekday in Schedule setup panel.

To upgrade, please visit our Customer Center.

Improvement:

1. Support column comment up to 1024 characters for MySQL 5.5.3.
2. Support table comment up to 2048 characters for MySQL 5.5.3.

Bug Fixes:

1. Data Modeling Tool was unable to set the reference field of foreign key.
2. Data Modeling Tool was unable to print with landscape page setting.
3. When importing data from an URL, it failed to create a temporary file if the same temporary file was being accessed.
4. Tables contained MySQL geometric point data was failed in Data Transfer and Data Synchronization.
5. Restore didn't work with the .pmb file created from Navicat for MySQL version 5.
6. Failed to implement PostgreSQL LIKE query with date time columns in "Find in Database" function.
7. Failed to implement PostgreSQL 'name' type columns in "Find in Database" function.
8. Connection Information could not display properly in large font size.
9. Default value of bit field was shown incorrectly in MySQL Table Viewer.

To upgrade, please visit our Customer Center.

Improvement:

1. Support column comment up to 1024 characters for MySQL 5.5.3.
2. Support table comment up to 2048 characters for MySQL 5.5.3.

Bug Fixes:

1. Data Modeling Tool was unable to set the reference field of foreign key.
2. Data Modeling Tool was unable to print with landscape page setting.
3. When importing data from an URL, it failed to create a temporary file if the same temporary file was being accessed.
4. Tables contained MySQL geometric point data was failed in Data Transfer and Data Synchronization.
5. Restore didn't work with the .pmb file created from Navicat for MySQL version 5.
6. Failed to implement PostgreSQL LIKE query with date time columns in "Find in Database" function.
7. Failed to implement PostgreSQL 'name' type columns in "Find in Database" function.
8. Connection Information could not display properly in large font size.
9. Default value of bit field was shown incorrectly in MySQL Table Viewer.

To upgrade, please visit our Customer Center.

New Feature:

1. Support connection coloring.

Improvements:

1. Settings are now stored in ~/Application Support/PremiumSoft CyberTech folder instead of ~/Application Support/Navicat.
2. Support of setting MySQL socket timeout in Connection Properties.
3. Support of dumping SQL file with selected tables.
4. Added option to enable/disable comparing MySQL character set in Structure Synchronization.

Bug Fixes:

1. Fixed the MySQL/PostgreSQL Structure Synchronization index and default problem.
2. Fixed the missing Foreign Keys when reversing tables to model.
3. Fixed the issue of selecting wrong database type when reversing tables to model.

To upgrade, please visit our Customer Center.

Improvements:

1. Improved performance of "Reverse Database to Model" and "Reverse Tables to Model.
2. Foreign Keys is now able to be imported into Model.
3. Spacing issue has been improved in Beautify SQL.

Bug Fixes:

1. Cross transfer to SQL Server would fail when "identity" error occured.
2. Import from paradox file was unable to get signed short integer values.
3. User Privileges typo was fixed.

To upgrade, please visit our Customer Center.

Improvements:

1. Improved performance of "Reverse Database to Model" and "Reverse Tables to Model.
2. Foreign Keys is now able to be imported into Model.
3. Spacing issue has been improved in Beautify SQL.

Bug Fixes:

1. Cross transfer to SQL Server would fail when "identity" error occured.
2. Import from paradox file was unable to get signed short integer values.
3. User Privileges typo was fixed.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed the problem of wrong encoding used when loading queries.
2. Fixed the issue of not saving a Data Synchronization advanced setting as profile.
3. Fixed the crash problem when started with the main toolbar hidden.
4. Fixed the issue of not quoting keyword when creating MySQL table.
5. Fixed the problem of returning wrong value for FOUND_ROWS() MySQL function.
6. Fixed the syntax error when transferring index in PostgreSQL.

To upgrade, please visit our Customer Center.

Improvements:

1. MySQL indexes is now included in Create Table during Data Transfer.
2. PostgreSQL Import Wizard is now able to recognize varchar type with defined length from ODBC database source.

Bug Fixes:

1. The highlighted items from the previous searching results in Table Designer was failed to clear for the next searching.
2. MySQL foreign key was unable to be created in Table Designer when referencing a destination field requiring index.
3. "SET FOREIGN_KEY_CHECKS=1" did not generate while running MySQL Structure Synchronization.
4. Index method was unable to be saved in PostgreSQL Table Designer.
5. PostgreSQL Language did not include in Store Procedure.
6. Restored bytea data in PostgreSQL was failed.
7. "Access violation" error occurred in Navicat main windows during the debug function in Oracle Debugger.
8. Default scale of 4 was applied when encountering currency data during the Import of Access file in Navicat MySQL, PstgreSQL and Oracle version.
9. Field name with over 30 characters long was unacceptable in SQLite Table Designer.
10. INDEX definitions did not include in SQLite SQL Dump File and Data Transfer feature. And database name referenced was missed in the INSERT commands.
11. Data with #10 or #13 would be determined as BLOB type during SQLite Export Wizard.
12. New version of SQL Server Native Client could not be recognized.
13. Failed to set open status for SQL Server database in Connection Properties.
14. SQL Server Table Designer did not accept an index name with over 30 characters long.
15. Parse could not apply on a running SQL in SQL Server Query form.
16. Failed to match source column data to the corresponding column during SQL Server Import Wizard.

To upgrade, please visit our Customer Center.

Improvements:

1. MySQL indexes is now included in Create Table during Data Transfer.
2. PostgreSQL Import Wizard is now able to recognize varchar type with defined length from ODBC database source.

Bug Fixes:

1. The highlighted items from the previous searching results in Table Designer was failed to clear for the next searching.
2. MySQL foreign key was unable to be created in Table Designer when referencing a destination field requiring index.
3. "SET FOREIGN_KEY_CHECKS=1" did not generate while running MySQL Structure Synchronization.
4. Index method was unable to be saved in PostgreSQL Table Designer.
5. PostgreSQL Language did not include in Store Procedure.
6. Restored bytea data in PostgreSQL was failed.
7. "Access violation" error occurred in Navicat main windows during the debug function in Oracle Debugger.
8. Default scale of 4 was applied when encountering currency data during the Import of Access file in Navicat MySQL, PstgreSQL and Oracle version.
9. Field name with over 30 characters long was unacceptable in SQLite Table Designer.
10. INDEX definitions did not include in SQLite SQL Dump File and Data Transfer feature. And database name referenced was missed in the INSERT commands.
11. Data with #10 or #13 would be determined as BLOB type during SQLite Export Wizard.
12. New version of SQL Server Native Client could not be recognized.
13. Failed to set open status for SQL Server database in Connection Properties.
14. SQL Server Table Designer did not accept an index name with over 30 characters long.
15. Parse could not apply on a running SQL in SQL Server Query form.
16. Failed to match source column data to the corresponding column during SQL Server Import Wizard.

To upgrade, please visit our Customer Center.

Major New Features:

1. Data Modeling Tools.
2. ER Diagram view.
3. SQL Minifier.
4. Database Wide Search.

Improvements:

1. Ability to run transaction backup for MySQL database (InnoDB only).
2. Added object list in Query Editor.
3. Added DDL tab in Object Information.

To upgrade, please visit our Customer Center.