We are going to have 2 offices in different cities with SQL-Server 2000 running the common application with a same database between them; each office will be updating and inserting data.
Can I configure the 2 SQL-Server for replication between them?
We need to configure SQL-Server to full bi-directional synchronization/ replication (in real-time as possible)
Is it a possible?
How or where can I find information to do it?
We’re going to have a third office soon, can I add others Offices, or it has a limit?