Post reply

ROWGUIDCOL

  • August 1, 2006 at 1:25 pm

    #173529

    Can someone clear a question up for me about replication and the Rowguidcol?

     

    From my understanding it is not nessessary to use the RowguidCol unless one has the same database scheme set on different servers( or different locations&nbsp

    From my understanding the RowguidCol is used to be able to track table cols with the same scheme on different servers ( or differenct locations&nbsp when useing replications.

    From my understanding replication is a process that involes distributiong copies of one scheme two different locations?

     

    *My understandings are cloundy 

     

    Thanks alot.

    erik

    Dam again!

  • August 1, 2006 at 3:53 pm

    #652692

    As I understand it :-

    If you don't create a rowguidcol on your table, SQL Server will do it for you.

    the Rowguidcol is the column that is referenced within the meta tables that keep track of the changes to data so it knows what to update/insert/delete

    This may all depend on the type of replication you use - Snapshot, Transaction, Merge.

    I am most familiar with Merge so my understanding may be clouded.

    In Snapshot, you are typically working with a copy of the master database and any changes you make will not go back to the master server

    In Transaction, changes move back and forth between connected servers in "real" time.

    In Merge, changes at either end are merged when a connection is available and a sync is requested.

    HTH

    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others

  • August 1, 2006 at 4:13 pm

    #652697

    Hey man thank you very much for the reply

    If you can help me with one more question to this topic&nbsp

    In the new 2005 i have added the AdventureWorks database and in some of the tables they have the RowguidCol.. Is is posible that you can tell me why the Rowguid is used in the specific database senerio?

     

    Erik

     

    Dam again!

  • August 1, 2006 at 5:05 pm

    #652704

    I can only assume it has something to do with the tutorials and samples - which I haven't looked at yet.

    I would presume one of these tutorials might be related to replication in some way and they have set up the tables in preparation for this.

    Certainly the tables I looked at were the Sales ones - very likely candidates for replication.

    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others

  • August 1, 2006 at 5:27 pm

    #652706

    thanks again steve!

     

    erik

    Dam again!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply