Post reply

Snapshot Replication to Heterogenous Destinations

  • November 20, 2002 at 10:18 am

    #81248

    With SQL7, the processing was in the order of Create Tables, Copy Data, Create Indexes.

    With SQL2000, the processing changed to

    Create Tables, Create Indexes, Copy Data.

    Have I missed something with the setup or am I doomed to massively longer replication times?

    I've toyed with the idea of not copying non PKs and subsequently firing a script off to generate the other indexes.

    Ideas welcome!!

    Thx,

    Paul

  • November 21, 2002 at 7:42 pm

    #442056

    I really like the feature added in 2K that lets you run pre/post snapshot scripts. Great place to customize things. In practice I rarely want the same indexes on the subscriber that I have on the publisher.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

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