locked
Create Tombstone Table? RRS feed

  • Question

  •  

    Hi,

     

    I am trying to create tombstones tables for my database.

     

    I tried to script the table i want to make a tombstone for. Then change the name to table_Tombstone and run the script, with the intention of adding the timestamp columns after.

     

    Im having problems with the constrainsts.

     

    What is the easiest way to create tombstone tables?

     

    Thanks,

    Ali.

    • Moved by Max Wang_1983 Friday, April 22, 2011 9:17 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Monday, December 17, 2007 11:12 AM

Answers

  • Hi Ali.

     

    The tombstone table is just a container. Try to avoid adding referential integrity constrains for the tombstone tables. It will cause unnecessary problems and won't add much value to your app.

     

    Thanks

    Monday, December 17, 2007 7:01 PM