Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Binaries » View Thread |
Messages 1 to 10 of 12 total |
Replication scripts |
Mon, Jul 8 2013 6:48 AM | Permanent Link |
Uli Becker | Scripts and form regarding this post in the ng:
http://www.elevatesoft.com/forums?action=view&category=edb&id=edb_general&page=1&msg=16024#16024 Contains: 1. Script to create the remote "Admin" database 2. Script to create the local "Admin" database 3. Delphi Form to save and load updates on the clients Short explanation: Database Admin on the remote server contains all client computers (table devices) and all databases for each device that shall be replicated (table databases). Database Admin on the local computers contain only the client computer (table devices) and all databases that shall be replicated (table databases) on this computer. The stores needed for the scripts to work are described in the header of the scripts: Stores on Remote Server: * 3 local stores: * Replication_Updates * Replication_In * Replication_Out Stores on local computer: * 2 local stores: * Replication_Client_In * Replication_Client_Out * 2 remote stores: * Replication_Server_In * Replication_Server_Out Using these databases and the replication form (from which you can call just LoadUpdates and SendUpdates) simplifies the replication stuff. You just have to store the name of the client computer (devices) and the database(s) to be replicated on both the remote "Admin" database and the client "Admin" database. Before using this "system" you have to make sure that the databases to be replicated are copied, published and all primary indexes are adjusted. Attachments: Admin Client Database.SQL Admin Remote Database.SQL Replication.dfm Replication.pas |
Mon, Jul 8 2013 3:11 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | |
Mon, Jul 8 2013 5:21 PM | Permanent Link |
Jeff Cook Aspect Systems Ltd | Thanks Uli
I'm sure I'll come back to this next time I have time to concentrate on my "Replication Muddle" and your comments and Tim's have helped me understand what's going on immensely. Cheers Jeff -- Jeff Cook Aspect Systems Ltd www.aspect.co.nz "Uli Becker" <johnmuller54@gmail.com> wrote in message news:1D92660D-62A2-44F2-8AE6-2A1B95756204@news.elevatesoft.com... > Scripts and form regarding this post in the ng: > > http://www.elevatesoft.com/forums?action=view&category=edb&id=edb_general&page=1&msg=16024#16024 > > Contains: > > 1. Script to create the remote "Admin" database > 2. Script to create the local "Admin" database > 3. Delphi Form to save and load updates on the clients > > Short explanation: > > Database Admin on the remote server contains all client computers (table > devices) and all databases for each device that shall be replicated > (table databases). > > Database Admin on the local computers contain only the client computer > (table devices) and all databases that shall be replicated (table > databases) on this computer. > > The stores needed for the scripts to work are described in the header of > the scripts: > > Stores on Remote Server: > * 3 local stores: > * Replication_Updates > * Replication_In > * Replication_Out > > Stores on local computer: > * 2 local stores: > * Replication_Client_In > * Replication_Client_Out > > * 2 remote stores: > * Replication_Server_In > * Replication_Server_Out > > Using these databases and the replication form (from which you can call > just LoadUpdates and SendUpdates) simplifies the replication stuff. You > just have to store the name of the client computer (devices) and the > database(s) to be replicated on both the remote "Admin" database and the > client "Admin" database. > > Before using this "system" you have to make sure that the databases to > be replicated are copied, published and all primary indexes are adjusted. > > > > |
Wed, Jul 24 2013 5:01 PM | Permanent Link |
Adam Brett Orixa Systems | Uli,
>>Thanks very much. + 1 |
Tue, Jul 30 2013 6:46 AM | Permanent Link |
Adam Brett Orixa Systems | Uli,
Having said thanks for these scripts & downloaded them the files are opening "empty" on my computer. Is this my problem, or have you uploaded empty files?? I would really like to have a look at your versions of the scripts! Thanks in advance. Adam |
Tue, Jul 30 2013 8:02 AM | Permanent Link |
Uli Becker | Adam,
> Is this my problem, or have you uploaded empty files?? I just checked that and downloaded the files from the ng - no problems here. Uli |
Thu, Sep 19 2013 5:45 AM | Permanent Link |
Uli Becker | For those who want to use these scripts: there is a mistake in the
procedure "Replication_Client_DownloadFiles". Attached the correction. Regars Uli Attachments: Correction Script.SQL |
Thu, Dec 19 2013 2:43 AM | Permanent Link |
Barry | Tim,
I noticed the last download link for "replication.pas", doesn't work. I get the message: "Internal database error: Invalid attachment encoding You may retry this operation by using the Back button in your web browser to return the previous page." Barry |
Thu, Dec 19 2013 3:04 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Barry,
<< I noticed the last download link for "replication.pas", doesn't work. I get the message: >> It's fixed now. Thanks, Tim Young Elevate Software www.elevatesoft.com |
Fri, Dec 20 2013 5:54 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Adam,
<< Having said thanks for these scripts & downloaded them the files are opening "empty" on my computer. >> I'm seeing the same thing with the web interface. I'm having a look at it today and will let you know when it's fixed. Thanks, Tim Young Elevate Software www.elevatesoft.com |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |