Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Programming » Deploying Databases and Applications

Deploying dbisqlc Next Page

Deploying SQL script files


If you want to be able to create databases as part of your application, you must include components from the scripts directory (for example, C:\Program Files\SQL Anywhere 10\scripts). The following is a list of files that are essential to creating new databases.

boottabs.sql
dboviews.sql
migrat.sql
mkexclud.sql
mksadb.sql
oleschem.sql
rstab.sql
sadebug.sql
saopts.sql
sybprocs.sql
syscap.sql
systabviews.sql
sysviews.sql

If you are deploying an application that uses the authenticated version of the database server, then you must also include the following file.

authenticate.sql

For more information about authenticated applications, see Running authenticated SQL Anywhere applications.

If you require jConnect support in the databases that you will create, then you must also include the following file.

jcatalog.sql

The following files are required to unload a SQL Anywhere 10 database.

unload.sql
optdeflt.sql
opttemp.sql

The following files are required to unload databases built with earlier versions of SQL Anywhere.

unloadold.sql