WHERE clause for just one of the databases?
bcallahan
Posts: 3
I am am doing a data compare for 2 databases, SOURCE and TARGET. They both have a field which contains a date. I want to include a where clause (datefield>5/26/2008) that works gets applied to just the SOURCE database, not both. Is this possible through the gui?
Comments
Yes, it's pretty easy to do. Just uncheck the use the same where clause for both databases checkbox, then you can enter a different where clause for each database.