Replication Sql 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kapil - 14 Dec 2006 04:50 GMT

Hi,
1. Can we replicate tables with no primary Key. Will Sql server add some
type of constraint in tables.
2. Can we replicate Bitmap/Blob data.

What kind of replication is suitable for these scenario

Reply to this Message

Paul Ibison - 14 Dec 2006 09:28 GMT

With no PK you can cross off transactional replication. Both merge and
snapshot will cope with BLOBS. Merge will add check constraints for identity
ranges and triggers, while snapshot won't change the schema. There are other
factors in selecting the appropriate method - can the subscriber alter the
data? Do you need offline access etc.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Reply to this Message

kapil - 27 Dec 2006 08:51 GMT

Hi Paul,
Thanks. Also can you please suggest
1.) For 150 GB database on Sql 2005 what is the best way to have a warm
stanby server. What methodology is suitable for this kind of
scenario(Replication , mirroring etc). I don't have PK for half the tables.
2) We can cope with 70-80 min delay.

kapil

> With no PK you can cross off transactional replication. Both merge and
> snapshot will cope with BLOBS. Merge will add check constraints for identity
[quoted text clipped - 3 lines]
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .

Reply to this Message