cancel
Showing results for 
Search instead for 
Did you mean: 

how to access database

Former Member
2,766

Hello I am new to sqlanywhere have experience from MSSQL I have not really figured how to use sqlanywhere tools to access a running databse to view index, database structure and so on.

does someone have any starter information to get me going ?

thank you in advance.

Accepted Solutions (1)

Accepted Solutions (1)

justin_willey
Participant

Hi

This is probably a good place to start: Getting Started with SQL Anywhere The docs are quite readable and have a lot of good explanations as well as reference material.

You don't say which version you are using - these docs are for v12, earlier and later versions are similar but not exactly the same. The latest version is 16.

The tool you will probably want to start with is Sybase Central which fulfils a similar role to the Management Studio tool for MSSQL.

One important thing to know coming from the MSSQL world is that SQLA has no "Master" database on a server - login credentials belong to each individual database. Also, if you are looking around the internet for things, remember that SQL Anywhere is a completely different product from Sybase Enterprise (ASE) and instructions for that will not necessarily apply.

Do come back here with any questions you have - it's a pretty friendly forum compared with many! Just specify which version you are using and as much detail as you can about what you have tried and is giving you problems.

Good luck

Answers (1)

Answers (1)

Former Member

Hi,

you will find a couple of videos on YouTube, for example created under the account "SAP Technology".

The video "SAP D&T Academy - How to Connect to a SQL Anywhere Database" should help you.

Kind regards,

Dietrich