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.

Uli,

Thanks very much.

Tim Young
Elevate Software
www.elevatesoft.com

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.
>
>
>
>

Uli,

>>Thanks very much.

+ 1

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

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

For those who want to use these scripts: there is a mistake in the
procedure "Replication_Client_DownloadFiles".

Attached the correction.

Regars Uli

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

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

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