Programmatic identity??? -- sql server replication

Todd
1/14/2004 6:18:35 AM

Is there a way to programmatically copy a record to
another server/database and keep the same guid value that
is added for replication? Put another way... replication
adds its guid field and I need to copy the records exactly
as they are in the source database to another
server/database.

I can't set replication up between these cause they're
MSDE. MSDE can't be publisher from what I understand.

Thanks,

johnston NO[at]SPAM mounet.com
1/14/2004 11:46:31 AM

You can publish with MSDE. MSDE doesn't support publishing of
TRANSACTIONAL replication because it doesn't have a log reader. Merge
and Snapshot publications are available as well as subscriptions to
Transactional replication.

If you need Transactional publication, then you must acquire at least
SQL
Server Desktop

V/R Jim Johnston
MCSD.NET, MCDBA

[quoted text, click to view]

Hilary Cotter
1/15/2004 7:57:01 AM

merge replication adds the GUID column. This GUID column will have the same
value across all publishers and subscribers.

So if tablexyz row 54 on the publishers has a guid value of
XXXX-XXXX-XXXXX-XXXX, the GUID value will be the same for tablexyz row 54 on
all subscribers.

If you are using transactional or snapshot replication, ensure the default
NEWID() is not replicated in the schema to the subscribers.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Programmatic identity???