The installation process uses a standard Windows installation which felt familiar. When I went to activate the trial, I found that I needed to be online so that the IDE could connect to the server. This was a little annoying as I was offline a lot of the time when I was preparing this guide, and would have thought t was built in to the software. But I understand that in most environments where this would be used, an online connection would exist.
Another great feature is that it shows a sum of values. You can select some values in the result set, just by clicking on them like they were a spreadsheet, and this SUM field will show their sum. This can help in analysing data quickly. You can change the sum to use count, average, max, min, or standard deviation.
The IDE itself has a standard looking view. It has a sidebar on the left with an object explorer and a file viewer (called Scripts). The SQL editor window is in the middle, and when queries are run, the results display at the bottom. Version 10 allows you to choose the UI you like, and has a dark theme included which is preferable by a lot of developers in other IDES (such as Visual Studio).
It seems very similar to SQL Management Studio, but with less features, which is understandable. Some of the excluded features seem like nice to have features (database compare, import into table), but other features are pretty standard in many other IDEs (export results into different formats, SQL formatter).
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.
Alt SQL Developer has some good features and the standard SQL IDE features are easy to use. AN Explain Plan is accessible with a toolbar button. The results pane can be exported into many different formats, including different types of SQL commands (Insert, Insert All, Update, and more). Inline editing works well.
The user interface is then shown. There are several toolbars of buttons, which seem like too many. AN SQL window is shown at the top, and the results panel at the bottom, which is pretty standard. The results panel shows a lot of extra tabs for messages, execution plans, and so on, which is useful.
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).
SQAll has several features missing that I think would be pretty standard for a paid product. These features are the ability to run an explain plan, an object browser, file management, and code snippets or favourites.
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.
It has a standard-looking UI and seems to include quite a lot of functionality used by developers and DBAs (schema editing and diagramming, reports, forms, SQL editing, administration, and utilities).
Configuration information can be found in the three configuration files; not all elements are valid in all configuration files. For example, binding mode and private path information can only be in the application configuration file. For a complete list of the information that is contained in each file, see Configuring Apps by Using Configuration Files.
Quoting parameters with single or double quotes is allowed. This lets whitespace be used within parameters. Operating systems and scripting languages that call SQL*Plus handle quotes in different ways. They may or may not pass quotes to the SQL*Plus executable. For example, in a standard Bourne shell on UNIX, quotes around parameters are stripped before the parameters are passed to SQL*Plus, and SQL*Plus never sees the quotes.
Products has two versions where the standard version is free. Apparently very lightweight product which can even run in Google Chrome. Otherwise there is a standalone version (5Mb), and as a requirements you'll need a .NET Framework 4.0/4.5 (or Framework 3.5 for LINQPad 2.x).
Database management software helps users create a single data source that can be leveraged by multiple users simultaneously. Most importantly, it helps enforce safety standards for a business' data. It helps organizations make better, broader, and more efficient use of their key data by combining capabilities for data manipulation, analytics, and reporting. 2b1af7f3a8