Re: Replication, GUIDs and PKs

Tech-Archive recommends: Speed Up your PC by fixing your registry

If the data flow is in one direction you could use transactional
replication. This way you wouldn't be forced to use the GUID for pks. If it
is bi-directional you should use merge replication and the GUIDs would be
essential. Unfortunately unless you are careful merge replication will add
its own guid column to use as a pk.

The question is do you want to rip out what is in place and replace it with
replication. It sounds like a big undertaking.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Michael MacGregor" <nospam@xxxxxxxxxx> wrote in message
news:%23J82i3M3GHA.1548@xxxxxxxxxxxxxxxxxxxxxxx
Here's an example table, which other than the name, I pulled directly from
the database:

CREATE TABLE [dbo].[MacExample](
[ID] [uniqueidentifier] NOT NULL,
[CreateDate] [datetime] NOT NULL,
[Status] [tinyint] NOT NULL,
CONSTRAINT [PK_Accounts] PRIMARY KEY CLUSTERED
([ID] ASC) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

I discovered on Monday that SQL Replication is not being used at all,
instead it is a home-made remedy using MSMQ. Not sure how many subscribers
there are but there are multiple databases, and for each database there
are multiple subscribers, but subscribers do not subscribe to multiple
databases so the subscribers for one database are at entirely different
locations thatn subscribers for another database. For one of the
databases, I believe there are approx. 30 subscribers.

Michael MacGregor
Database Architect



.

Relevant Pages

  • Re: replication server crashed
    ... I am unsure what state your replication topology is in. ... If the database is restored and the master, distribution, and msdb database ... the subscribers will fill in missing transactions in the ... keep_replication switch while restoring these databases. ...
    (microsoft.public.sqlserver.replication)
  • Stored Procedure failed with Invalid Cursor State problem
    ... I have a database that is being merge replicated between 1 publisher and 2 ... One of the tables in this database has it's replication ... change log table that are relevant to that record to force the record to its ... One of the subscribers is frequently disconnected for a ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge or Trans with QUS best when publishing partitions of database to slow subscribers
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The publisher will be SQL Server 2005 and all the subscribers will be SQL ...
    (microsoft.public.sqlserver.replication)
  • Re: Restore published database
    ... subscribers will backfill the missing information. ... For a transactional publication, the log reader will complain, and your best ... Looking for a SQL Server replication book? ... > I need to restore published database from backup. ...
    (microsoft.public.sqlserver.replication)
  • Re: Queued Updating Subscribers Question
    ... > the column you are referring to is not an identity column - ... > it is a GUID. ... > letting replication do the initialization for you, ... > ps if you don't intend having subscribers update the data, ...
    (microsoft.public.sqlserver.replication)