Download

From SQLBWiki

(Redirected from Download Page)
Jump to: navigation, search

[edit] Current Version

  • sqlbrowser_Feb10_515_Release.zip
    Besides usual bug fixes, this release presents the following new features
    • Find Panel
      This panel is a new Object Finder panel which let you search for an object name by typing a regexp. It is a much fater way of locating objects across databases. From anywhere, Ctrl-Shift-O activates the Find Panel. Arrows Up/Dn and Enter key works smartly without requiring mouse move.
      Source Action
      In addition to Analyze and Extract, the Source Action goes to the source file on an existing object. To be able to locate the source file for a given object, one should parametrize the path name to the object. This is done through the 'Source' tab of the preferences. This panel allows you to define rules to locate object sources using regexp based on the server, database, owner, or name of the object. This is a major productivity feature. The default action is set using the radio button on top of the chooser panel.
      Ctrl-Click
      When Ctrl-Clicking on an object in an SQL file, SQLBrowser opens this object definition in either Source, Extrat or analyze mode, dependending on how the original file was opened
      Inline Analyzing
      The Analysis is now performed on the fly. This allows to detect defect and benefit from the Analysis pane at any moment. This is a big productivity feature as it allows quick detection of defects and typos. As a consequence, the 'Show Diagram' is now accessible through right click on a query.
      Defects Detection
      Defects can be turned on or off generally, or only for the inline analysis. The severity can be changed as well.
      Deprecated Defect
      One can mark an object as deprecated. This is based on the same principle as for source files: regexp qualifies object to be marked as deprecated. These objects will be tagged with a "Deprecated" defect and can inform developers to not use this object in the future.
      Comments Ratio
      Percentage of Comments is shown as a "Metric" defect
      Server Colors
      Servers can be associated with a background color. This color will be used by editors. This allows to remind the user when they are connected to a PROD or UAT environment for instance.
      Opened Connections
      Added a window "Opened Connections" to see all connections opened by SQLBrowser
      Object Chooser/Finder
      Added permissions and stat mod date to the extra info
      New Defects Added
      • V15B "V15 Issue: RHS contains col involved in join on extra tables through complex expression"
      • MDYN "Proc uses Dynamic SQL but is not flagged with 'Dynamic Ownership Chain'"
      • MUUF "Useless Update/Delete with From "
      • CUUP "Cursor updated: cursor should contain 'for update' clause: "
      • CUSU "Cursor updated through 'searched update': risk of halloween: "
      • CSBI "Cursor with 'Distinct/Union/GroupBy/OrderBy/Aggregate/SubQueries/Isolation': cursor should contain 'insensitive' clause.(V15 issue)"
      • QRPR "Repeated predicate"
      • MDPR "Deprecated item"
      • QCRS "Conditional Result Set"
      • QAPT "Access to Proxy Table"


