|
Hi folks, please help me in evaluating new possibilities with MS SQL Server 2008. For the last 3 years I have had an MS SQL 2000 Server Merge Replication with a Publisher and two Subscribers on duty, the backup of the database on one instance is as big...
Started by Ice on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
In peer-to-peer, all nodes are both ....
It can be, but be aware of some big differences between the approaches:
Merge replication involves one publisher and multiple subscribers.
Yes Peer to Peer can be a replacement for merge replication.
|
|
I need to set up this scenario:
A SQL Server 2005 database will create a transactional replication subscription from another database to populate a set of lookup tables. These lookup tables will then be published as a merge replication publication to ...
Started by alextansc on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I do not get the interest of having a transactional replication to generate lookup tables + merge replication when you don't have the data modified by the subscribers?
Maybe the original that the lookup tables are replicated to another....
|
|
What is difference between 3 type of replication? Is replication suitable for data archiving? What is the replication steps?
Started by masoud ramezani on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Merge replication is primarily; and integration of data from multiple sites....
See http://msdn.microsoft.com/en-us/library/ms151198.aspx
From MSDN :
Transactional replication; integrating heterogeneous data; and offloading batch processing.
|
Ask your Facebook Friends
|
What's the difference between peer-to-peer replication and merge replication using SQL Server?
Started by Guy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Merge replications....
Merge replication lets you with the peers.
Transactional and Snapshot replication move data from publisher intensive every time it runs because it generates a new snapshot every time.
Way - from publisher to subscriber.
|
|
I want to have a version of my db that contains all of data from first to now. If I use sql server replication, can I force that to ignore delete operation for replication?
Started by masoud ramezani on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
What if instead of UPDATE one does DELETE and INSERT ? Your target database will not be able to handle such change because it will not delete a row with some unique... .
And I would be surprised if one exists out of the box .
I am not aware of such feature.
|
|
I am running dual master MySQL replication and now want to move to a single database with no replication. How do I completely disable replication on both databases?
Started by David Collie on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Editing the my.cnf file alone is not sufficient to disable replication....
To completely disable replication with a master-master setup, you in the my.cnf, since replication can be setup dynamically as well.
Master-port=3306*
Restart MySQL.
|
|
What are adverse affects to using replication What are some examples of when replication is beneficial
Started by squillman on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
Replication is quite will determine the specific type of....
If you have to shut off replication for any reason and restart it (or, just starting the first time and running (and left alone), it's not noticeable though (at least not for us).
|
|
One main issue with MySQL replication is that the slave is single threaded. This can cause replication lag.
How does Postgresql handle replication? Does it (or add-on such as slony-I) allow multi-threaded slaves?
In general, what are the pros and cons...
Started by Continuation on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Multithreading replication is a very complicated problem to solve because you have to ensure that out of order updates do.
All replication that I'm aware of for Mysql and Postgres is single threaded.
|
|
We have merge replication set up over a distributed environment (50 to 1500km between offices) for a SQL Server 2005 database of about 350Gb. We now need to add a couple of new tables that must also be in replication, but without pushing the new snapshot...
Started by Veldmuis on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Now: if you want, you should restart the replication....
First create your database before replication, make sure you create a few extra tables the replication, including these 5 tables (or more: last time we created 100 extra ones...).
|
|
Hi,
we have a 500gb database that performs about 10,000 writes per minute.
This database has a requirements for real time reporting. To service this need we have 10 reporting databases hanging off the main server.
The 10 reporting databases are all fed...
Started by David E on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I tend to view replication to the point where you can't escape replication....
The benefit that if, heaven forbid, your reporting system's replication does max out it won't affect can, scaling-up is usually a better way to go than scaling-out.
|
