Skip to end of metadataGo to start of metadata
Top 4 Download periodically updates software information of sql anywhere full versions from the publishers, but some information may be slightly out-of-date. Using warez version, crack, warez passwords, patches, serial numbers, registration codes, key generator, pirate key, keymaker or keygen for sql anywhere license key is illegal. I'm curious if anybody has some information on migrating a database from SQL Anywhere 12 to SQL Anywhere 17 when it comes to the new roles feature that was implemented in SQL Anywhere 16. Enter code here First off, I unloaded the full database and schema out of our version 12 database (12.0.1.394.
The SAP SQL Anywhere Database Client includes the following components:
- Full set of available client interfaces, such as ODBC, JDBC, ADO.NET and so on.
- Administration tools such as SQL Central and Interactive SQL.
Note: During installation you will be prompted to review and accept the SQL Anywhere software license agreement. If you do not accept the License Agreement you can either end the product installation or download a 60-day evaluation edition (subject to a software evaluation license).
Please click on the links below to obtain the appropriate software.
SAP SQL Anywhere Version | Software (Database Client only) |
---|---|
SAP SQL Anywhere 17.0 | Windows x86 and x64 |
Linux x86 and x64 | |
OS X | |
Solaris SPARC | |
Solaris x64 | |
HP-UX Itanium | |
IBM AIX | |
SAP SQL Anywhere 16.0 | Windows x86 and x64 |
Linux x86 and x64 | |
OS X | |
Solaris SPARC | |
Solaris x64 | |
HP-UX Itanium | |
IBM AIX | |
SAP SQL Anywhere 12.0.1 | |
IBM AIX |
Visit the SAP SQL Anywhere Developer Center for links to valuable technical whitepapers, webcasts, Q&As, demos and other information to help with next steps as you evaluate SAP technology.
As you may already know, SAP Business Objects 3.1 (SP5 and higher) and 4.1 uses the SAP Sybase SQL Anywhere 12.0.1 embedded database for its default CMS and Audit databases. When you install BOBJ, the installation of SQLA happens automatically and you only need to define standard credentials to log in to the database, such as administrator user name/password.
One thing the default BOBJ installation does not do is install the SQL Anywhere administration tools; however, you can still get them using one of two methods:
- The BOBJ 3.1 installation media includes a file called “SA1201_Client.exe” (Windows) and “sa12_client_linux_x86.x64.1201_3152_l10n.tar.gz” (Linux) inside the folder “SAW”. Execute (Windows) or extract/execute (Linux) this file to install the SQL Anywhere Client, which includes the administration tools.
- Download the SQL Anywhere Client from here: http://scn.sap.com/docs/DOC-35857. You need to do this if using BOBJ 4.1.
There are three database administration tools provided to manage the database:
- Sybase Central: the main tool to create/view/edit database objects, such as tables, views, stored procedures, etc.
- Interactive SQL: a query editor to execute ad-hoc queries.
- SQL Anywhere Console: a monitoring tool to display database connections, properties, server messages, etc.
The most useful tool is Sybase Central since that’s what you use to define events and maintenance plans for CMS and Audit database validation and backups. It’s all wizard-based so creating those management tasks is a breeze. If you’re in for a challenge, you can always create your events using pure SQL, in which case Interactive SQL is your friend… but if you’re a GUI person like me, stick to Sybase Central 🙂