Hi, i've two offices. The main office in Milan and the branch office in Rome.
Now, i want implement a sql infrastructure, that when the clients, in rome, write in the rome's db/table, they can also see what the clients, in milan, write in the milan's db/table and viceversa in real-time. Next the dbs, in Rome and Milan, must have
the same data
I've read that i can use the Sql server replication or Peer-to-Peer Replication feature.
If, YES, what hardware i've need? (eg.: two servers for sql (one in Rome and one in Milan); two SAN for dbs )
If you have any links, is welcome.
Thanks to all for info.
p.s.:sorry if my english isn't perfect.
View Complete Post