SQL Anywhere database - starting multiple databases

Author

starting multiple databases

Ashish

2005-05-12, 8:23 pm

Is it possible to start multiple databases from one shortcut
or starting other databases from first database?

Chris Keating \(iAnywhere Solutions\)

2005-05-13, 3:23 am

Simply include each in the engine startup. For a personal server engine,
use:
dbeng9 -n <ServerName> <db1> -n <db1 Name> <db2> -n <db2 Name> <db3> -n
<db3 Name> ... <dbN> -n <dbN Name>

If you want to start additional databases, simply allow for autostarting the
database on the server/connection and provide the name of the existing
running engine and the database file name and path (relative to the engine).

Other options also exist such as the START DATABASE statement.

<Ashish> wrote in message news:4283e355.318a.1681692777@sybase.com...
> Is it possible to start multiple databases from one shortcut
> or starting other databases from first database?

Breck Carter [TeamSybase]

2005-05-13, 9:23 am

In addition to what Chris said, if you want to start each database on
a separate engine (perhaps because they use different page sizes), you
can write a .BAT file and invoke the engine multiple times via
dbspawn.exe.

=====
ASA Database Administration Guide

Database Administration Utilities

The Spawn utility

Running a server in the background using the dbspawn command-line
utility
=====

Also, if the command line gets too long, you can use a response file.

=====
ASA Database Administration Guide

The Database Server

The database server

Database server options

@data server option
=====

Breck

On 12 May 2005 16:14:33 -0700, Ashish wrote:

>Is it possible to start multiple databases from one shortcut
>or starting other databases from first database?

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links