Is it possible to filter on sys.object.modify_date?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Is it possible to filter on sys.object.modify_date?

Postby mshupe » Tue May 07, 2013 9:39 pm

Our development database has diverged from production. So I would like to take a copy of the production schema and update it with only the changes that have been made to the development database since the beginning of a project or since the last release to production.

I have a query to identify the changes in the development database and now I would like to use it as a filter in SQL Compare instead of selecting the changed objects manually.
mshupe
 
Posts: 2
Joined: Tue May 07, 2013 9:13 pm
Location: Tampa, Florida

Postby james.billings » Fri May 10, 2013 10:42 am

Thanks for your post- this is a nice idea, but unfortunately there's no way to currently achieve this with SQL Compare.

If you can run the query yourself to get the objects you could probably work out a way to output these into a list in the correct format for our command line to use, with the "Include" switch (see here for an example) but unless you have thousands of objects it's likely to be quicker just to manually select them.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest