Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Merge and Transactional Setup on Same Database?

Posted on 2011-02-17
1
Medium Priority
?
306 Views
Last Modified: 2012-05-11
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??
0
Comment
Question by:jwa082276
1 Comment
 
LVL 12

Accepted Solution

by:
mcv22 earned 2000 total points
ID: 34922589
Yes, it is possible to enable transactional and merge for a particular database.

See http://msdn.microsoft.com/en-us/library/ms151772.aspx
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Integration Management Part 2
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question