I have three servers with own databases, and database schemas are same. Let's call them servers A, B and C.  All three servers will be operational, which means that all three servers will serve for its region.  Data from servers B and C need to be replicated on server A, so that server A will contains data from all servers, but other two servers contain just own data.  I need to implement some replication solution to achieve this goal, and I am asking if it is possible to have two publishers (server B and C) and one server with two subscription (server A)? Is there any better solution? Which replication model will be the best?
I have 8 individual SQL Server 2008 R2 machines, each hosting 1 database. Each database has an identical table structure and schema, and entirely unique data.  I would like to establish a reporting server (may be 2008 or 2012), that consolidates the rows  from selected tables across the 8 source servers into a single instance of those tables on the reporting server. This is one-way replication (no changes will be made to the reporting server). I will need to replicate changes from the source databases with relatively low latency (say 20-30 seconds).  Furthermore, I'd like to find methods to achieve this with as little impact to the source servers as is practical.  3rd-party agents, triggers, or schema mods to those servers are difficult in my environment.  My questions:   What are promising architectures and technologies for  achieving this goal?  I've looked at SQL Server Merge Replication, but I am concerned about latency. Is this an appropriate technology for this goal? Are there many-to-one architectures for transactional replication?   Should I be looking at 1-to-1 replication into 8 databases on my reporting server, followed by some custom merge function (a 2-step replication)?   Thanks, John
Calculation of $\lim_{n\to \infty}\prod_{r=1}^{n} \left(1+\frac{r}{n}\right)^{\frac{1}{n}}$ Calculation of  $\displaystyle \lim_{n\to \infty}\prod_{r=1}^{n} \left(1+\frac{r}{n}\right)^{\frac{1}{n}}$  $\bf{My\; Solution::}$  Let $y=\displaystyle \lim_{n\to \infty}\prod_{r=1}^{n} \left(1+\frac{r}{n}\right)^{\frac{1}{n}}$, Now taking $\log_{e}$ on both side  $\displaystyle \log_{e}(y) = \lim_{n\to \infty}\log_{e}\left(\prod_{r=1}^{n} \left(1+\frac{r}{n}\right)^{\frac{1}{n}}\right)=\lim_{n\to \infty}\frac{1}{n}\cdot \sum_{r=1}^{n}\log\left(1+\frac{r}{n}\right)$  Now Using Reinman Sum of Integral ...  $\displaystyle \log_{e}(y) = \lim_{n\to\infty}\frac{1}{n}\cdot \sum_{r=1}^{n}\log\left(1+\frac{r}{n}\right) = \int_{0}^{1}\ln(1+x)dx = \log_{e}(4)-\log_{e}(e) = \log_{e}\left(\frac{4}{e}\right)$  So $\displaystyle y =\lim_{n\to \infty}\prod_{r=1}^{n} \left(1+\frac{r}{n}\right)^{\frac{1}{n}} =\frac{4}{e}$  But how can i solve above question using Stirling Approximation,  May I ask for help?  Thank you in advance! Why does flag marking as helpful/declined not always correlate with moderator action? Feynman diagram for attractive forces Basically, I acidentally spawned too many ArmorStands due to a wrong code writing , resulting in the game crashing, and wanted to know how to delete those armorstands from the World save folder. They hava names and I belive they also have a scoreboard set, if that helps.   I have already tried to open the world but it crashes, I tried to open a server (Since it worked the last time I tried it) and killing it all from the console but, different from the last time, it crashed before killing them and now I just tried MCedit but it crashes as well. I encountered such a formula for pooled variance:  $$\frac{(n-1)s_x^2+(m-1)s_y^2}{n+m-2}\left(\frac{1}{n} + \frac{1}{m}\right)$$  Here we have two samples of the following sizes $n$ and $m$. $s_x, s_y$ are the sample variances.  I understand that the first term is a weighted average, but from the second term comes? PHP: Right way to declare variable before use in loop I have a variable that is built in loop. Something like:  $str = ""; for($i = 0; $i &lt; 10; $i++) $str .= "something";   If $str = "" is ommitted, I get undefined variable notice, but I thought php auto-declare a variable the first time it sees undeclared one?  How do I do this right? What are the details of "Objective-C Literals" mentioned in the Xcode 4.4 release notes? How many Shutter Clicks on a New Camera considered normal? How many Shutter Clicks on a New Camera considered normal?    I purchased a quotes new Nikon D750 and checked the shutter count and it has 264 Shutter Clik count on it.    Is that suspect of a returned purchase or used camera? $a^2b^2+a^2c^2+b^2c^2\leq 3$ Let $a, b, c\geq 0$ s.t.$$(a^2-a+1)(b^2-b+1)(c^2-c+1)=1$$  Show that $ a^2b^2+a^2c^2+b^2c^2\leq 3$.  My idea:  I denote $a+b+c=x$, $ab+bc+ac=y$ and $abc=z$.  Then I have $$x^2+y^2+z^2-xy-xz-yz+2z-y-x=0$$ I have to show that $$y^2-2xz\leq 3$$ I tried to prove it with the sign of trinom, but it doesn't work. Generator expressions vs. list comprehensions Correct way of mounting a Windows share I mounted a Windows share to my Ubuntu 11.10 system via adding the following line to the /etc/fstab:  //serveraddr/sharedfolder /mnt/foldername/ smbfs credentials=/home/myname/.smbpasswd 0 0  using the .  But there's a problem with the permissions. The owner of the mount folder is root. I can not create any folders or files in the mounted point is I don't become the root. Even I can not change the ownership to my default user via   sudo chown -R myname .  I googled and saw that it might stem from the fact that Windows file formats (fat32/ntfs) can not save ownership. But when I connect to the same location via samba as   smb://serveraddr/sharedfolder  by providing my credentials, I have the privileges to write without being the root.  How can I make it to let me write to the mounted folder? Why is part of my model not being rendered? What are the basic rules and idioms for operator overloading? How do I build a loop in JavaScript? How can I build a loop in JavaScript? Arriving at a different port of entry in the same state in USA? How to ignore everything in the document environment? How can I automatically save screen shots by the press on the Prt Scr button? I want a screen shot to be saved automatically to a location I specify, as soon as I press the Prt Scr button on my keyboard, or the Alt+Prt Scr combo. I also want the date and time to be used as file name for each new screen shot. And I want the files to be saved as PNG images.  Is there a Windows program that would allow me to do just this? I don't want any other fancy features like editing and making notes, etc. just a plain simple program that will either automatically save the screen shots to a pre-set location or prompt me where I want to save it. I don't want to go through MS Paint to save the shots.  I guess what I'm after is a little bit of Linux behavior of Print Screen, but only for Windows. And I additionally want the files to be named by the date and time they were taken.  Update:  Meanwhile, I have found one called Greenshot. But I don't know how to get the file name pattern right.  This is the default pattern.  ${capturetime:d"yyyy-MM-dd HH_mm_ss"}-${title}   Can someone explain this? Why do they have the title capturetime and the quotation marks? It produces file names like this.  2013-01-26 15_24_28-Greenshot.png   And this is what it says about the file patterns in the program description.  ${YYYY} year, 4 digits ${MM} month, 2 digits ${DD} day, 2 digits ${hh} hour, 2 digits ${mm} minute, 2 digits ${ss} second, 2 digits ${NUM} incremental number, 6 digits ${title} Window title ${user} Windows user ${domain} Windows domain ${hostname} PC name   How do I get files that include year, month and day, separated by a dash, followed by hour, minute and second? I want to include a time for uniqueness of the file name. Show that $\left(1+\dfrac{1}{n}\right)^n$ is monotonically increasing Facebook OAuth Data Capturing I have the amulet of Mara but when I go to talk to maramal about a wedding nothing shows up. WHY is that.