Copy SYSTEM_VERSIONING table history's

GailGail Posts: 5 Bronze 1
I need to copy the SYSTEM_VERSIONING data for some of my tables. I am testing partitioning the data. How do I do it?


  • Dan_JDan_J Posts: 299 Silver 1
    Hi @Gail

    Thanks for reaching out to us on this.

    Please correct me if I am misunderstanding your query, but I think you are looking to copy the data from your History table(s)? If that is the case then unfortunately this is currently not possible in SQL Data Compare, as it can only copy the data from the 'parent' table.

    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.