<div>
Or here : <a href="http://www.awprofessional.com/articles/article.asp?p=170234&rl=1" rel="ugc">http://www.awprofessional.com/articles/article.asp?p=170234&rl=1</a>
</div>


Or here : http://www.awprofessional.com/articles/article.asp?p=170234&rl=1 [http://www.awprofessional.com/articles/article.asp?p=170234&rl=1]

<div>
<div class="content wysiwyg-content">
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.<br />
Can I configure the 2 SQL-Server for replication between them? <br />
We need to configure SQL-Server to full bi-directional synchronization/ replication (in real-time as possible)<br />
Is it a possible? <br />
How or where can I find information to do it?<br />
We’re going to have a third office soon, can I add others Offices, or it has a limit? <br />
<br />
Thanks!<br />
<br />
<br />

</div>
</div>


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? 

Thanks!




SQL Server bi-directional replication/ synchronization

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.