User's Guide
   PART 4. Database Administration and Advanced Use
     CHAPTER 27. Deploying Databases and Applications       

Deploying database servers

You can deploy a database server by making the SQL Anywhere Studio Setup program available to your end-users. By selecting the proper option, each end-user is guaranteed of getting the files they need.

In order to run a database server, you need to install a set of files. The files are listed in the following table. They should be installed in a single directory unless indicated with an asterisk. All redistribution of these files is governed by the terms of your license agreement. You must confirm whether you have the right to redistribute the database server files before doing so.

32-bit Windows	Windows 3.x	UNIX	NetWare
dbeng6.exe	dbeng6w.exe	dbeng6
dbsrv6.exe	N/A	dbsrv6	dbsrv6.nlm
dbserv6.dll	dbserv6w.dll	libdbtspt6.sol
dblgen6.dll	dblgen6w.dll	dblgen6.res	dblgen6.res
dbjava6.dll (1)	dbjava6.dll (1)	libdbjava6.so (1)	dbjava6.nlm (1)
dbctrs6.dll
dbextf6.dll (2)	dbextf6w.dll (2)		dbextf6.nlm (2)
asajdbc.zip (1,3)	asajdbc.zip (1,3)	asajdbc.zip (1,3)	asajdbc.zip (1,3)
classes.zip (1,3)	classes.zip (1,3)	classes.zip (1,3)	classes.zip (1,3)

1 Required only if using Java in the database.

2 Required only if using system extended stored procedures and functions (xp_).

3 Install such that the CLASSPATH environment variable can locate classes in this file.

Notes 

• Depending on your situation, you should choose whether to deploy the personal database server (dbeng6) or the network database server (dbsrv6).

• The Java DLL (dbjava6.dll) is required only if the database server is to use the Java in the Database functionality.

• The table does not include files needed to run utility command-line applications such as dbbackup.

       For information about deploying database utilities, see Deploying database utilities and Interactive SQL.

• The zip files are required only for applications that use Java in the database, and must be installed into a location so that they can be located in the user's CLASSPATH environment variable.

  Deploying databases

You deploy a database file by installing the database file onto your end user's disk.

As long as the database server shuts down cleanly, you do not need to deploy a transaction log file with your database file. When your end-user starts running the database, a new transaction log is created.

For SQL Remote applications, the database should be created in a properly synchronized state, in which case no transaction log is needed. You can use the Extraction utility for this purpose.

  Deploying databases on read-only media

Adaptive Server Anywhere databases distributed on read-only media such as a CD-ROM require the use of a Write File. This file records changes made to a database stored on a CD-ROM and is located on a read/write storage media such as a hard disk.

In this case, the database file is placed on the CD-ROM, while the write file is placed on disk. The connection is made to the write file, which maintains a transaction log file on disk.