1. Support for multiple database connections
Users can now create additional OLE DB Database Connections in a project by right clicking on an existing OLE DB Database Connection Project Property and choosing 'Create Copy'.

2. Inclusion of the database table "Owner" in table names
Applies to SQL Server and Oracle.  When importing SQL Server or Oracle tables into Superior SQL Builder, the database table owner is automatically included in the table name.

3. Support for multi-database SQL
Multi-database SQL is supported for SQL Server, MySQL and Oracle.  When importing database tables into Superior SQL Builder, the user can optionally specify the Database Name (or Oracle Database Link Name). If the Database Name is specified, it is included as part of the table name.

4. Many new script templates
V2.0 includes many new templates, such as 'Insert Statements from Tables', 'DB Synchronization - Data', 'Drop Columns', 'Insert (where not exists)', 'Row Count', etc.

5. Simplification of Script Template Building process
*  Creation of two new parsers: 'Database Table Selector' and 'Database Tables Selector' parser. The introduction of these two new parsers allows a 'Database Tables' input node to cast to a 'Database Table' or 'Database Tables' property without the need for hidden output nodes.

*  The 'Tables' and 'Query Builder' parsers now include all of the functionality from the 'Database Tables - Current Join' and 'Database Tables - Current Table' parsers. This new functionality removes the need to use the 'Database Tables - Current Join' and 'Database Tables - Current Table' parsers when developing script templates.

*  The 'Database Table parser now includes all of the functionality from the ‘Database Table - Current Unique Key’ parser. This new functionality removes the need to use the ‘Database Table - Current Unique Key’ parser when developing script templates.

*  Introduction of an Object Browser in the Script Template Builder. Allows the user to view and navigate to all of the Input Nodes, Properties, Output Nodes, Input Scripts and Project Properties that exist in the script template.

6. Support for "calculated fields" in the 'Query Builder' and 'Where Clause' parsers
The 'Query Builder' and 'Where Clause' parsers now allow expressions to be entered.  
eg.  "Northwind.dbo.Orders.ShipName + ' / ' + Northwind.dbo.Orders.ShipCity"

7. Support for date functions in the 'Query Builder' and 'Where Clause' parsers
The 'Query Builder' and 'Where Clause' parsers now support dates in various formats.  Dates/times can be entered by enclosing them using # # characters.  For example, #1 dec 2003#, or #15 mar 1998 5:27 pm#.  A number of different formats are allowed.  

8. Script Template Creation Tutorial
'Getting Started' now includes a step-by-step tutorial that demonstrates how to build a script template.

9. Explicit support for MySQL v5.0
A 'MySQL v5.0' Script Generation Type has been added.

If you have any questions about Superior SQL Builder v2.0, any other matter relating to our products and services, please contact us or visit the http://www.superiorsql.com.