Hi!

In order to install our product we need to configure the DB. We also need to
turn on security, and run a few SQL scripts regarding permissions and
dataupdate.

To make the task for our service guys easier, I am thinking about automating
the task.
Does someony have an idea, if there are any commandline tools I can use for
this.
Need to setup a DB in P2k
Need to turn on security for this DB
Need to creat user, ... (all SQL)

thanks

Horst

There are several ways of doing this. You can write your own utilities
leveraging the DTI and DTO functions, which is one option, and the best way to
give yourself ultimate control. Of course, you'll take the R&D time penalty.

I have already written a command-line utility, called SQLExec, which executes
SQL statements, and it can process multiple statements in a script quite
effectively. Currently, it requires that the DSN already be created and ready
to receive requests, but people have used it to populate DDF's with a script of
CREATE TABLE statements. It can also be used to enable security and craete
users, all from the command line. You can get some more information from
http://www.goldstarsoftware.com/sqlexec.htm. I can get you an eval if you're
interested -- just send me Email (removing ZEROSPAM, of course) and I'll return
one to you to play with.

If it'll help, I'll build in the DSN creation capability into the tool as well
-- it could be a great additional feature! Of course, it'd only work with
Pervasive.SQL, perhaps, whereas the rest of SQLExec also works with Oracle,
SQLServer, Sybase, and others.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 18-20: See our web site for details!


Horst Pichler wrote: