By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,081 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

Table Copy/Synchronization

P: n/a
Hi,
I have two db servers primary/backup for which I would like to
synchronize a few tables.

Basically I need to check every 30 - 60 minutes if on the primary table
an update has beend one and add the changes to the backup server.

The problem is that some of these tables have foreign keys so I cannot
just simply drop and re-create them. I suppose I need to read the
primary table record by record and make the updates
(insert,update,delete) on the backup system.

Is there any tool or easy way to do that. I looked into the replication
but it seems to me an overkill and besides I don't wantto make any
changes on the dbschema except adding a table if necessary on the backup
system.

Thanks for any advise.
Alex

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.