<div>
<div class="content wysiwyg-content">
Is it possible (or acceptable) to setup a database to replicate data via transactional replication and merge replication at the same time (to, to different databases on separate servers)? <br />
<br />
I walked thru the wizard 2 times for the same database. &nbsp;One time choosing transactional replication and then the next time choosing merge (I did NOT remove the transactional before setting up the merge).<br />
<br />
It let me....but is it really possible??
</div>
</div>


Is it possible (or acceptable) to setup a database to replicate data via transactional replication and merge replication at the same time (to, to different databases on separate servers)? 

I walked thru the wizard 2 times for the same database.  One time choosing transactional replication and then the next time choosing merge (I did NOT remove the transactional before setting up the merge).

It let me....but is it really possible??

Merge and Transactional Setup on Same Database?

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.