Red Gate forums :: View topic - Filter - allow filtering by modified 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

Filter - allow filtering by modified date

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



Joined: 19 Feb 2014
Posts: 2

PostPosted: Wed Feb 19, 2014 3:10 pm    Post subject: Filter - allow filtering by modified date Reply with quote

Dear Redgate

Be neat (really) to be able to either

1) filter on not just shema/name etc but modified/created date? (ie the objects that have been modified recently)

2) tell me how i can modify the xml/scp to add a few lines in to do this (ie provide a list of included objects). then i can just run....

select name,create_date,modify_date, 'S' as typ
from sys.procedures
union
select name,create_date,modify_date, 'T' as typ
from sys.tables
order by typ, modify_date desc

and paste in the values into the project?

Oh....did i mention the large licensing order we may be about to make Wink (sorry thats bribery right?)
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 889
Location: Red Gate Software

PostPosted: Fri Feb 21, 2014 5:22 pm    Post subject: Reply with quote

Thank you for your forum post.

With regards to this request:
Quote:

1) filter on not just shema/name etc but modified/created date? (ie the objects that have been modified recently)


I have submitted a Feature Request whose reference is SC-6884. I cannot guarantee the success of the future request or if approval is given, what future version of SQL Compare it will appear here.

I recommend that you take a look at the User Voice FORUM for SQL Compare and if necessary post a new topic. The user voice forum is the preferred method of submitting a feature request and is actively monitored by the Red Gate Product Managers. The more votes a topic receives from other SQL Compare users, it will increase the chances of it appearing in a new version of the application.

With regards to the second request:
Quote:

2) tell me how i can modify the xml/scp to add a few lines in to do this (ie provide a list of included objects). then i can just run....


Sadly you cannot filter before the comparison, as SQL Compare needs to see all the objects to work out the dependencies between objects. I have added the details of this forum post to an existing request whose reference is SC-2471. Once again please check the user voice forum and a comment or new post as required.

You can however using the command line xml file using the <include> and <exclude> switches determine which objects you wish to deploy but you cannot base this around the modify or creation date. For example:
Code:


To compare only tables containing the word "Product" except for the "ProductHistory" table:

Using an XML file:

<?xml version="1.0"?>
<commandline>
<database1>FirstDatabaseName</database1>
<database2>SecondDatabaseName</database2>
<include>Table</include>
<include>Table:Product</include>
<exclude>Table:ProductHistory</exclude>
</commandline>



Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
ronweston



Joined: 19 Feb 2014
Posts: 2

PostPosted: Fri Feb 21, 2014 5:42 pm    Post subject: Reply with quote

Cheers Eddie, good reply makes sense.

Look forward to any possible enhancement, thanks once again
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