yukon's transactional replication

Hi yukon gurus,

Does yukon transactional replication supports immediate update on subscriber with text, image and binary data types?

tnx and regards,
ArisenX

?

[638 byte] By [ArisenX] at [2007-12-17]

«« Exception when sending larger amount of Data
»» Password prompt craziness..

# 1

Hi ArisenX,

Immediate update of text/ntext/image at subscriber will not be replicated to the publisher. Update of binary types is supported.

For a complete list of considerations for updatable subscriptions for transactional replication, you can refer to BOL topic "Updatable Subscriptions for Transactional Replication".

Thanks,
-Peng

PengSong at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server Replication...

# 2

Immediate update of text/ntext/image at Publisher will not be replicated to the Subscriber?

ArisenX at 2007-9-8 >

# 3

Yes, changes to the publisher will be replicated to the subscriber, provide you do not use WRITETEXT and UPDATETEXT.

GregYvkoff at 2007-9-8 >

# 4

tnx, my present setup is transactional replication with immediate update(push) subscription, will this be ok if my publisher is SQL 2000 and the Subscriber is SQL 2005? tnx

ArisenX at 2007-9-8 >

# 5

Although it's not documented clearly anywhere, yes it's supported provide publisher/distributor is SP4 or higher.

GregYvkoff at 2007-9-8 >

# 6

thank you very much for all the response, i'll test it and i'll send a feed back... best regards and more power to all of us!

ArisenX at 2007-9-8 >

SQL Server

SQL Server Replication

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'yukon's transactional replication...'

yukon's transactional replication

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified