dbTalk Databases Forums  

How to create and deploy an initial database?

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss How to create and deploy an initial database? in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Blackman
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.