How do I filter by date using SQL Compare?
GeoRewind
Posts: 2 Bronze 1
in 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.
Tagged:
Answers
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?
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