473,385 Members | 1,396 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Replication - Single Publication versus Multiple Publications

We are looking to implement merge replication on our global databases.
The decision that we must make is whether to place all of the tables in
a single publication, to create publications that are grouped by system
modules, or to create a publication for each table. What I am looking
for is best practices or recommendations based on your experience as
far as what approach to take on this. The database contains
approximately 300 tables. Each approach offers advantages and
disadvantages. The biggest disadvantage on the single publication is
flexibility. The biggest disadvantage on each table being a
publication is maintainability. Is there a scalability issue with
either of these approaches? Do all records that have foreign key
constraints have to be in the same publication?
Any guidance is very much appreciated.

Thanks,
Kent

Jul 23 '05 #1
0 1349

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Damian H | last post by:
Hi, For some magical reason, my database replication has suddenly stopped working. I modified the publication but the Distribution agent will not run; the snapshot does not get applied to the...
1
by: war_wheelan | last post by:
I have a TSQL script to add daily tables to replication and then run the snapshot agent to distribute them to two subscribers. The script executes without errors, but when I check the running jobs...
1
by: ansonee | last post by:
I'm experiencing some very odd behavior in Enterprise Manager. I have a process that performs the following: 1.) Restores a published database from Server A onto Server B. The databases are...
0
by: mfahnestock | last post by:
Hi all! Having a major quandry and looking for some support. Please help. Here's the goal: * PocketPC device gathers various data and needs to merge with Enterprise SQL Server * I have the...
4
by: R.A.M. | last post by:
Hello, I am learning SQL Server 2005 Express. I need to test replication but when I run New Subscription Wizard I got error: "There are no publications to which you can subscribe, either because...
3
by: bourgon | last post by:
I'm getting this, after upgrading from 2000 to 2005. Replication-Replication Distribution Subsystem: agent (null) failed. The subscription to publication '(null)' has expired or does not exist....
2
by: Query Builder | last post by:
Hi, I have transactional replication set up on on of our MS SQL 2000 (SP4) Std Edition database server Because of an unfortunate scenario, I had to restore one of the publication databases. I...
0
by: shgzs33 | last post by:
I have 2 SQL 2005 Servers SERVER1 and SERVER2 and want to establish a replication betwwen them: SERVER1 as Publisher and SERVER2 as subscriber. the problem is that SERVER2 is runnint on port...
0
by: surchau | last post by:
Hi, I am using MS SQL 2005, I had created publication and had 2 subscribers to the publication. Due to some reason I had to delete all the publications. Now I am trying to create new...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.