Filter - allow filtering by modified date

Forum for users of SQL Compare schema synchronization utility

Filter - allow filtering by modified date

Postby ronweston » Wed Feb 19, 2014 3:10 pm

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 ;-) (sorry thats bribery right?)
ronweston
 
Posts: 2
Joined: Wed Feb 19, 2014 3:06 pm

Postby eddie davis » Fri Feb 21, 2014 5:22 pm

Thank you for your forum post.

With regards to this request:
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:
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: Select all

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
eddie davis
 
Posts: 995
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby ronweston » Fri Feb 21, 2014 5:42 pm

Cheers Eddie, good reply makes sense.

Look forward to any possible enhancement, thanks once again
ronweston
 
Posts: 2
Joined: Wed Feb 19, 2014 3:06 pm


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests