Re: Replication - GUID:s....

From: Jack MacDonald (jackMACmacdonald_at_telus.net)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 15:56:24 GMT

To answer directly, it is not necessary to use GUID instead of
counters.

Background: If your tables use conventional (ie., incremental)
Autonumbers as the primary key, then they will be converted to
"random" autonumbers after applying replication. Accordingly, if you
have used your primary key in a "meaningful" way before replication,
then they will become less useful after replicaiton because of their
random nature.

However, it is strongly recommended to never use autonumbers in a
"meaningful" way (e.g., invoice numbers, order numbers) because they
are never guaranteed to remain sequential ("holes" may develop). You
should always use your own method for creating identifiers such as
invoice numbers.

On Tue, 28 Dec 2004 21:53:28 GMT, "Andreas Andreasson"
<andreas.andreasson@telia.com> wrote:

>Hi all!
>I have a newbiequestion about GUID:s. Is it necessary to use GUID instead of
>ordinary counter when you make the replication. I have problems with my
>counters - long integer. The will not automatically count when I use the
>replication method. I have not transformed the counter to GUID:s. Anybody
>knows if it is necessary or recomended to change to GUID. I'm sorry about my
>English I'm from Sweden so English is not my nativelanguage.
>

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Relevant Pages

  • Monitoring replication
    ... We're suffering from SQL replication issues - every now and again, ... replication dies, citing "General Network Error" as the cause. ... idea which performace counters to watch - there doesn't seem to be a handy ...
    (comp.databases.ms-sqlserver)
  • Monitoring Replication
    ... We're suffering from SQL replication issues - every now and again, ... replication dies, citing "General Network Error" as the cause. ... idea which performance counters to watch - there doesn't seem to be a handy ...
    (microsoft.public.sqlserver.replication)
  • Re: ABNORMAL Transactional Replication behaviour
    ... Run this in the distribution database to ... If they aren't run sp_repltrans in your publication database. ... Looking for a SQL Server replication book? ... > assign a range to this counters and the replication blocks itself before ...
    (microsoft.public.sqlserver.replication)
  • Re: Replicated data traffic excessive given data changes.
    ... can you confirm this result using Pefrmon by selecting the replication ... perhaps you can make half a dozen changes (in isolation) to a ...
    (microsoft.public.sqlserver.replication)