Support for free-form object filter?
Johan Van Hoye
Posts: 12
Hi,
I have a fairly large database schema -- around 700 tables
SQL Compare (and the reports it generates) becomes fairly slow with that size database.
We use a naming convention to logically group related tables, so it would make a lot of sense to me to be able to perform a comparison by area. So I'd like to be able to specify a free-form filter mask to eliminate "fat" from the comparison:
/* example 1: only tables in functional area xyz */
object_name LIKE 't_xyz%'
/* example 2: only tables with the column "customer" in them */
object_name IN (SELECT object_name(id) FROM syscolumns WHERE name = 'customer')
etc.
can this already be done now, or can it be added as a feature request?
I have a fairly large database schema -- around 700 tables
SQL Compare (and the reports it generates) becomes fairly slow with that size database.
We use a naming convention to logically group related tables, so it would make a lot of sense to me to be able to perform a comparison by area. So I'd like to be able to specify a free-form filter mask to eliminate "fat" from the comparison:
/* example 1: only tables in functional area xyz */
object_name LIKE 't_xyz%'
/* example 2: only tables with the column "customer" in them */
object_name IN (SELECT object_name(id) FROM syscolumns WHERE name = 'customer')
etc.
can this already be done now, or can it be added as a feature request?
Cheers,
Johan
Johan
This discussion has been closed.
Comments
You can use regular expressions in the command line version of SQL Compare in-order to only select specific tables. (The command line version of SQL Compare can generate exactly the same reports as the GUI version. There is quite alot of information in the online help about the command line tools, which may be worth checking out.)
I will put forward your other requests.
Regards
David