Book a Demo

Author Topic: WAN Performance/Best Practices  (Read 9167 times)

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Re: WAN Performance/Best Practices
« Reply #15 on: December 23, 2007, 03:19:13 am »
Quote
Hi jdrake4,

Does Oracle come with some sort of database replication technology?

We found the same problem with EA performance but it is solvable using MS SQL Server with merge replication between database instances.  We have been using EA on 2 replicated databases succesfully for the last month.

There is a bug with EA which Sparx fixed in the latest build (copy and paste diagrams was broken on a replicated SQL Server EA database).

If you switch to SQL Server - I can give you the replication scripts you need to set this up plus an amended base SQL script to create the EA tables correctly for replication.

Cheers,
David.

Could you mail them to me too?THANKS!
Recursion definition:
If you don’t understand the definition read "Recursion definition".

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: WAN Performance/Best Practices
« Reply #16 on: December 23, 2007, 03:40:54 am »
Hi Dave,

Could you please also send me the new version? I've made major changes to my SQL Server version - which seem to have improved most non-EA things a lot - since you last sent your scripts out. I think it's time I updated.

And yes, I'm running the current EA build.

David
No, you can't have it!

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Re: WAN Performance/Best Practices
« Reply #17 on: December 23, 2007, 01:11:01 pm »
It seems also Sparx is having some trouble... ;D
Recursion definition:
If you don’t understand the definition read "Recursion definition".