<div>
It really depends on the size. &nbsp;If the database is small go with option A, if not option B. &nbsp;Notice how I have been particularly vague and that is because I do not know your SLAs
</div>


It really depends on the size.  If the database is small go with option A, if not option B.  Notice how I have been particularly vague and that is because I do not know your SLAs

<div>
<div class="content wysiwyg-content">
I have a database on an SQL server 2005 named SERVER1 which has approximately 70 tables in a database DB1 that need replicating to another database server SERVER2 which has no database on it yet.<br />
I am considering one of two ways of proceeding to set up a merge replication to the SQL Server 2005 database server SERVER2.<br />
<br />
Scenario A:<br />
Set up a SERVER1 as a publisher to publish the 70 tables in DB1<br />
Create a blank database DB1 on SERVER2<br />
Add SERVER2 as a subscriber to SERVER1 publication and proceed with synchronisation.<br />
<br />
Scenario B:<br />
Set up a SERVER1 as a publisher to publish the 70 tables in DB1 and create a backup to disk.<br />
Restore the backup to SERVER2 thus creating a DB1 on SERVER2<br />
Remove all replication on SERVER2 DB1<br />
Add SERVER2 as a subscriber to SERVER1 publication and proceed with synchronisation.<br />
<br />
I am stating that scenario A is better than scenario B, am I correct, and if so, how can i justify my decision ?
</div>
</div>


I have a database on an SQL server 2005 named SERVER1 which has approximately 70 tables in a database DB1 that need replicating to another database server SERVER2 which has no database on it yet.
I am considering one of two ways of proceeding to set up a merge replication to the SQL Server 2005 database server SERVER2.

Scenario A:
Set up a SERVER1 as a publisher to publish the 70 tables in DB1
Create a blank database DB1 on SERVER2
Add SERVER2 as a subscriber to SERVER1 publication and proceed with synchronisation.

Scenario B:
Set up a SERVER1 as a publisher to publish the 70 tables in DB1 and create a backup to disk.
Restore the backup to SERVER2 thus creating a DB1 on SERVER2
Remove all replication on SERVER2 DB1
Add SERVER2 as a subscriber to SERVER1 publication and proceed with synchronisation.

I am stating that scenario A is better than scenario B, am I correct, and if so, how can i justify my decision ?

SQL server 2005 merge replication procedures

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.