Re: Twin interfaces, and one and a half databases to a project

Replication can be done both ways, regardless of what Sybase or Oracle or whoever are saying. But it isn't easy, you won't find off-the-shelf solutions, and you might not get support from your vendor.

But I've implemented two way replication between 4 (!) Sybase servers, purely on a database level (no non-database programs were written except to present status information).

Don't think it was simple though. In total, it took about 18 months of work. It's hard to get everything right!

Abigail

Comment on Re: Twin interfaces, and one and a half databases to a project

Replies are listed 'Best First'.
Re: Re: Twin interfaces, and one and a half databases to a project by demerphq (Chancellor) on Aug 15, 2002 at 16:59 UTC
That sounds pretty impressive. And you did it purely in transac-sql? No external scripts? Wow. Yves / DeMerphq --- Software Engineering is Programming when you can't. -- E. W. Dijkstra (RIP)	[reply]
Re: Twin interfaces, and one and a half databases to a project by Abigail-II (Bishop) on Aug 15, 2002 at 17:10 UTC
No changes allowed in the existing binaries/libraries was actually a design requirement. Although we did use the fact the application was already required to lock trades (done with a stored procedure) before able to modify them (you don't want two traders modifying the same trade at the same time - yes, it was a financial application). Abigail	[reply]