(multi-processor support, Java objects in the database)

Version 5: 1995 (SQL Remote data replication graphical administration tools).

PowerSoft and Sybase merged in 1995: Watcom SQL was renamed SQL Anywhere.

Version 4: 1994 ( Stored procedures, triggers).

Watcom acquired by Powersoft in 1993 Watcom SQL shipped with their visual programming environment PowerBuilder.

Initially created by Watcom as Watcom SQL.

SQL Remote: SQL Remote technology is based on a store and forward architecture that allows occasionally connected users to synchronize data between SQL Anywhere databases using a file or message transfer mechanism. QAnywhere: QAnywhere facilitates the development of robust and secure store-and-forward mobile messaging applications. Mobilink: MobiLink is a highly-scalable, session-based synchronization technology for exchanging data among relational databases and other non-relational data sources. Ultralite: UltraLite is a database-management system designed for small-footprint mobile devices such as PDAs and smart phones. SQL Anywhere Server is a high performing and embeddable relational database-management system ( RDBMS) that scales from thousands of users in server environments down to desktop and mobile applications used in widely deployed, zero-administration environments. It includes scalable data synchronization technology that provides change-based replication between separate databases, including large server-based RDBMS systems. It can also function as a mobile database. It can be used as a database server for work groups or for small or medium-sized businesses. Its ability to be used with minimal administration is a distinguishing feature in this role. For example, it is used in Intuit QuickBooks, in network management products, and in backup products. SQL Anywhere is used in several contexts, including as an embedded database, particularly as an application data store.

Strong encryption is supported for both database files and client-server communication. The engine supports stored procedures, user functions (using Watcom SQL, T-SQL, Java, or C/ C++), triggers, referential integrity, row-level locking, replication, high availability, proxy tables, and events (scheduled and system events).

The product provides several standard interfaces ( ODBC, JDBC, and ADO.NET) and a number of special interfaces such as PHP and Perl. Database files are independent of the operating system, allowing them to be copied between supported platforms. SQL Anywhere can be run on Windows, Windows CE, Mac OS X, and various UNIX platforms, including Linux, AIX, HP-UX and Solaris.

Sql anywhere 12 client deployment