Red Gate forums :: View topic - Is it possible to filter on sys.object.modify_date?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

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

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mshupe



Joined: 07 May 2013
Posts: 2
Location: Tampa, Florida

PostPosted: Tue May 07, 2013 9:39 pm    Post subject: Is it possible to filter on sys.object.modify_date? Reply with quote

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.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Fri May 10, 2013 10:42 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group