Post reply

Snapshot w/o data

  • July 14, 2004 at 12:39 pm

    #102113

    Hello, I am creating a transactional replication using script. I need to create the snapshot but I don't want any data to be copied over intially. Is there anyway to do that?

  • July 14, 2004 at 8:16 pm

    #514590

    I would say that you would have to:

    1) Script a target database construct with all the tables etc.

    2) Script the subscription using the "Subscriber already has the schema and data" setting (Sorry dont know the script syntax for this but its either @allow_sync_tran = N'false' or @autogen_sync_procs = N'false').

    3) Script the requried settings on the target database using the "manual synchronize" instructions in the MS article 320499.

    4) Start it up.

    Sorry if this is a bit vauge but I have never had to script this before.

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

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