Hi, I'm using MS SQL server 2005.
I have two identical databases - with one exception: they have different
names (etc database1 and databse2), but their structure is completely same.
Is it possible to replicate one table between those databases?
Regards
2  1593 
zgb (zg***@vip.hr) writes:
I will simplify configuration:
I have two pairs of master - backup servers, each pair is replicated in
both directions (merge replication). Let's call them master1, backup1
and master2, backup2.
Also I have two rooms, room1 (here are master1 and backup1) and room2
(here are master2 and backup2). Databases on all four servers have
completely same structure, but databases in room1 have name db1, in
room2 db2. Between two rooms there is no any replication, imagine two
systems that are working completely separated, each in his own room.
What I want to do is establish replication between two rooms but in way
to replicate only one table - I'll call it myTable. As databases are
identical I have myTable on all four servers. Problem are names of
databases (on room level). Also complete replication inside room1 and
inside room2 must remain. Unfortunately I can't rename databases.
So, result must be: both direction replicated databases on master1 and
backup1, both direction replicated databases on master2 and backup2,
myTable replicated on all four servers.
Thanks for the details! I am very glad that I did not offer any
suggestions to the first question, becase they would all be off.
I would suggest that you post your question to
microsoft.publi c.sqlserver.rep lication, where I believe some people
with very good experience of replication hangs out.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
Erland Sommarskog wrote:
zgb (zg***@vip.hr) writes:
>I will simplify configuration:
I have two pairs of master - backup servers, each pair is replicated in
both directions (merge replication). Let's call them master1, backup1
and master2, backup2.
Also I have two rooms, room1 (here are master1 and backup1) and room2
(here are master2 and backup2). Databases on all four servers have
completely same structure, but databases in room1 have name db1, in
room2 db2. Between two rooms there is no any replication, imagine two
systems that are working completely separated, each in his own room.
What I want to do is establish replication between two rooms but in way
to replicate only one table - I'll call it myTable. As databases are
identical I have myTable on all four servers. Problem are names of
databases (on room level). Also complete replication inside room1 and
inside room2 must remain. Unfortunately I can't rename databases.
So, result must be: both direction replicated databases on master1 and
backup1, both direction replicated databases on master2 and backup2,
myTable replicated on all four servers.
Thanks for the details! I am very glad that I did not offer any
suggestions to the first question, becase they would all be off.
I would suggest that you post your question to
microsoft.publi c.sqlserver.rep lication, where I believe some people
with very good experience of replication hangs out.
I will try at suggested group, thank you for your effort, you are very kind.
Regards This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Thiko |
last post by:
Hi
I have a corrupt PK index on a table column. It is a unique PK. It
needs to be dropped and recreated to cure the corruption.
The table is on a backup database which is in replication having
records added to it to keep the two databases in sync.
Am I correct in think that if I:
|
by: Tom Roos |
last post by:
------_=_NextPart_001_01C349FB.3DE177A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
g'day listers
i run a mysql 4.0.13 master and slave on linux rh 7.3 servers. every now =
and then i get a error on the slave. the error is that it cannot insert =
data into a table that does not exist. the problem is that the table its =
|
by: Craig HB |
last post by:
I have a distributed inventory control database that I am going to
migrate from Access to SQL Server. I am going to use SQL Server
Replication to keep the data current.
There will one SQL Server 2000 database at HeadOffice, and about 200
branches will each have MSDE 2000.
For tables that are the same for each branch (e.g. StockItems,
Suppliers), I'm going to use Transactional replication with the
HeadOffice as Publisher. There is no...
|
by: someguy |
last post by:
I want to replicate a database to a subscriber that will be used as a read
only copy. The data has to be replicated as close to instantly as possible.
To do this I set up a database export of objects and data to populate the
subscriber, then I set up transactional replication. To verify that
replication is working successfully, I count the rows in each table, there
are 3 tables in total. For one of the tables, the replication completes but...
|
by: jaykchan |
last post by:
One of the table that is in a merge replication somehow is missing an
index. Strangely, only the table in one of the subscriber of the merge
replication is missing the index; another subscriber and the publisher
of the merge replication don't have this problem.
How should I add the missing index back to that table? My understanding
is that making structural change on a table that is in
merge-replication is different from making change on...
| | |
by: Good Man |
last post by:
Hi there
I'm developing a large web application. Part of this web application will
be storing numerical chart data in a MySQL table - these numbers will be
already calculated, and are just being stored for reference.
In this particular table, the stored data will never be deleted or
changed. The only actions performed will be SELECTs and INSERTs. There
will never be any DELETEs or UPDATEs.
|
by: David W. Fenton |
last post by:
See:
Updated version of the Microsoft Jet 4.0 Service Pack 8
replication
files is available in the Download Center
http://support.microsoft.com/?scid=kb;en-us;321076
This includes the Jet 4 synchronizer.
This allows anyone to do indirect replication, even without
|
by: Giacomo |
last post by:
Hi,
I’ve the following error message:
---------------
ALTER TABLE .
ALTER COLUMN varchar(10)
Go
Server: messaggio 4929, livello 16, stato 1, riga 1
|
by: Anthony Paul |
last post by:
Hello everyone,
I am involved in a scenario where there is a huge (SQL Server 2005)
production database containing tables that are updated multiple times
per second. End-user reports need to be generated against the data in
this database, and so the powers-that-be came to the conclusion that a
reporting database is necessary in order to offload report processing
from production; of course, this means that data will have to be
replicated...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
