Chapter 4 Database Administration Utilities
151
The Write File utility
The Write File utility is used to manage database write files. A write file is a
file associated with a particular database. All changes are written into the
write file, leaving the database file unchanged.
Write files can be used effectively for testing when you do not wish to
modify the production database. They can also be used in network and
student environments where read-only access to a database is desired, or
when you distribute on CD-ROM a database that you wish users to be able to
modify.
If you are using a compressed database, you must use a write file;
compressed database files cannot be accessed directly. The write file name is
then used in place of the database name when connecting to the database, or
when loading a database on the database server command line.
v You can access the write file utility in the following ways:
♦ From Sybase Central
♦ From the system command line, using the
dbwrite
command-line utility.
This is useful for incorporating into batch or command files.
The Write File utility runs against a database file. The database must not be
running on a server when you run the Write File utility.
The database file cannot be modified after the write file is created, otherwise
the write file becomes invalid.
Creating a write file from Sybase Central
v To create a write file for a database:
1 Open the Utilities folder in the left panel.
2 Double-click Create Write File in the right panel. The Write File wizard
appears.
3 Follow the instructions in the wizard.
Tip
You can also access this wizard by clicking Tools➤Adaptive Server
Anywhere➤Create Write File.
Using write files for
development
Compressed
databases
To Next Page
Loading...