Re: object list and schema filtering

On 3/21/07, eric millham <emillham@xxxxxxxxx> wrote:
> Hi, I see the alias properties function to copy down all the schema's and
> then refine which schema's I want tables loaded for. This is nice. But, I
> have a little twist on that, I need to create a static list of schema's to
> load tables for and have as a default to not load tables for other schema's.
> This is because we have literally hundreds of transitory schema's that show
> up with random names and then disappear. Squirrel takes forever to start up
> on this database. I do need the metadata for the static schema's and tables
> though. Ideas?

I don't think I quite understand what you mean.  If you have a list of
tables (that doesn't change) then create an alias and configure only
those schemas to be loaded.  The list of included schemas is all that
matters and is all that will be loaded - regardless of other schemas
that are created and dropped.  Your problem seems to be a perfect fit
for the use of Alias properties.  I must be missing something.

Rob

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV