469,088 Members | 1,273 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,088 developers. It's quick & easy.

Replicating data

Hi all,

I have two databases at different locations.

Database 1 (local) is emptied say, once per week and re-populated.

Database 2 (remote) is updated from local.

What I want to do is to update the remote without deleting it first, so here
are the actions...

Compare the content of remote against local.
Delete from remote where no longer in local
add to remote where not exist in remote but exist in local.

I have an ID field as the key field. I don't want to disturb this really as
I want to be able to do a form of tracking (nothing complex and not to be
relied upon) though I want to be able to allow the remote user to be able to
come back based on the ID.

What I am currently doing is dropping the remote and recreating from the
local.

Is there a tool that will allow me to do this or am I going to have to rely
on a multiple sql statement to manage it. If SQL, can you give me some idea?

Thanks.
Dave Colliver.
--
~~
All I ask is a chance to prove that money can't make me happy.

Your community connected. http://www.ashfieldfocus.com
Get your business on the net, http://www.clickprovince.com
Collectible dolls from http://www.collectorsdolls.com
Web design, hosting, domain registration? http://www.revilloc.com is the
answer.
Tips, tricks and articles for programmers of all languages on
http://www.sourcecodecorner.com
Planning a wedding? http://www.bmcweddings.com
Advertise your car on http://www.drivingseat.com
Jul 19 '05 #1
0 1299

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Brian E. Seppanen | last post: by
5 posts views Thread by Derickson | last post: by
3 posts views Thread by jodyblau | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.