License to use dbisql.com and where to download

[Former Member]

Hello,

I am new to SQL Anywhere

In the MS SQL world, I would install SSMS on my management workstation, then administer remote MS SQL servers remotely from there. I would purchase licenses for the actual servers, but not the management workstations.

I would like to use the management tools dbisql.com and dbisql.exe from a management workstation in a similar manner. Are the any licensing ramifications associated with this or can I install management tools on as many workstations as I want? Also, is there a separate download for just the management tools? If so, can someone please provide a link? If not, is there a method to run the regular installer but only install the management tools?

Thanks,

[Chris_Kleisath]

Licensing: There are licensing ramifications. You will need to determine how your server has been licensed. Depending on the version of SQL Anywhere you have, there may have been 2 different licensing models for SQL Anywhere servers (CPU based and seat based). In general, if your server is seat based, you will have to ensure that each seat has a client license.

Install: There is no separate install, you simply run the install, and only pick the tools to install.

[Former Member]

Ok, thanks. Based on your answer I found this link: http://global.sap.com/corporate-en/our-company/policies/sybase/pdf/pslt/SQL_Anywhere16_PSLT.pdf, which basically says the same thing. So how can I tell if I'm licensed by seat or CPU?

[RADical_Systems]

If you have access to DBISQL somewhere and can connect the database in question you can run the following and it will tell you if you are seat or processor.

select property('licensetype')