locked
Capturing Replication Article Settings - after the fact RRS feed

  • Question

  • Fellow SQLers

    Walked into a situation where a UAT SQL instance needs to have a db replicated - to the same box.

    The same scenario and same db is setup like this on a prod box.

    I cannot script out the prod pub and sub objects and apply them to uat box because some tables may not be in uat.

    I am rebuilding from scratch. Thus, i am trying to find out what settings were used in prod when the replication WAS initially created. For example, did it include constraints etc etc etc. I know indexes where created but not sure of the other items.

    I cannot see that information when I script out the pub object. Is there a way to find what WAS used?

    Thanks

    MG

    Thursday, March 12, 2020 11:27 AM

Answers

  • There is no way to go back in time and see what was done on Prod.

    • Marked as answer by mg101 Thursday, March 12, 2020 1:33 PM
    Thursday, March 12, 2020 12:35 PM

All replies

  • There is no way to go back in time and see what was done on Prod.

    • Marked as answer by mg101 Thursday, March 12, 2020 1:33 PM
    Thursday, March 12, 2020 12:35 PM
  • Thanks Tom. Unfortunately that is what I thought.

    If I opened up an highlighted article and look at the properties there, does that represent what it WAS or defaults for what it could be now if I wanted to change?

    MG

    Thursday, March 12, 2020 1:34 PM
  • The UI properties show you what it currently IS, not what it was.

    You can script the subscription, the you will have to remove any objects which do not exist in UAT.  The options are all bit mapped fields.  It is very difficult to interpret the scripted values.

    Thursday, March 12, 2020 1:38 PM
  • Thx Tom
    Thursday, March 12, 2020 2:05 PM