Can I ask how you would ideally like to specify a filter? We're reviewing this area for the next release and would ideally like to make it as usable as possible.
Michelle: Your suggestion to use EMT.* results in anything with EMT in the name being excluded. I need for the objects that begin with EMT to be excluded. Do you have any other ideas?
David: You asked how we would like to specify the exclude filter for consideration in future releases. Ideally, what I would have liked to do is this:
/exclude:ALL:EMT.* in order to exclude all objects that start with EMT.
"/exclude:ALL:EMT.*" should indeed work! You should be able to filter by 'All' as well as per object type. Please let us know if this doesn't work. To see all the full set of command line options, do the following:
David --
Using "/exclude:ALL:EMT.*" works too good -- it removes all objects that have EMT anywhere in the name. I need to exclude only object that begin with EMT. Do you have any other ideas?
No problem at all. If you want to do anything complex or tricky, there are many websites that offer help on regular expressions. Here's just one of them which I got by typing "how to write a regular expression" into Google: http://geekswithblogs.net/brcraju/articles/235.aspx
Comments
The exclude you're looking for is something like /exclude:Table:EMT.*
Redgate Software
Can I ask how you would ideally like to specify a filter? We're reviewing this area for the next release and would ideally like to make it as usable as possible.
Thanks,
David
Product Manager
Redgate Software
David: You asked how we would like to specify the exclude filter for consideration in future releases. Ideally, what I would have liked to do is this:
/exclude:ALL:EMT.* in order to exclude all objects that start with EMT.
"/exclude:ALL:EMT.*" should indeed work! You should be able to filter by 'All' as well as per object type. Please let us know if this doesn't work. To see all the full set of command line options, do the following:
sqlcompare.exe /help /verbose /html >help.html
and open up help.html in your browser.
David Atkinson
Red Gate Software
Product Manager
Redgate Software
Using "/exclude:ALL:EMT.*" works too good -- it removes all objects that have EMT anywhere in the name. I need to exclude only object that begin with EMT. Do you have any other ideas?
Thanks.
Abbe
Try something like this:
exclude:ALL:.*\].\[EMT.*
David Atkinson
Red Gate Software
Product Manager
Redgate Software
That works! I never would have figured that one out. Thanks a bunch.
Abbe
Kind regards,
David Atkinson
Red Gate Software
Product Manager
Redgate Software