What's New in SQL Anywhere Studio
What's New in Version 7.0.0
New features in version 7.0.0
SQL Remote version 7.0 includes the following new features.
Globally unique primary keys You can now use a DEFAULT GLOBAL AUTOINCREMENT column in an Adaptive Server Anywhere database, together with a GLOBAL_DATABASE_ID option setting in each database, to guarantee unique primary keys throughout a SQL Remote installation of Adaptive Server Anywhere databases. This is a more convenient method than the more manual primary key pool technique.
For more information, see Using global autoincrement default column values.
Internal unload for dbxtract The Extract [dbxtract] utility now uses the UNLOAD statement introduced in Adaptive Server Anywhere version 7.0 by default, rather than the slower OUTPUT statement. Options have been introduced to allow you to choose a combination of internal (server-side) and external (client-side) unload and load operations.
For a complete listing of options, see The extraction utility.