[edit] Previous Versions

  • sqlbrowser_July09_384_Release.zip
    This version delivers better performance, less memory usage, a new version of the 'write analysis' (batch analysis step) and some new features such as the ability to launch multiple sql runs at the same time
    • when autoconnect is off, pressing cancel on connection opening on debugger pad leaves debugger window always opened
    • go should be generated every 1000 lines in generate insert/update/delete
    • can run multiple SQL at the same time
    • batch analysis for case insens servers should generate cases sens hyperlinks on case sens File Systems (e.g. Tomcat or a non windows FileSystem)
    • warning: in com.sqlbrowser.sqlbm, not using spec.version.base, yet declaring implementation dependencies; may lead to problems with Auto Update (see http://wiki.netbeans.org/wiki/view/DevFaqImplementationDependency)
    • use new JConnect which fixes data type name exception
    • debugger: fail debugging smalldatetime datatypes
    • indentation: push select list, better handling of ON/JOIN
    • on Table result set, create a generate var assignment (declare + select into vars)
    • make sure that the save dir is the last dir from which a file was opened
    • metrics: sigma qi(0,N-1) = (1 -qn)/(1-q)
    • when unticking remember password, previous saved pwd should be erased
    • write analysis consumes too much memory when # of objects is > 10000
    • put tooltips on table cells to display enire content
    • procs which calls to non fully qualified procs generate MZMB (zombies)
    • provide sb32.ico in distribution to allow for use on the sqlbrowser cmd or shortcuts
    • self locking could happen in certain circumstances at startup if autoconnect is on
    • zip schema.xml should be encoded in utf8
    • dont show temp files in open recent files
    • when killing a connection and closing the window, the popup should not show
    • add query and internal query timeout options
    • SQL running for ever in certain cases (progress bar does not stop)
    • add ability do download plugins e.g. Subversion 1.5
    • MGTP defect on tables are repeated
    • max row count displayed does not match real row count
    • some completion issues (eg select dt|)
    • table should not remember selection mode
    • add a new defect to detect group by without order by (V15)
    • add SQL functions completion help
    • fix "out of memory" when reading many rows
    • use new jconnect
    • getColumnTypeName is buggy (mem) + error when coming from dirct connect mimic sp_sql_type_name
    • Exception: AST_keyword can not be cast to AST_expression_list
    • bad FK loading in some circumstances (wrong dbid...)
    • rowcount is not formatted with thousands sep in tabs in result set viewer
    • Add 'Select All And Copy With Headers' on tables
    • when not connected, dont load dependencies/schema
    • don't put generated & select temp files in the history
    • in Tables, Copy float should be full precision, not 3 decimals only
    • don't generate an alias which is 'go'
    • show procxmode info in object explorer
    • remember lat statements sent and provide access in completion, use 'cmd' magic keyword + ctrl space
    • index of tables not owned by dbo are not displayed
    • generate insert has inconsistent dates compared to output (e.g. when midnight)
    • grant decrypt on table to role provokes syntax error
    • reformat does not handle 'go' very well
    • paste from table copy into text required focus loose/gain to function (alt Tab, alt Tab)
    • copy table to excel: java.lang.IllegalArgumentException: Cannot format given Object as a Number
    • right click does on database list does not work on MacOS
    • completion should be case insens on case insens servers
    • edit server property does not change server property
    • db size reported as negative on batch analysis when sizw is gerater than 2G
    • show loginame in sysobjects
    • save as on same file trashes original file
    • need to scroll to line when showing batch
    • copy of result set tables should use regional settings for decimal sep but no grouping
    • better handling of stmt line display
  • sqlbrowser_Jun08_231_Official.zip - 28 Jul 2008
    • 'Save As' on the same SQL file would trash the file and loose content
    • keep a 'Remember Password' flag per server to allow DBAs to log in temporarily on a user machine with privilege account
    • database size gets negative when over 2 gigs
    • read & writes IOs should be formatted with thousands sep (but maybe not K, M etc, or create an option)
    • change registry options to file system based option. IMPORTANT: .reg overwriting should be done through arguments.xml. See function to dump keys in export
    • write dep & schema as zip files to speed up reload
    • IO times are sometimes not well reported
    • dont trim left side of raw messages
    • create a 'View Log' menu - log to 1 file only
    • failure on joins assertion when same column on both sides of join
    • dynamic sql is not expanding variable to value correctly
    • leave ability to edit servers but warn when save if non synthetic. this will allow to copy the host/port
    • in case insens servers, generate insert etc does not find columns with different case
    • add Proc and Line in perf messages
    • debugger has goto label see mail
    • new temp file has no F10, flip tabs and it works
    • No recognition of file ending with capital .SQL
    • removed @@maxpagesize 12.5 dependency
    • add defect 'grant to public'
    • when input file is too big, dont restore at startup
    • add 'skip identity columns' checkbox to generate insert
    • apply the same dictionary order sort on databases than the one used for objects
    • surround cells copied from tables with quotes (Excel compatible, flag)
    • downgrade QSWV to warning
    • add where clause to generate insert
    • put temporary dir in output dir
    • permission query is wrong, depends on the database
    • lines over a million dont show well 1.6M
    • put a trace for load of roles
    • string index out of range sometimes appears in capture for RPCs
    • no detection of CP on "select * from sysobjects s , sysobjects s1"
    • re-introduce lowercaseKeyword and uppedrcaseKeyword options
    • table size is underestimated in object chooser
    • failing to load properly database objects in certain circumstances
    • first update count in debug should be disgarded
    • if one result, zoom it
    • empty print statement are disgarded
    • created warning on 'partial join on PK'
    • progress bar sometimes stays up
    • better tree node filter behaviour on selection in parsed text or nodes
    • MUCO defect should only be detected for return, ok for ifs
    • no need to load indices on views
    • reorder menu on text pane
    • same letter tab may appear more than once in object chooser due to owner discrepancies
    • having max ( tmp.dt_open )= min ( tmp.dt_open ) generates bad QPSC defect
    • hit cancel on connect from drop down, still connects
    • reduce size of syntax error "was expecting ... is too long"
    • add option to open objects in multiple windows
    • add option to not show acknowledged defects
    • NPE in login panel when not connected
    • Add flag to load dep and FK on connection
    • NPE in BA when turning off RREG defects and Write Analysis is ON
    • do 'generate Update/Delete' command
    • load FK and schema should properly timeout
    • BA: creation date always appears as '01 Jan 70'
    • print in status of exec stmt should skip declare @x...
    • do an Integer formatter
    • does not parse access rule creation
    • database search: hangs on errors, does not parse tables, does not search comments
    • create dump monitoring button
    • cartesian product with where 1=2: create 'whereClause.isAlwaysFalse()'
    • Add lockscheme Lock Scheme: 8192 -> all pages, 16384 -> data pages, 32768 -> datarows
    • formatting floats/double does not use the number formatter
    • debugger: strings containing embedded quotes are not correctly interpreted. NB strings are no longer quoted in variable editor
    • debugger: while/if imbrication sequencing issue
    • bad colors in monitor
    • token start issues in search


  • 6.71 - 18 Nov 2007
    • Run SQL: Setting rc to infinite would go back to 100
    • Open Object: Opening an object would fail with "Not Found" when object was modified
    • Arguments: When xml file for arguments is not correct, preferences were lost
    • Run SQL: Display of messages are consuming too much resources
    • Run SQL: When columns are shuffled, wrong column header was used in selections


  • 6.70 - 1 Nov 2007
    • Should be able to parse non dbo-owned objects. Remove 'Object Owner UID' flag
    • Batch Analysis: columns order in tables was wrong
    • In result tables, do smart row/col/free selection by double click/triple click/drag mouse
    • Added 'Unclosed Set Forceplan ON' defect
    • Fixed Wrong 'Useless Code' on 'if not exists(...)'


  • 6.66 - 21 Oct 2007
    • Added Login And Roles Display Panels
    • Fixed some Monitoring Issues


  • 6.59 - 10 Oct 2007
    • Added flag to turn on/off monitoring history because of memory consumption
    • Result Set Tables Selection Mode is entire row
    • Fixed issue happening sometimes in batch analysis (mix of database objects)


  • 6.56 - 8 Oct 2007
    • Fixed Object Chooser wrong object selected when sorted
    • Fixed auto-parsing issue (wrong error mark) happening in certain cases with block comments


  • 6.54 - 4 Oct 2007
    • Added new tracked defect: "MUTI", "Update temptable with identity - 12.5.4 Regression" , SEVERITY_WARNING
    • Added new tracked defect: "MUIN", "Column created using implicit nullability" , SEVERITY_WARNING
    • Dependency window would sometimes come back in the center as an Editor Window


  • 6.51 - 1 Oct 2007
    • Fixed NullPointerException in database search
    • Fixed HTML report (write analysis) when column name contained a dot
    • Fixed HTML report when string literals contained HTML markup
    • Added some basic metrics like line count etc. Not yet in HTML report
    • Added new defect to detect assignment to var with multiple rows
    • Added new defect to detect useless code
    • Added new defect to detect no error check after upd/ins/delete/exec
    • Added screen to enable/disable defects detection
    • Enhanced Monitor (added locks and history)


  • 6.48 - 20 Sep 2007
    • Downgraded defect QPSC (Same column in condition) from Error to Warning
    • Bad "unused var" reported in "update .. set @v = @v + ..."
    • Put file pointers to preferences_overwrite.xml into argument file. Next version will supress these files in favor of the argument file only.
    • Removed call to rsmd.getColumnTypeName as it consumes a huge amount of memory when showplan is turned on (jconnect bug)
    • Skip "syslogin" system table from size inspection (too long)
    • Enabled usage of "[" for correlatin names (msoft compatibilty)
    • Forcing an index which does not exists is now an error
    • Added a button "don't show again" on error popup during SQL Run
    • Fixed NPE in send/debug on servers with localized languages
    • Dependencies now shows together with object chooser
    • sp_showplan proc name is parmetrizeable in Options for execution rights issues
    • Dependencies now show temp tables
    • Schema and Dependencies files now get loaded from input file or URL
    • When opening New window, current Server should be assigned (and not last opened)
    • Can now mark many lines in monitor


  • 6.41 - 07 August 2007
    • Add "Logged In Since" in monitor (vs delta only)
    • Ability to parametrize the user id used to select object lists


  • 6.40 - 02 August 2007
    • Speed up connection opening over the wan
    • Re-introduced customized syntax tree for lookups
    • java.lang.NullPointerException in completion when from is last KW
    • When extracting, server should be server of extracted proc
    • Do not allow disconnect/reconnect in debugger pad: connection is shared
    • Put an option to not expand views in schema


  • 6.38 - 29 July 2007
    • Memory leak could happen after interrupting SQL run
    • Must add newline after proc extract which does not end with a new line
    • Possible java.util.ConcurrentModificationException when 'edit connection param'
    • After 'Save As' server should be reopened if it was opened before
    • Remember the last last database selected when opening the connection
    • Interrupt SQL would some time not work
    • Upgraded JConnect to EBF 14466
    • Other misc fixes


  • 6.36 - 22 July 2007
    • Should optimize time to display big tables
    • All In One: table size should not be wider than parent
    • Syntax should understand top N (select, union, update, delete)
    • F9 on 2 subsequent go without anything in between produces gogo
    • Completion on 'on' keyword is broken
    • Ansi join & on should indent properly
    • Insert with not all columns is OK when missing col is identiy
    • Completion: exec sp_xxx should always work, sybsystemprocs is implicit
    • Table extract should show FK & PK
    • Proc extract shows double 'use' stmt


  • 6.35 - 16 July 2007
    • Multiple Results are not shown in multi batch
    • Debugger: better handling of cancel


  • 6.34 - 15 July 2007
    • Join without index does not show on views
    • V15 columns in tables/views badly ordered
    • Objects should be sorted case insensitive
    • List of Database passed to batch analysis should be reported in index
    • IO Summary Read/Writes should be formatted as numbers
    • Number formatting should not only apply to float but to all numbers
    • Monitor: Dont show error when bad user, just print error, causes screen jitter
    • Monitor does not show anything when constant bad user error
    • Zip file should be renamed with version number
    • NullPointerException when no connection and parsing attempted
    • Debugger: History and Manual History not handled well
    • Reformat now insert newlines before main statements - primitive approach
    • Objects parsed should be restricted to uid = 1 (dbo owned)
    • Pragma search is too slow. Shows on big procs
    • Double Pragma Acknowledge does not work for same statement


  • 6.32 - 3 July 2007
    • the 'Open recent' list was poluted by additions to the favorites directory
    • 'Select *' submenu did not react well to interruptions
    • 'Search Database' did not allow for any other activity
    • Defects needed to be split between 'defects for this procs' and 'defects for sub procs'
    • Monitor still showing exceptions for bad user detection
    • Severity less than 10 should not popup even if 'Popup Errors' is set
    • Index Overlap should not be thrown when indices are of different unicity


  • 6.31 - 1 July 2007
    • Red Activity bulb on lower right sometimes stayed red
    • Column Stats
      • Better behavior (truncation of char columns, interuptable process,...)
      • Options to select statable columns
      • Generation is in in outputdir/server/columnstats/object_name.html
    • All-In-One: all result sets are shown in single pane
    • Batch Analysis now scans all tables from database as well
    • Batch Analysis output now goes in subdirectory (server name) of output dir
    • Foreign Keys are loaded asynchronously at server opening
    • schema.xml and dependencies.txt are loaded from new preference "Input Dir or URL". Can be specialized per server.
    • Unrecognized pragma are shown in error pane
    • Monitoring: better handling of invalid user in db or other errors
    • Select * from table scripts is no longer generated in permanent directories implying a save before run
    • Analysis files have yellow background, caret line is highlighted with FFFF7F
    • cast() keyword is recognized
    • Completion:
      • Aliases which are keyword (as, asc etc...) are no longer proposed in completion
      • Completion proposes joined tables first (in CYAN)
      • NPE on initial completion is fixed
    • Can now step into dynamic execs
    • Better MTYP (Type assignment mismatch) analysisput
    • Dependencies displayer missed database in save selection
    • Expression $-3 now parses correctly


  • 6.25 - 23 May 2007
    • Regression on Batch Analysis


  • 6.24 - 22 May 2007
    • Database Search: NullPointer & ArrayOutOfBond spurious exceptions
    • Database Search: Search could fail when user clicked and search is not finished
    • Database Search: Errors in offsets
    • Left Side Trees: Click on a table does not display table definition
    • Run SQL: add option to automatically save file before run
    • Run SQL: Exception when user has insufficient rights
    • Run SQL: MetaData shows numeric type with no scale
    • Monitor: add ability to freeze, change sleep time, sort columns & trace
    • Batch Analysis: clear Foreign Key cache before analyzing
    • Batch Analysis: Foreign keys have sometimes wrong ordering


  • 6.21 - 14 May 2007
    • Initial revision of Netbeans based SQLBrowser



[edit] SQLBROWSER SOFTWARE DOWNLOAD LICENSE AGREEMENT

NOTICE TO USERS: BY INSTALLING THIS SOFTWARE YOU EXPRESSLY ACCEPT ALL THE TERMS AND CONDITIONS OF THIS AGREEMENT. PLEASE READ THEM CAREFULLY. IF YOU DO NOT WISH TO BE BOUND BY THESE TERMS YOU MAY NOT DOWNLOAD THE SOFTWARE. UPON YOUR ACCEPTANCE OF THIS AGREEMENT, SQLBROWSER GRANTS YOU A LIMITED, NON-EXCLUSIVE LICENSE TO USE THE SOFTWARE AS FOLLOWS:

  1. VOCABULARY. In this agreement, the words "Software" and "Product" are meant according to the following definitions:
    1. Product : SQLBrowser product, fully functional version, sold by SQLBROWSER
    2. Software : Evaluation version, with limited features, of the Product
  2. USE OF THE SOFTWARE. You may install and use the Software (and accompanying documentation) solely for purposes of evaluation, in order to check that SQLBrowser could provide for your needs and to make the decision of buying (or not) the Product. You may not use the Sofware for production purposes.
  3. COPY AND TRANSFER. You may reproduce the Sofware solely for your internal purposes. You are not allowed to transfer a copy to a third party. The Software may not otherwise be transferred, sold, assigned, sublicensed or otherwise conveyed (whether by operation of law or otherwise) to any other parties.
  4. OTHER RESTRICTIONS. You may not modify or adapt the Software in whole or in part (including but not limited to translating or creating derivative works),decompile or disassemble the Software.
  5. COPYRIGHT AND OWNERSHIP. The Software is owned by SQLBROWSER and is protected by copyright, including without limitation by French Copyright Law (Code de la Propriété Intellectuelle) and international treaty provisions. You acquire only the non-exclusive right to use it as permitted herein and do not acquire any rights of ownership to it.
  6. SUPPORT. This download Software is provided on an "as is" basis and are unsupported. This Agreement does not entitle you to any maintenance or other services or any updates or new versions of the Software.
  7. TERMINATION. This Agreement and your license to use the Software will continue so long as you remain in compliance with the terms and conditions of this Agreement(especially article 2). After evaluation of the Software or if you breach any of your obligations hereunder, you shall cease using the Software immediately and shall destroy all copies of the Software (and associated Documentation) in any form. All disclaimers of warranties and limitations of liability shall survive any termination of this Agreement.
  8. LIMITED WARRANTY. The Software is provided AS IS, without any warranty whatsoever. You assume the full responsibility for the selection of the Software to achieve your intended results and for the installation, use and results obtain from the Software. SQLBROWSER DISCLAIMS ALL WARRANTIES AND CONDITIONS, EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION THE IMPLIED WARRANTIES OR CONDITIONS OF MERCHANTABLE QUALITY, NONINFRINGEMENT, AND FITNESS FOR A PARTICULAR PURPOSE.
  9. LIMITATION ON LIABILITY. SQLBROWSER SHALLNOT BE LIABLE FOR ANY LOSS OR DAMAGE HEREUNDER, INCLUDING, WITHOUT LIMITATION, ANY INACCURACY OF DATA, LOSS OF PROFITS OR INDIRECT, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES, EVEN IF SUCH PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
  10. GOVERNING LAW; COMPLETE AGREEMENT. This Agreement constitutes the complete agreement between the parties with respect to the Software and is governed by the laws of FRANCE.

BY DOWNLOADING THIS SOFTWARE, YOU ACKNOWLEDGE THAT YOU HAVE READ, UNDERSTOOD AND AGREE TO BE BOUND BY THE TERMS AND CONDITIONS OF THIS AGREEMENT AND THAT YOU ARE DULY AUTHORIZED TO DO SO.

Retrieved from "http://www.sqlbrowser.com/wiki/index.php/Download"
Personal tools