https://www.tntware.com/donorhub/faqs/en/when-should-we-use-the-replication-model.aspxen-USCommunityServer 2008.5 SP2 (Debug Build: 40407.4157)https://www.tntware.com/donorhub/faqs/en/when-should-we-use-the-replication-model.aspxSat, 01 Jun 2019 19:54:11 GMT51c8af77-2ecd-4ae7-b5f5-4793798b888c:6Troy Wolbrinkhttps://www.tntware.com/donorhub/faqs/en/when-should-we-use-the-replication-model/comments.aspxCurrent revision posted to Frequently Asked Questions by Troy Wolbrink on 6/1/2019 7:54:11 PM<br /> <h2>When should we use the replication model?</h2> <div style="font-size: 90%;">Filed under: SQL Server</div> <p><span style="text-decoration: line-through; color: red;">The</span> <a href="/tntmpd.dataserver/help/en/pages/deployment_models.aspx"><span style="text-decoration: line-through; color: red;">replication</span> <span style="text-decoration: line-through; color: red;">model</span> <span style="text-decoration: line-through; color: red;">is</span> <span style="text-decoration: line-through; color: red;">referred</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">in</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">help</span> <span style="text-decoration: line-through; color: red;">manual</span></a><span style="text-decoration: line-through; color: red;">.</span></p> <p><span style="text-decoration: line-through; color: red;">If</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">web</span> <span style="text-decoration: line-through; color: red;">server</span> <span style="text-decoration: line-through; color: red;">is</span> <span style="text-decoration: line-through; color: red;">remote</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">and/or</span> <span style="text-decoration: line-through; color: red;">bandwidth</span> <span style="text-decoration: line-through; color: red;">was</span> <span style="text-decoration: line-through; color: red;">severely</span> <span style="text-decoration: line-through; color: red;">constrained</span> <span style="text-decoration: line-through; color: red;">between</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">office</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">web</span> <span style="text-decoration: line-through; color: red;">server</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">should</span> <span style="text-decoration: line-through; color: red;">probably</span> <span style="text-decoration: line-through; color: red;">use</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">replication</span> <span style="text-decoration: line-through; color: red;">model</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">overcome</span> <span style="text-decoration: line-through; color: red;">this</span><span style="text-decoration: line-through; color: red;">.</span><p>This <span style="text-decoration: line-through; color: red;">means</span> <span style="text-decoration: line-through; color: red;">that</span> <span style="text-decoration: line-through; color: red;">you</span><span style="text-decoration: line-through; color: red;">&#39;</span><span style="text-decoration: line-through; color: red;">d</span> <span style="text-decoration: line-through; color: red;">have</span> <span style="text-decoration: line-through; color: red;">a</span> <span style="text-decoration: line-through; color: red;">TntMPD.DataServer</span> <span style="text-decoration: line-through; color: red;">database</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">web</span> <span style="text-decoration: line-through; color: red;">server</span> <span style="text-decoration: line-through; color: red;">which</span> <span style="text-decoration: line-through; color: red;">is</span> <span style="text-decoration: line-through; color: red;">replicated</span> <span style="text-decoration: line-through; color: red;">locally</span><span style="text-decoration: line-through; color: red;">.</span>&nbsp; <span style="text-decoration: line-through; color: red;">This</span> <span style="text-decoration: line-through; color: red;">would</span> <span style="text-decoration: line-through; color: red;">allow</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">connect</span> <span style="text-decoration: line-through; color: red;">to</span>&nbsp;<span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">donation</span> <span style="text-decoration: line-through; color: red;">system</span>&nbsp;<span style="text-decoration: line-through; color: red;">database</span> <span style="text-decoration: line-through; color: red;">locally</span> <span style="text-decoration: line-through; color: red;">(</span><span style="text-decoration: line-through; color: red;">which</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">could</span> <span style="text-decoration: line-through; color: red;">never</span> <span style="text-decoration: line-through; color: red;">do</span> <span style="text-decoration: line-through; color: red;">from</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">remote</span> <span style="text-decoration: line-through; color: red;">web</span> <span style="text-decoration: line-through; color: red;">server</span><span style="text-decoration: line-through; color: red;">)</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="text-decoration: line-through; color: red;">pump</span> <span style="text-decoration: line-through; color: red;">donations</span> <span style="text-decoration: line-through; color: red;">into</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">local</span> <span style="text-decoration: line-through; color: red;">TntMPD.DataServer</span> <span style="text-decoration: line-through; color: red;">database</span><span style="text-decoration: line-through; color: red;">.</span>&nbsp; <span style="text-decoration: line-through; color: red;">Then</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">could</span> <span style="text-decoration: line-through; color: red;">synchronize</span> <span style="text-decoration: line-through; color: red;">those</span> <span style="text-decoration: line-through; color: red;">changes</span> <span style="text-decoration: line-through; color: red;">with</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">TntMPD.DataServer</span> <span style="text-decoration: line-through; color: red;">database</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">web</span> <span style="text-decoration: line-through; color: red;">server</span> <span style="text-decoration: line-through; color: red;">only</span> <span style="text-decoration: line-through; color: red;">sending</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="text-decoration: line-through; color: red;">receiving</span> <span style="text-decoration: line-through; color: red;">changes</span> <span style="text-decoration: line-through; color: red;">(</span><span style="text-decoration: line-through; color: red;">so</span> <span style="text-decoration: line-through; color: red;">it</span><span style="text-decoration: line-through; color: red;">&#39;</span><span style="text-decoration: line-through; color: red;">s</span> <span style="text-decoration: line-through; color: red;">very</span> <span style="text-decoration: line-through; color: red;">efficient</span> <span style="text-decoration: line-through; color: red;">with</span> <span style="text-decoration: line-through; color: red;">bandwidth)</span><span style="background: SpringGreen;">FAQ</span> <span style="background: SpringGreen;">article</span> <span style="background: SpringGreen;">has</span> <span style="background: SpringGreen;">become</span> <span style="background: SpringGreen;">obsolete</span>.</p> <p><span style="text-decoration: line-through; color: red;">If</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">web</span> <span style="text-decoration: line-through; color: red;">server</span> &nbsp;</p> <p><span style="background: SpringGreen;">DonorHub</span> is &nbsp;<span style="text-decoration: line-through; color: red;">local</span> <span style="text-decoration: line-through; color: red;">(</span><span style="text-decoration: line-through; color: red;">in-house)</span>&nbsp;<span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">probably</span>&nbsp;<span style="text-decoration: line-through; color: red;">shouldn</span><span style="text-decoration: line-through; color: red;">&#39;</span><span style="text-decoration: line-through; color: red;">t</span> <span style="text-decoration: line-through; color: red;">use</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">replication</span> <span style="text-decoration: line-through; color: red;">model</span><span style="text-decoration: line-through; color: red;">.</span>&nbsp; <span style="text-decoration: line-through; color: red;">You</span> <span style="text-decoration: line-through; color: red;">probably</span> <span style="text-decoration: line-through; color: red;">have</span> a <span style="text-decoration: line-through; color: red;">computer</span> <span style="text-decoration: line-through; color: red;">somewhere</span> <span style="text-decoration: line-through; color: red;">in</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">office</span> <span style="text-decoration: line-through; color: red;">which</span> <span style="text-decoration: line-through; color: red;">can</span> <b><span style="text-decoration: line-through; color: red;">run</span> <span style="text-decoration: line-through; color: red;">TntMPD.DataServer</span></b> <span style="text-decoration: line-through; color: red;">and</span> <b><span style="text-decoration: line-through; color: red;">have</span> <span style="text-decoration: line-through; color: red;">access</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">both</span>&nbsp;<span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">donation</span> <span style="text-decoration: line-through; color: red;">system</span> <span style="text-decoration: line-through; color: red;">database</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">TntMPD.DataServer</span> <span style="text-decoration: line-through; color: red;">SQL</span> <span style="text-decoration: line-through; color: red;">Server</span> <span style="text-decoration: line-through; color: red;">database</span></b><span style="text-decoration: line-through; color: red;">.</span>&nbsp; <span style="text-decoration: line-through; color: red;">Your</span> <span style="text-decoration: line-through; color: red;">web</span> <span style="text-decoration: line-through; color: red;">server</span> <span style="text-decoration: line-through; color: red;">itself</span> <span style="text-decoration: line-through; color: red;">might</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">in</span> <span style="text-decoration: line-through; color: red;">fact</span><span style="background: SpringGreen;">fully</span> <span style="background: SpringGreen;">managed</span> <span style="background: SpringGreen;">cloud</span> <span style="background: SpringGreen;">service</span>, <span style="text-decoration: line-through; color: red;">have</span> <span style="text-decoration: line-through; color: red;">this</span> <span style="text-decoration: line-through; color: red;">capability</span><span style="background: SpringGreen;">hosted</span> <span style="background: SpringGreen;">by</span> <span style="background: SpringGreen;">TntWare</span>.&nbsp; <span style="text-decoration: line-through; color: red;">So</span> <span style="text-decoration: line-through; color: red;">in</span> <span style="text-decoration: line-through; color: red;">this</span> <span style="text-decoration: line-through; color: red;">case</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">there</span></p> <p><span style="background: SpringGreen;">Let</span> <span style="background: SpringGreen;">us</span> <span style="background: SpringGreen;">know</span>&nbsp;<span style="background: SpringGreen;">if</span>&nbsp;<span style="background: SpringGreen;">you</span>&#39;<span style="text-decoration: line-through; color: red;">s</span> <span style="text-decoration: line-through; color: red;">no</span> <span style="text-decoration: line-through; color: red;">need</span> <span style="background: SpringGreen;">d</span> <span style="background: SpringGreen;">like</span> to <span style="text-decoration: line-through; color: red;">have</span> <span style="text-decoration: line-through; color: red;">a</span> <span style="text-decoration: line-through; color: red;">seperate</span> <span style="text-decoration: line-through; color: red;">database</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">web</span> <span style="text-decoration: line-through; color: red;">server</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="text-decoration: line-through; color: red;">another</span> <span style="text-decoration: line-through; color: red;">replicated</span> <span style="text-decoration: line-through; color: red;">database</span> <span style="text-decoration: line-through; color: red;">somewhere</span> <span style="text-decoration: line-through; color: red;">else</span> <span style="text-decoration: line-through; color: red;">in</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">office</span><span style="text-decoration: line-through; color: red;">.</span><span style="background: SpringGreen;">learn</span> <span style="background: SpringGreen;">more</span><span style="background: SpringGreen;">:</span>&nbsp; <a href="mailto:info@tntware.com"><span style="background: SpringGreen;">info@tntware.com</span></a></p>https://www.tntware.com/donorhub/faqs/en/when-should-we-use-the-replication-model/revision/1.aspxThu, 23 Apr 2009 14:12:21 GMT51c8af77-2ecd-4ae7-b5f5-4793798b888c:180Troy Wolbrinkhttps://www.tntware.com/donorhub/faqs/en/when-should-we-use-the-replication-model/comments.aspxRevision 1 posted to Frequently Asked Questions by Troy Wolbrink on 4/23/2009 2:12:21 PM<br /> <p>The <a href="/tntmpd.dataserver/help/en/pages/deployment_models.aspx">replication model is referred to in the help manual</a>.</p> <p>If your web server is remote, and/or bandwidth was severely constrained between your office and your web server, you should probably use the replication model to overcome this.&nbsp; This means that you&#39;d have a TntMPD.DataServer database on your web server which is replicated locally.&nbsp; This would allow you to connect to&nbsp;your donation system&nbsp;database locally (which you could never do from your remote web server) and pump donations into your local TntMPD.DataServer database.&nbsp; Then you could synchronize those changes with the TntMPD.DataServer database on your web server only sending and receiving changes (so it&#39;s very efficient with bandwidth).</p> <p>If your web server is&nbsp;local (in-house)&nbsp;you probably&nbsp;shouldn&#39;t use the replication model.&nbsp; You probably have a computer somewhere in your office which can <b>run TntMPD.DataServer</b> and <b>have access to both&nbsp;your donation system database and the TntMPD.DataServer SQL Server database</b>.&nbsp; Your web server itself might, in fact, have this capability.&nbsp; So in this case, there&#39;s no need to have a seperate database on your web server, and another replicated database somewhere else in your office.</p>