Replication issue

[Rickspx]

Hi,

I had posted this yesterday, but since I didnt get any response Iam posting it again.

Iam having a SQL database replicated to a webserver.It is using snap shot repl and the prob now is that as the
data grows it takes time when the snapshot is applied, so the webcontent goes blank for abt 3-4 mins.I had first tried
transactional , but as some tables doesnt have a key(PK) , snapshot was selected.
Is there a work around for this.?Will a DTS package do what is needed here?I have not worked with DTS
on large tables.Will there be performance issues?Plz Help

Thanks
Rick

 

[ClaireHCM]

choices

snapshot does a BCP out and then BCP in . so it is faster. But in DTS you can assign many processes parallely. you have 3 other choices

1. create trigger on all tables which you want to be replicated which inturn inserts rows to the tables in the webserver.

2. create trigger on all tables which you want to be replicated which inturn inserts rows to a staging table and process the staging table to insert into webserver.

3. add PK columns to all tables identity or newid() and do transactional replication

 

[Rickspx]

claire,

I have also been thinking on ,going according to No.3
Thank you for the suggestion

Rick