The forum will be down for maintenance at some point from Friday, August 24 at 19:00 EDT until Sunday, August 26 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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.1k121155225


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.1k121155225
accept rate: 21%

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:

×136
×107
×15
×2

question asked: 24 Apr '14, 04:24

question was seen: 1,121 times

last updated: 24 Apr '14, 09:52