![]() This feature is useful for troubleshooting problems with slow queries, the plan may reveal that the optimizer decided to do use a plan that was unexpected. When you execute your queries in the query window and the execution plan is available, you can view the plan under the 'Plan' tab. Auto-completion is context sensitive and will bring up the available objects depending on where the user has typed the last character.Įxplain plan is a feature that allows you to view the execution plan of a query in a tree format. In the example below, after a space is typed in after the WHERE-statement, a popup containing all available columns from EMP and DEPT tables is brought up. Query Window also supports auto-completion that is invoked as you type in your queries. ![]() By selecting a set of cells and copying them to system clipboard (Ctrl-C) you can easily send data to a spreadsheet application such as Excel or OpenOffice. You can also print, export and copy the entire result set or any part of it. You can dynamically filter the results by entering the value you're looking for in the '' entry field. in case of a numeric value you can see it in decimal, hex and binary format. By clicking on a cell of the result set grid, you can view the details on the selected value. The query window supports multiple result sets, syntax coloring, query history and many other useful features. Query window allows you to enter your own SQL queries, or load them from a file. By selecting a set of cells and copying them to system clipboard (Ctrl-C) you can easily send data to a spreadsheet application such as Excel or OpenOffice.įor tables, you can also view data in related tables, see the 'Related Row Viewer' section below When viewing data contained in a table or view, you can dynamically filter the results by entering the value you're looking for in the '' entry field. For each object, there is an abundance of information such as data rows contained in a table, roles assigned to a user, source code of a stored procedure and so on. Depending on the RDBMS vendor and version, you will see different sets of information such as databases, schemas, tables, views, triggers, sessions, tablespaces, users, roles and data files. The browser window allows you to drill down to your database structures without knowing any SQL. To see screen shots of the advanced database management features., go to the DBA features page. You can click on the image to get a full-size picture. We apologise for any formatting issues caused by the migration.Below is a sampling of available features in DB Solo. This post has been migrated from a previous version of the PostgreSQL ![]() For more information about DB Solo SQL Query Tool, visit. Was founded in 2004 and is based in Nashua, NH. ĭB Solo, LCC is a provider of database development and administration tools for PostgeSQL, SQL Server, Sybase, Oracle, DB2, MySQL, Solid BoostEngine and H2 databases. "These latest features take DB Solo to a level that has never been seen in this price range before", says Marko Hantula, CEO of DB Solo LLC.ĭB Solo 4.0 is available for immediate download at. The generated DDL scripts can then be archived or applied in a differentĪdditionally, this version contains several other enhancements - including support for Windows 7 - and dozens of bug fixes. The Server Scripting Tool allows one to create a DDL script for database server-level objects, such as users, roles and profiles. It will report any discrepancies between the servers such as missing or mismatching users, roles, tablespaces and databases. The Server Comparison Tool allows one to compare server-level objects between two separate database servers. New features in version 4.0 include a Server Comparison Tool and Server Scripting Tool. DB Solo supports all major DBMS products available today, including PostgreSQL and many others. DB Solo provides developers and administrators with a wealth of advanced features such as visual explain plan, database data & schemaĬomparison tools, import/export tools and a schema scripting tool.ĭB Solo SQL Query Tool is available for Windows, Mac OS X, Linux and Solaris platforms. Sophisticated cross-platform Database Query Tool. Nashua, New Hampshire, JanuDB Solo LLC is pleased to announce the general availability of version 4.0 of the DB Solo SQL Query Tool, the latest upgrade to DB Solo's
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |