How do I filter by date using SQL Compare?

SQL Compare gives you the option to filter by schema and object name but i need to filter and exclude based on the "Last Modified" column.

Answers

  • hi @GeoRewind,
    I cannot understand why you need a comparison criteria like this one. Does this mean that you change the structure directly in production, so the target database drifts before you release? In a straight release strategy I'd expect a dev/test environment to be ahead than the production, regardless the date in which a column is changed.
    If you change something in the target database, you can "merge back" the changes or resolve conflicts before release the new version of the database.
    Did I get?
    Alessandro Alpi
    CTO @ Engage IT Services s.r.l.
    Database Administrator and Team Leader
    Microsoft MVP - Data Platform
    Staff member of getlatestversion.it community
    personal website | blog
Sign In or Register to comment.