Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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.

asked 24 Apr '14, 04:24

danvik's gravatar image

danvik
99226
accept rate: 0%

edited 24 Apr '14, 08:27

Justin%20Willey's gravatar image

Justin Willey
7.6k137179249


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

permanent link

answered 24 Apr '14, 06:32

Justin%20Willey's gravatar image

Justin Willey
7.6k137179249
accept rate: 20%

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

permanent link

answered 24 Apr '14, 09:52

Dietrich's gravatar image

Dietrich
13614
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×159
×128
×15
×2

question asked: 24 Apr '14, 04:24

question was seen: 2,386 times

last updated: 24 Apr '14, 09:52