Suppose that we have a multi-user application, with all users accessing the
same CFG file that points to a database location. Now one user would like to
switch to a different database, for example a copy of the real database,
just for testing purposes.

As I understand it, we cannot just do a DROP DATABASE etc as that will
modify the CFG file for all users.

So, is the best approach to let that user somehow (temporarily) switch to a
different CFG file, which holds the path to that second database?

Royke

Royke


I may be being extremely thick here but why not simply have two databases in the same configuration file and allow the users to switch between databases?

Roy Lambert [Team Elevate]

ps

<<for example a copy of the real database,
just for testing purposes.>>

REAL database for TESTING???????????????

Roy,

>>REAL database for TESTING???????????????

*g* I'm doing this, exactly the way you described, with one configuration file.

"Real" DB gets copied every night, when user logs in he can choose between the "real" DB,
and the test DB. Comes handy when you want to explain a new feature, and the users can
just play around in a almost real situation with familiar data, without doing damage to
the real data.

Heiko

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:9FCC4E60-A2E4-487C-B8FF-1CE3110DFFE6@news.elevatesoft.com...
> Royke
>
>
> I may be being extremely thick here but why not simply have two databases
> in the same configuration file and allow the users to switch between
> databases?
>
> Roy Lambert [Team Elevate]
>
> ps
>
> <<for example a copy of the real database,
> just for testing purposes.>>
>
> REAL database for TESTING???????????????

Did you maybe miss the text "a copy of" ????????????

Royke

>Did you maybe miss the text "a copy of" ????????????

Yes I did - Wipes fevered brow - it was early in the morning after all

Roy Lambert [Team Elevate]