Re: [Squirrel-sql-users] Limiting the Schemas loaded
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Chuck H. <che...@sp...> - 2013-01-21 14:02:07
|
Here is what I was hoping would happen: >> if you have a bunch of schemas, you might want first to toggle them all to "don't load" and then set your preferred schema(s) to Load and Cache or Load but don't Cache. There is a "set all" button for this. Each cell in each row of the columns in the Properties for Alias: table in the popup window can be individually set (click into to each cell to see this). Click on "OK". >> It is painful to load everything each time one starts up. > Right-click on the alias and choose "Alias properties". Next, click the > button labelled "Connect database to refresh schema table". Click on the > "fields" in the table to specify whether to load and/or cache tables, views > and procedures for each schema row. > > Rob > > On Sun, Jan 20, 2013 at 9:25 AM, Chuck Herrick <che...@sp...> wrote: > >> I already know which schema I need. >> >> What do I do next? >> >> >> >>> So maybe you will want to talk to your dba about which schema(s) you will >>> need to work with ? Generally, its decided at the start which database >>> schemas will contain the data that an application needs. That will >>> determine which schema you will work with. >>> >>> Rob >>> >>> On Fri, Jan 18, 2013 at 2:37 PM, Chuck Herrick <che...@sp...> >>> wrote: >>> >>> >>>> Squirrel has the feature that allows you to load only certain selected >>>> schemas. It pops up the config window when you first start up against >>>> a db. >>>> >>>> I can get the list of available schemas into the the pop-up window but >>>> for the life of me I can't figure out how to choose which schemas I >>>> want loaded. >>>> >>>> Can someone educate me about this? >>>> >>>> thanks, >>>> -- >>>> Chuck Herrick >>>> mailto:che...@sp... >>>> (512) 289-0926 (cell) >>>> >>>> >>>> >>>> >>>> ------------------------------**------------------------------** >>>> ------------------ >>>> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, >>>> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current >>>> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft >>>> MVPs and experts. SALE $99.99 this month only -- learn more at: >>>> http://p.sf.net/sfu/learnmore_**122912<http://p.sf.net/sfu/learnmore_122912> >>>> ______________________________**_________________ >>>> Squirrel-sql-users mailing list >>>> Squirrel-sql-users@lists.**sourceforge.net<Squ...@li...> >>>> https://lists.sourceforge.net/**lists/listinfo/squirrel-sql-**users<https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users> >>>> >>>> >>> >> >> >> -- >> Chuck Herrick >> mailto:che...@sp... >> (512) 289-0926 (cell) >> >> >> > -- Chuck Herrick mailto:che...@sp... (512) 289-0926 (cell) |