Point-in-time recovery: You can now restore a database to a specified time stamp or to an offset in the transaction log. Online rebuild: Online rebuild – You can now rebuild a production database while the database is running, which reduces downtime. New calls to the procedure after an alter, replace, or drop, use the new definition. Current executions use the procedure definition from when the procedure started executing. Now, the alter, replace, or drop succeeds. When database isolation is turned on, each database behaves as though it is the only database running on the database server.Īlter/drop procs: Previously, attempting to alter, replace, or drop a procedure that was being executed would result in an error. Database isolation: Support has been added for enabling database isolation for a database server. In addition, a new option has been added to allow the user to specify the minimum password length. The DBA username and password must be provided when creating new database. Increased password protection: The default DBA user name and password (DBA/sql) will no longer be used by dbinit and CREATE DATABASE statement, and the default minimum password length has been changed to 6 from 3.

Prefetch: Improved prefetching which assists performance by cutting down on client/server round trips, and increases throughput by making many rows available without a separate request to the server for each row or block of rows. Parallel recovery: Parallel recovery – SQL Anywhere can now makes better use of multi-core machines during the database recovery phase. NET, JDBC, Ruby, PHP, OLEDB, JavaScript, NodeJS, Perl, etc were analyzed and performance anomalies were addressed resulting in continued improvements for inserting and fetching data. Interfaces: all the various SQL Anywhere interfaces including ODBC. Mirroring performance: Mirroring performance – Mirror or copy node checkpoint performance has increased especially in cases of many inserts, updates or deletes on a primary server. SQL Anywhere Profiler: development tool that pulls together all the various performance and tuning data the server has available to enable easier tuning and troubleshooting of your application and database.Īuto-Detect CPU changes: SQL Anywhere can now detect newly added (or removed) CPUs from the system and make use of those CPUs appropriately without the need for a server restart. SQL Anywhere Cockpit: a web based interface to see the availability, capacity and performance of your server.

Matrix of available components (DB, Interfaces, UltraLite, MobiLink, SQL Remote, Tools of Directors) for each platform: Windows, Linux, Apple OS X, IBM AIX, HP-UX, Google Android and Consolidated Database: Oracle, Microsoft, SAP HANA, ASE, IQ, IBM DB2, MySQL … click here Two years of development that have brought important news.

Sql anywhere 16 download full torrent