DbSchema v8.1.9

Posted in: Softwares / Windows | By: Dl4ever | 31-08-2019, 16:50 | 0 Comments

DbSchema v8.1.9

Languages:English | File Size: 142 MB

The backbone of nearly every website or business that needs to keep track of large quantities of data and quickly respond to a request, there lies a solid database. There is an abundance of specialized software components that let you add data and create links, with DbSchema trying to make it a little easier.

Highly-intuitive and appealing design
In terms of visuals, the application sports a clean look, with an intuitive overall design and well-structured tabs that let you quickly access project items, as well as an interesting perspective panel which lets you navigate through the workspace as you would on a mini map.

Support for various database types
At a first launch, you can choose whether to start a new project from scratch, import already existing files or even connect to your local database via your network. Somewhere along the way you notice the breathtaking amount and diversity of database types it supports, with entries like MySQL, Access, Firebird, Oracle, Teradata and a lot more.

Easy to use creation tools
With the help of context menu entries, effort required on your behalf mostly concentrates at gathering data to import, because all creation options are as easy as can get. With a few mouse clicks and several dedicated windows, you are able to create tables, views, callouts, groups of tables or even bring up several editors for SQL, relational data, query builder, or random data generator.

Creation windows that are brought up might feel a little overwhelming, but are equipped with incredibly helpful tooltips that make even the least experienced users try their luck and succeed. Tab support let you easily access editing options for columns, keys, and signatures.

Multiple export options
The visually appealing display of elements on your workspace lets you easily identify elements, group tables and link them together more efficiently. Once all data is inserted, you might want to save and export your work in order to upload it to your server. This is done if connected to a provided address, with export options enabling you to get ahold of databases compatible with most popular formats, as well as basic image files for the schema.

A few last words
On an ending note, DbSchema manages to live up to expectations and is a powerful alternative in case you consider trying something new, or even starting from scratch. Since it's based on Java it can run on a wide variety of configurations and machines. Practicability is one of the main advantages, the application providing support and compatibility for various database types, with the intuitive design getting you quickly up and running.

-Import database schemas:
-Load JDBC driver
-Connect to any JDBC compatible database. Several DBMS have already been tested, but more will be added later.
-Currently tested DBMS include: Oracle, MySQL, PostgreSQL, DB2 for Windows/Linux, Cache, DaffodilDB, FrontBase, HSQLDB, Informix, JavaDB/Derby, Microsoft SQL Server, Mimer, Pervasive, PointBase, Sybase SQL Anywhere, Sybase ASE.
-Schema import includes: tables, views, foreign keys, procedures, triggers, sequences and comments.
-Edit database schema:
-Uses an abstraction level between internal database schema representation and any particular database.
-Edit tables, columns, indexes, foreign keys, procedures, triggers, sequences and comments.
-Edit your schemas Graphically using Layouts, including: tables, views, foreign keys, etc...
-Create and use multiple Layouts inside a project.
-Drag, pan and zoom Layouts using simple mouse movements.
-Supports Drag&Drop from project tree to graphical Layout.
-Highlight Foreign Keys for a given table, which trigger on delete events.
-Generate SQL statements directly from schema graphical Layout.
-Generate schema scripts to any particular database.
-Change schema data types from one database to another.
-Edit schema offline support.
-Browse database dаta:
-Browse data from multiple tables simultaneously.
-Set filters over browse data.
-Order browse data on one or more columns.
-Unlimited browse depth.
-Paginates browse data.
-Single or multiple record views.
-Insert, update, and delete records.
-View Large Objects (LOBs) fields as image, html, text or using an external application.
-Saves browse sessions in project file, which can later be browsed again.
-Edit and execute SQL:
-Edit SQL statements.
-Syntax highlight covering database keywords, functions, table and view names.
-Auto completion of table, view and column names.
-Quick Click&Show tables or columns in SQL pane and show them in Layout.
-Execute SQL statements individually or as scripts.
-Paginate and order SQL results, after query execution.
-Keep multiple SQL result panes, and refresh query results.
-Explain SQL execution plan.
-Saves SQL scripts working sessions in project file, which can later be continued.
-Schema Synchronization:
-Synchronize project schema with another project or database.
-List schema differences.
-Select which differences to keep, either on local or remote schema.
-Generate Merge SQL scripts based on schema differences.
-Upload differences on to database, with automatic step by step execution.
-Synchronize schemas offline, which enpowers team work.
-Scripts and documentation:
-Generates SQL schema creation scripts for any database.
-Document tables, columns, foreign keys, indexes, etc... by adding Comments
-Generates schema specification as an HTML document.
-Print schema Layouts with precise control on actual print size, using Zoom print feature.
-Generates schema Layout image files, in a few formats (PNG [raster] or SVG [vectorial])
-Provides a Database Template System, which allows to create, edit and maintain database templates
-Several Database Templates are already supplied, but new ones can be learned as well, by connecting to target database.

System Requirements:
Java 1.8+Whats New:Dbschema Version 8.1.9 Release Notes:
-Feature support functional indexes: create index idx on person(lower(lastname)). In index dialog there is an option for adding functional columns.
-Feature move pdf generation to openPdf and include unicode font for cyrillic and chinese text
-Feature configurable callout font in DbSchema/config/appearance/custom.css
-Feature improve Data Loader and upgrade to apache.commons.csv:1.7
-Bug Reverse engineer procedures in SqlServer
-Bug Create sequences in SqlServer
-Bug Installer view changelog prevents downloading correctly the new version

Report Dead Link(s)
0 Votes
Only Registed user can add comment, view hidden links and more, please register now
все шаблоны для dle на сайте шаблоны dle 11.2 скачать