Skipping compare and Apply a filter

JeffCzyz

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

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.