How can we help you today? How can we help you today?

Skipping compare and Apply a filter

I have a brand new DB that I would like to populate. I know the new tables are empty, is there a way to skip the compare and just do the syncronization?


Further, is there a way to apply a filter or WHERE clause? I'd only like to move data that is newer than a certain age.

Thanks

Jeff
JeffCzyz
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hello Jeff,

    Data compare needs to compare before synchronizing. However, comparing a populated table to an empty one does not take any more effort that simply scripting the table's contents.

    The easiest way to filter data in a data comparison is to build an indexed view on the table, then compare indexed views. You can also synchronize through the indexed view.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.