Hi

I have a EDB server that is publicly visible on the internet.

My application uses this server to check Users and Roles (also stuff
like have they paid their monthly rental) before allowing full access to
the app.

Works well.  I have in place a scheme that uses encrypted ini files to
provide the server data as at the last connection to the server.  This
allows users to work when they don't have an internet connection.  Also
it makes the loss of the server (server down maintenance/crashed)
survivable for a period of time.

My preferred option would be to have an alternate server in case the
prime server goes down.  I've coded this already and it works but for
one problem - the alternate server needs the users, roles and user/roles
from the prime server.

So the question is, how do copy the user, roles and user/roles from the
prime server to the alternate.  I envisage a JOB that ran on the
alternate server, connected to the prime and transferred over that data.
 Is this possible in SQL?  I guess I could write a program in Delphi to
do it, but I'd like it to be run on a schedule like a job.

Any thoughts appreciated.

Cheers

Jeff

Jeff


Interesting question. A couple of ideas come to mind, wether either will work I have no idea:

First idea Use EXPORT / IMPORT the necessary tables from the Configuration database. I know export works because I just tried it. I have no idea about import - didn't want to try it just in case it screwed things up.

The second one was to PUBLISH the configuration database but that doesn't work

There must be people out there doing this sort of thing for load balancing so hopefully one of those can give you a good idea

Roy Lambert

Jeff,

<< So the question is, how do copy the user, roles and user/roles from the prime server to the alternate.  I envisage a JOB that ran on the alternate server, connected to the prime and transferred over that data.  Is this possible in SQL?  I guess I could write a program in Delphi to do it, but I'd like it to be run on a schedule like a job. >>

This is a tough one.  The main issue here is that you can't *read* arbitrary files using EDB SQL/PSM at the moment.  If you could, then it would be a simple matter of transferring the CreateSQL statements for all of the relevant users/roles to the other server's store using a remote store and COPY FILE, and then just using another scheduled job to read them in and execute them.

Tim Young
Elevate Software
www.elevatesoft.com

Tim


How easy would it be to allow us to publish the config tables?

Roy Lambert