Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
JOB to copy Users between 2 servers |
Thu, Aug 6 2015 8:22 PM | Permanent Link |
Jeff Cook Aspect Systems Ltd | 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 |
Fri, Aug 7 2015 3:02 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, Aug 7 2015 10:07 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Aug 7 2015 11:38 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
How easy would it be to allow us to publish the config tables? Roy Lambert |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |