|
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
|
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.
|
|
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.
|
|
Good Day Vicidial Team,
First thanks vicidial team esp. matt / william who always shed some light.
Currently we are running smoothly on our multi server setup using vicibox redux 3.1.9 SVN but in the long run, i know we must have a backup / failover for...
Started by randy_delgado_03 on
, 36 posts
by 6 people.
Answer Snippets (Read the full thread at net):
Would you mind lending a couple of configs / online reference on how to make Master/Slave replication, the replication will work right?
....
We have clients.
Master/slave replication show cause only minimal load on your master server.
|
|
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...).
|
|
How to implement Publishing subscriber Replication topology in SQL?
Started by Aamod on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
What do you mean by ....
Then just go into SQL Management Studio, connect to your source, go to the Replication bit in a similar way.
Also, read through something like for these.
First, work out what kind of replication you want, and so on.
|
|
Let's say I have DatabaseA with TableA, which has these fields: Id, Name.
In another database, DatabaseB, I have TableA which has these fields: DatabaseId, Id, Name.
Is it possible to setup a replication publication that will send:
DatabaseA.dbid, DatabaseA...
Started by MrDustpan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
So, that would roughly.
I don't think this would work with merge replication, though.
View logbased").
|
