cancel
Showing results for 
Search instead for 
Did you mean: 

Advantage Database Server downloads

wolverine
Explorer

Hi, i need to download some files and when i go to https://devzone.advantagedatabase.com/ i get redirected to SAP web page.

How i can download the files?

Regards.

View Entire Topic
michael_loop
Contributor
0 Kudos

Allen,

If you don't have the evaluation version of SQL Anywhere yet, you can get it here: Try SAP SQL Anywhere, developer edition..

You can migrate ADS tables and indexes following the instructions here: KBA 3136538 - "How to migrate ADS tables and indexes to a SQL Anywhere database?" This has only been tested with version 12 but should work with 9.1 as well. Note that database objects such as procedures, triggers, etc. will need to re-coded as the SQL standards for the two products are not exactly the same.

former_member863506
Discoverer
0 Kudos

I receive the message:

You are not entitled for SAP Note/KBA 3136538

The target audience for the SAP Note/KBA you were trying to reach does not fit to your profile.

when trying to access this KBA, can you inform how I may obtain the info since it doesn't match with my SID

former_member863506
Discoverer
0 Kudos

Could you provide information on how to access this KB article?

jhoehne
Participant
0 Kudos

The KB article shows how to use the included SQL Anywhere database tool to import ADS data using ODBC. You can do that with lots of other databases, e.g. MSSQL, PostgreSQL etc.

jknauf
Explorer
0 Kudos

There is an Error when I try to load the KB article.
Is SQL Anywhere an alternative for the ADS?

jhoehne
Participant
0 Kudos

Is SQL Anywhere an alternative for the ADS?

No, it's a completely different product, that happens to be made by the same company. Apart from SQL, ADS also allows table based ISAM access. ADS can be used without a server. Both features are not supported by SQL Anywhere. In fact, I only know of one other database that supports access with or without using a server, and that is "Elevate DB" (but their SQL is incompatible and the server is slow compared to ADS).

Lots of former customers of ADS now use Microsoft SQL Server. The SQL language is quite similar, and there is a free version called "SQL Express", limited to 4 CPU cores and 10 GB database size. It's easy to install, but difficult to remove (you have to remove some 11 components one at a time...).

We ourselves are in the process of converting everything to the open source Firebird SQL database.