We have just upgraded our copies of the fantastic Navicat 8 in the office from version 7 and first impressions have left me disappointed.
The upgrade process was fast and easy and I had it installed and activated within minutes. The most important thing to me and the bit I was looking forward to was the code-completion when writing queries. Sometimes you have so many field names you cant remember the exact name of all of them so the code-completion would be a God send. Its there alright but not as good as I thought it would be.
For instance, its not really automatic while typing. To activate it for SQL statements/functions etc you have to press CTRL+SPACE and even then it only gives you the name of the function, not the syntax like Visual Studios Intellisense gives you.
Another problem is when your dealing with named tables. You get a blank code-completion window when you try and use p.fieldName from a query detailed as "FROM pages AS p" It does work if you use pages.fieldName in other words, you have to call the table name explicitly.
Another problem I found after using it literally 3 minutes, was a hard crash (and repeating exception window) after I clicked new stored procedure and then cancelled it without doing anything else. I am guessing the app was developed with Delphi as I have seen the same type of problem with Homesite.
One of the most annoying things I found was that they no longer open objects in the tree using a single click. You have to double-click databases/tables etc to open them which when your used to 3 generations of the app over the last 4 years, its quite annoying. I thought surely they would have a Preferences dialog but unfortunately this was not an option in here although they do have quite a few customisable sections.
The good part was that it imported all my settings from Version 7. The app is also slower to start up which is one of the things I loved with Version 7 - It was so fast. Accessing databases online is also slower for some reason.
Overall, there is no real benefit to upgrading to Version 8 so I would hold off until an update is released before shelling out more cash for a product that doesnt necessarily improve anything.
Find Out More : Navicat 8 Official Website