Getting started with SQL Anywhere Server

Getting started

SQL Anywhere provides three methods to administer your system: Sybase Central, Interactive SQL, and command-line utilities. In most cases, the choice of which tool to use is your preference. The majority of tasks, such as connecting to a database, are supported by all three methods.

The tutorials and introductory materials listed in this section use all three methods to create and manage SQL Anywhere databases.

For an overview of Sybase Central and Interactive SQL, see Design and management tools.

Starting the database server

Tutorial: Using the sample database
This tutorial walks you through starting a database server, displaying the database server messages window, and stopping the database server.

Additional information For a list of the most common options to use when starting a database, or database server, see Some common options.
For a complete list of server options, see The SQL Anywhere database server.

Or, run the following command:
dbeng11 -?
Further reading For more information about starting and stopping the database server, see Running the database server.
For more information about how SQL Anywhere names its databases and servers, see Naming the server and the databases.

Connecting to a database

Simple connection examples
This section describes how to create an ODBC data source and how to use it to connect to a database using Sybase Central.

Further reading For more examples of connecting to the SQL Anywhere sample database, connecting to an embedded database, and connecting across a network, see Introduction to SQL Anywhere database connections.
For more information about ODBC data sources, see Working with ODBC data sources.

Managing databases

Using Sybase Central
This section introduces Sybase Central and describes how to use it to:
- Connect to databases
- Create connection profiles
- Search a database
- View entity-relationship diagrams
- Monitor database health and statistics

Creating a database

Tutorial: Creating a SQL Anywhere database
This tutorial describes how to use Sybase Central to:
- Create a database file
- Connect to your database
- Create a table
- Create relationships between tables

Using SQL statements

Using Interactive SQL
This section familiarizes you with Interactive SQL and provides steps to:
- Execute multiple statements
- Cancel an Interactive SQL command
- Look up tables, columns, and procedures
- Print SQL statements
- Recall and log commands
- Create and run script files

Send feedback about this page via email or DocCommentXchange