How to create and deploy an initial database? -
11-24-2003
, 07:25 AM
Hi:
We are developing an application which runs on Windows 2000 (server)
that uses ASA 8.0.2 as an embedded database. The app is built as
follows:
On a build machine (running Windows 2000 server, ASA 8.0.2, build
4234):
1. run dbinit to create an empty ".db" file
2. start the ASA server and execute a bunch of CREATE TABLE, CREATE
PROCEDURE, and INSERT statements to create an initial database
3. stop the ASA server. The ASA ".db" file incorporated into an
InstallShield project.
During install, we simply copy the ".db" file created above and start
the ASA server. The ASA Server on the target machine is also 8.0.2
but is build 4251.
Is this a valid way to create and intall an initial database? I am
asking because we sometimes see one of these in the first few minutes
after using a freshly installed system:
I. 09/27 12:35:05. *** ERROR *** Assertion failed: 200601 (8.0.2.4251)
I. 09/27 12:35:05. Page for requested record not a table page or
record not present on page
E. 09/29 14:02:03. Fatal error: Unknown device error
Thanks,
David Blackman
blackman (AT) voicenet (DOT) com |