SQL Server Performance

Adding tables to SQL Server 7 Replication

Discussion in 'Performance Tuning for SQL Server Replication' started by cchitanu, Dec 18, 2003.

  1. cchitanu New Member

    If you need to create new tables and add them to existing snapshoot replication(SQL Server 7)is this posible using only EM ?
    What about the subscriber, it is necessary to create the new tables there first and then syncronyze with the publisher ?
    Thanks in advance for your help
    Cristian
  2. satya Moderator

    In ver.7 you must synchronize for any kind of schema changes.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. cchitanu New Member

    Thanks Satya,
    So the normal process will be :
    1. Add the new tables at the publisher
    2. Create the new tables to the subscriber
    3. Configure replication to add the new tables as new articles
    4. Syncronize the subscriber with the publisher

    Do you have an option in EM for number 4 ? If not how you do the syncronization ?

    Best Regards
  4. satya Moderator

    I have never carried out this operation using EM and always rely on TSQL statements where you will get to know ore about process rather than depending upon GUI tool.

    ANd I think using ver.7 you may not have much option to do the task.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  5. cchitanu New Member

    Hi Satya,
    Which store procedure do you use to syncronize the subscriber with the publisher ?
    Thanks
  6. satya Moderator

    Each time the Snapshot Agent runs, it creates schema and data files to be sent to Subscribers.
    The agent appends rows to the MSrepl_commands and MSrepl_transactions tables in the distribution database. The entries in the MSrepl_commands tables are commands indicating the location of the synchronization set (.sch and .bcp files) and ordered references to any specified pre-creation scripts. The entries in the MSrepl_transactions table are commands referencing the Subscriber#%92s synchronization task.


    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page