-
Latest Version
DbSchema 9.5.2 LATEST
-
Review by
-
Operating System
Mac OS X 10.11 or later
-
User Rating
Click to vote -
Author / Product
-
Filename
DbSchema_macos_9_5_2.dmg
Using Db Schema for macOS you can design the schema with or without database, save the design as project file, deploy schema on multiple databases and share the design in a team. Build-in tools allows to visually explore the database data, build and execute queries, generate random data, build forms applications or reports and more. It can be evaluated 15 days for free, no registration required. It can work on all operating systems.
Db Schema for Mac is build for large schemas and complex databases. Build meaningful relations between tables and document the schema. Discover DbSchema layouts, virtual foreign keys, Relational Data Browse, interactive PDF documentation and many other features.
Features and Highlights
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.
- It 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 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 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 the SQL execution plan.
- Saves SQL scripts working sessions in the project file, which can later be continued.
- Synchronize project schema with another project or database.
- List schema differences.
- Select which differences to keep, either on a 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 empowers teamwork.
- 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 the 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 the target database.
Also Available: Download DbSchema for Windows
What's new in this version:
UI Internationalization:
- DbSchema UI can show in english, spanish, german, italian, portugese, japanese, and chinese simplified
DbSchema Internationalization:
- This can be re-configured from Model / Settings Dialog
Floating License Server:
- Floating licenses can be used by teams, when a license can be shared across multiple users
- This is more for the cases when DbSchema is used by multiple users in a team, for short intervals to time each
- The floating licenses requires installing the floating license server on a separate machine. The client computers will connect to the floating license server.
- The floating license server can be started from DbSchemaCLI using the command ‘license server’
Manually Start DbSchema PRO Evaluation:
- In the earlier releases, DbSchema PRO trial was started automatically, after installation
- This has created confusion, as the design model was a feature the PRO edition, and as soon as the trial ended this feature couldn’t be used anymore
- Now, the PRO trial is started only at the user request, making users aware about this
Improve Relational Data Explorer:
- Exploring the data from one table will open the table in maximized view. The view can be restored using the maximize button in the upper right corner.
- Data Explorer Maximized View:
- Cascading a further table will automatically minimize the table
Data Explorer Cascade Table:
- Editing table data will show the editor directly into the table. Double-click cells to start editing. Press ENTER with Control pressed to enter new lines of text.
Data Explorer Inline Edit:
- Multiple table cells can be edited simultaneously
- Data Explorer Edit Multiple Cells Simultaneously
- Auto-completion for Java Groovy Scripts
- DbSchema can automate different tasks using Java Groovy automation scripts. Sample scripts are shown in the Tools menu / Automation Scripts.
- Scripts can be added in the Automation Scripts dialog under User Defined
User Defined Automation Scripts:
- You can also open the SQL editor, switch to Java Groovy and edit or execute scripts
Edit Groovy Scripts in the SQL Editor:
- Now, pressing CTRL-Space a completion menu will show
Java Groovy Auto-Completion:
- Placing the caret between the method brackets and pressing CTRL-P, the different parameter combination can be listed
Other improvements:
- Feature: Add method Schema.cloneTable()
- Feature: Logical design specify column auto_increment
- Feature: Upgrade Firebird JDBC drivers
- Bug: Editing foreign key columns was not possible for Pk tables with more than 100 records
- Bug: Editing column in table dialog, after sorting the columns, would break the sort
- Bug: Data explorer insert UUID in PostgresSQL
- Bug: Browse Filter pop-up not showing when the data view is scrolled to right
- Bug: Different bugs in GIT dialog
- OperaOpera 109.0 Build 5097.33
- PhotoshopAdobe Photoshop CC 2024 25.6
- PrivadoVPNPrivadoVPN 3.8.11
- ReiBootTenorshare ReiBoot iOS for Mac 9.4.4
- Adobe AcrobatAdobe Acrobat Pro 2024.001.20615
- OKXOKX - Buy Bitcoin or Ethereum
- ParallelsParallels Desktop 19.3.0
- TradingViewTradingView - Track All Markets
- CleanMyMacCleanMyMac X 4.15.1
- 4DDiG4DDiG Mac Data Recovery 3.4.2