The UI in Alt SQL Developer is well laid out. There is a standard file/object browser on the left, an SQL worksheet on the right, and the results pane is shown at the bottom. However, I found that the formatting of the UI elements to be inconsistent. There are several different fonts, sizes, and styles used for different areas, such as tabs and labels, which made it feel like it was incomplete. The icons, though, were big and easy to use.
I had a couple of issues with DBXpert. The Explain Plan did not work for me, as I got an error about partition_stop being an invalid identifier. I also could not get the code completion working (automatically complete the table name).
It includes some common features, such as code complete (finishing the SQL keywords for you or offering suggestions, such as table names), inline editing of results to update the database table, and SQL formatter, and several SQL formatting options that can be changed.
- dbForge SQL Tools is one of the most popular tools, a powerful integrated solution for SSMS that improves all coding routines. A powerful auto-complete feature with context suggestions is more precise and flexible than the standard IntelliSense in SSMS. Code snippets let teams reuse fragments of code. Options of code debugging and refactoring help businesses produce high-quality code. Various formatting profiles help managers set the standards and follow them.
It's a shame that Schema Compare and Data Compare don't link together slightly more easily - they are two completely separate tools. If I am comparing the schema of two databases, for example, it would be really useful to have a button to "compare data" which launched data compare with the same servers and databases selected.
Prior to this version, the Scheduler Service's setting was set to -1. This disabled automatic flushing of completed jobs. With this version, this setting now defaults to 24, so completed jobs flush automatically every 24 hours.
d0d94e66b7