If you just want to run some queries to pull data from the site database, creating a SQL linked server might be all you need to do, with no need for replicating data.
https://msdn.microsoft.com/en-us/library/ff772782.aspx thanks, Deepak Kumar, http://www.adaptiva.com/onesite-deep-dive/ [Description: Description: adaptiva_logo4c-small] Simply Works! [email-signature-awards] From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Troy Martin Sent: Tuesday, January 20, 2015 5:36 PM To: <mssms@lists.myitforum.com> Subject: Re: [mssms] Transactional replication of CM database Transactional replication of the site database is only supported for the MP role. This is so because only a subset of the site database is used by an MP, and not the entire database. Consider using Log Shipping instead - https://msdn.microsoft.com/en-us/library/ms151224.aspx Sent from my iPhone On Jan 20, 2015, at 5:40 PM, Corkill, Daniel <danielcork...@logan.qld.gov.au<mailto:danielcork...@logan.qld.gov.au>> wrote: There's a push here to enable transactional replication of the ConfigMgr database for an enterprise reporting project. I just wanted to know if transactional replication of the database is supported, any adverse effects I should be aware of and if anyone has some recommended reading for me to get a further understanding. Daniel. ********************************************************************* This email, including any attachment, is confidential to the intended recipient. It may also be privileged and may be subject to copyright. If you have received this email in error, please notify the sender immediately and delete all copies of the email. Any confidentiality or privilege is not waived. Neither the Council nor the sender warrant that this email does not contain any viruses or other unsolicited items. This email is an informal Council communication. The Council only accepts responsibility for information sent under official letterhead and duly signed by, or on behalf of, the Chief Executive Officer. Privacy Collection Notice Logan City Council may collect your personal information, e.g. name, residential address, phone number etc, in order to conduct its business and/or meet its statutory obligations. The information will only be accessed by employees and/or Councillors of Logan City Council for Council business related activities only. If your personal information will be passed onto a third party, Council will advise you of this disclosure, the purpose of the disclosure and reason why. Your information will not be given to any other person or agency unless you have given us permission or we are required by law. ________________________________ Legal Notice: This email is intended only for the person(s) to whom it is addressed. If you are not an intended recipient and have received this message in error, please notify the sender immediately by replying to this email or calling +44(0) 2083269015 (UK) or +1 866 592 4214 (USA). This email and any attachments may be privileged and/or confidential. The unauthorized use, disclosure, copying or printing of any information it contains is strictly prohibited. The opinions expressed in this email are those of the author and do not necessarily represent the views of 1E Ltd. Nothing in this email will operate to bind 1E to any order or other contract.