DB Solo 3.0 Changes

New Features

Schema Scripting Tool allows you to create a DDL script for your entire schema
Import Tool lets you import data from CSV or fixed-length files into a table
Support for Sybase SQL Anywhere (ASA) was added
Added support for SQL Server 2000 & 2005 user management, including the ability to add/modify/drop database users, database roles and server logins
Added support for Sybase ASE user management, including the ability to add/modify/drop database users, database roles and server logins

Added support for Mac OS 10.5 (Leopard)
Used/Total memory is displayed with a garbage collection button
Recent Files item shown in the File Menu
Closable tabs
On exit the application asks if modified documents in Query Editors should be saved
All SQL preview windows can now be printed

Results of a query are now shown as text in addition to the standard grid results
Query text can now be printed

Column definitions (column name, nullability, default value, data type) can be altered for Sybase, DB2, Oracle, PostgreSQL, MySQL and SQL Server
Privileges on Tables, Views, Sequences, Packages, Object Types, Collection Types, Functions, Stored Procedures shown for Sybase, DB2, Oracle, PostgreSQL, MySQL and SQL Server
Materialized Views and Materialized View Logs are shown for Oracle
Server triggers (logon/logoff) are shown for SQL Server 2005
Database triggers are shown for SQL Server 2005
DDL triggers are shown for Oracle
Added support for creating & dropping tables on H2 databases
Added support for creating & dropping constraints on H2 databases
Added support for creating & dropping indexes on H2 databases
Added support for creating & dropping columns on H2 databases
Table comments are shown for DB2, Oracle, MySQL and PostgeSQL
Column comments are shown for DB2, Oracle, MySQL and PostgeSQL

Support for synonym comparison was added
Sybase/SQL Server clustered vs. non-clustered indexes are detected
Synchronization Script can optionally include grant statements for Sybase, DB2, Oracle, PostgreSQL, MySQL and SQL Server
Foreign key comparison can verify that the referenced table is in the same schema/database on both sides
Sequences are now supported for PostgreSQL
Column comments can be compared for DB2, Oracle, MySQL and PostgeSQL
Table comments can be compared for DB2, Oracle, MySQL and PostgeSQL
Foreign-key comparison can compare the ON DELETE/ON UPDATE rules
Tables and other objects can be selected for comparison by entering a regular expression

Queries can be specified not to be run automatically when selected from the favorites menu