Re: [SQL] syncing - between databases

2012-05-12 Thread Steven Crandell
Are these 5 databases on different servers and at different locations or are they on the same local cluster? If they are all on the same local cluster you may want to rethink how you are storing customer data. The design you describe seems redundant. If you are dealing with multiple servers (and

Re: [SQL] syncing - between databases

2012-05-13 Thread Steven Crandell
Having all the dblink destinations on the same server makes it a much more viable option since the chances of the dblink update failing are greatly reduced. That said, here's a run down on the queue system I described with some specificity toward your situation. You can add a flag to each custome