Skipping compare and Apply a filter

JeffCzyzJeffCzyz Posts: 2
edited December 12, 2005 12:51PM in SQL Data Compare Previous Versions
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

Comments

  • 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.
This discussion has been closed.