How to view a list of databases under server in SQL Anywhere like we do in SQL Server

sybase-sql-anywhere

I am very new to SQL Anywhere. I have been working with SQL Server for a long time.

In SQL Server, if we need to see the list of database under server, we can see that under Server Explorer.

How can I do same in SQL Anywhere?

I have just installed SQL Anywhere 16 and have no idea how to find Server name etc.

Best Answer

You have to create a database and then start the database server.

On installation of SQL Anywhere it does not automatically setup a database server/service.

Once it is running, you can connect as DBA to it with SQL Central or other tools.

Related Solutions

Sql Anywhere 11: Restoring incremental backup failure

Summarizing the information linked to in the post above....

The command you have used is for a live backup but what you want is an incremental backup. The approach you want to use (per this blog) uses somewhat different switches. You want to use the -n -t -x switches, and the -o to specify a log file. So the command ends up something like:

dbbackup -n -t -x -c "eng=ServerName.DbName;uid=dba;pwd=sql;links=tcpip(host=ServerName)" -o "c:\backup\backup_log.txt"

Sybase SQL Anywhere 12 – Get all indexes which are unique -> ambigious sysindexes error

There are two system views called sysindexes - one owned by SYS and one owned by DBO. You likely want the the one owned by SYS:

SELECT z.name FROM sys.sysobjects z JOIN sys.sysindexes ON (z.id = i.id) WHERE type = 'U'

Best Answer

Related Solutions

Sql Anywhere 11: Restoring incremental backup failure

Sybase SQL Anywhere 12 – Get all indexes which are unique -> ambigious sysindexes error

Related Question