menu
Daily Bits Email

The email you entered is already receiving Daily Bits Emails!

DbSchema: Database Diagram DesignerDiscount

DbSchema: Database Diagram Designer

Collaborative Database Design and Management For all SQL and NoSQL databases

25% Off
$147 $196.00
Mac & PC  Download Trial
Platforms: Windows, Linux, Mac
DbSchema: Database Diagram Designer ScreenshotDatabase Software ScreenshotDbSchema: Database Diagram Designer, Database Software ScreenshotDbSchema: Database Diagram Designer, Development Software ScreenshotDatabase Software, DbSchema: Database Diagram Designer ScreenshotDevelopment Software, DbSchema: Database Diagram Designer ScreenshotDevelopment Software, Database Software ScreenshotDbSchema: Database Diagram Designer, Development Software, Database Software ScreenshotDbSchema: Database Diagram Designer Screenshot 8DbSchema: Database Diagram Designer Screenshot 9

DbSchema isn't for everyone, but if you work with or want to learn to work with SQL or NoSQL, today's deal is especially for you!

If you are programmer, system architect or database administrator, DbSchema is one of the tools which may help you during your daily work. DbSchema may help you to design schema in team, deploy the schema on multiple databases, document the schema and generate HTML5 documentation, generate schema migration scripts, visually explore the data and write SQL queries, generate random data, and create HTML reports.

Team Design and Schema Deployment DbSchema reverse engineers the schema from the database in its own design model, that will be saved to the file. The design model is database-independent and can be deployed into any database. The design model file can be shared in a team using GIT. Comparing different versions of the same schema model you can generate SQL migration scripts.

Manage the Schema on Multiple Databases DbSchema can connect to different databases without affecting the schema model. This schema can be compared and deployed on any database, migration scripts can be generated.

Graphical Interaction with the Schema DbSchema use layouts (diagrams) to represent the database schema. To get a better representation of the schema you can create multiple layouts with the same or different tables. Tables, columns and foreign keys can be edited directly in the layout. Layouts will be saved to model file and can be later reopen. If the schema is missing foreign keys, you can create virtual foreign keys.

Visually Explore the Data Relational Data Browse is a module for simultaneous exploring data from multiple tables, based on foreign keys or virtual foreign keys. Exploring the data in one table will refresh the children tables with the matching records. The editor can insert new records or edit the exiting data.

Interactive HTML5 or PDF Documentation A good design required a good documentation. Using DbSchema you can document each table and column, and generate HTML5 or PDF documentation with the vector image of the schema, where the table and column comments can be read as mouse-over tooltips. Vector images have a small size and are interactive.

Random Data Generator The generator can fill tables with random data, which may be usefull in testing the SQL queries or the software application. The generator can use patterns or reverse regular expressions.

Query Editors For editing SQL queries you can use the Visual Query Builder or the SQL Editor. The graphical query builder features filters, JOINS, GROUP BY and ORDER BY. The SQL Editor features text autocompletion and explain plan.

Open the Design Model Without Connectivity to the Database Schema can be designed even without any database. The design will be saved to model file and later can be created on any database or converted between different databases.

DbShell A free universal SQL command-line client, featuring simultaneous connection and query execution on multiple databases, data transfer between databases, execution of complex database scripts with Java scripts, schedule database scripts with cronscript and more.

Prices are subject to vendor's pricing and may change
The Conversation
Features
The Fine Print
Testimonials
Expand All Email Updates Load 39 Older Comments
Steve Bigelow Downloading the trial version, IE 9 is reporting that "DBSchemaInstall.exe was reported as unsafe by SmartScreen Filter." Is there additional "crapware" installed with either the trial or licensed versions of DBSchema? If not, what does DBSchema contain that would trigger this warning from SmartScreen Filter?
Sep 4 2013 at 7:20am Copy Link
1
Dragos Pruteanu This message is shown on Windows8 for all .exe files, unless we have to buy a certificate from Microsoft. Anoter finding from Microsoft to make money with...
WiseCoders - Sep 5 2013 at 9:45am Copy Link
0
Steve Bigelow Thanks for your response, @Dragos. Respectfully, I disagree with your statement about this message being displayed for all .exe files - as a developer, I've both created and downloaded .exe files that don't cause this message to be displayed in either IE 9 & 10. (Corporate policy to use IE, much to my disappointment.)

Also, please note the SmartScreen Filter message appeared on a Windows 7 SP1 system, not Windows 8.

DBSchema sounds interesting, but because of this message, I think I'll pass, at least for now.
Sep 5 2013 at 7:07pm Copy Link
1
Mike Murphy Does this apply to the Mac version as well?
Oct 1 2013 at 6:52am Copy Link
0
Mark Johnson Actually the SmartScreen Filter is in the Internet Explorer browser, not in Windows 7 or 8 itself.

If it reports a file as 'Unsafe', all that really means is that not enough people have downloaded the file for the engine to evaluate it as being 'Safe'. It is also possible that people have used the mechanism to report the file as unsafe.

There are no certificates or other purchases that companies can make from Microsoft to make their files start appearing as 'Safe' through the SmartScreen Filter. It is really just a matter of having enough people download the file and not report it as unsafe.
Oct 2 2013 at 11:29am Copy Link
2
Dragos Pruteanu I think the SmartScreen Filter applies only for IE.
Thank you for explaining the mechanism. This is new for me.
Unfortunatelly is nothing I can do on DbSchema side to get rid of any message.
It would be fair from Microsoft if they would have scanned the files by themselfs before reporting them as infected. They could have shown on a website which the problem is, so I can also fix on my side.
WiseCoders - Oct 4 2013 at 10:38pm Copy Link
0
Dragos Pruteanu I did a check in IE with SmartScreen on www.dbschema.com and no problem was reported. Interesting, maybe the problem was solved.
WiseCoders - Oct 4 2013 at 10:58pm Copy Link
0
Coweko Alinac Why is this better that for example MySQL Workbench ?
Nov 21 2013 at 8:48am Copy Link
2
Steve Amos I don't suppose this tool generates the stored procedures and triggers necessary to support cascading deletes and referential integrity and all that sort of stuff? Like PowerDesigner?
Nov 29 2014 at 1:01am Copy Link
0
Dragos User Referential integrity is implemented transparent in the database, by the database itself. The tool only creates foreign key using 'Alter table .... add contraint..' statements. This is transparent for you, in DbSchema just drag and drop one column over the Pk and the foreign key is created. Triggers and procedures can be created and edited in the embedded SQL editor.
Dec 1 2014 at 9:32am Copy Link
0
Luis C If I buy this promotion will I be able to get the latest version?
Apr 30 2015 at 8:59pm Copy Link
0
Nadir User problem with kaspersky 2015
Sep 18 2015 at 12:27pm Copy Link
0
David User I'm guessing this is a Java-based app, since it uses JDBC. There are two different downloads for Win and Mac, but does the same app run on both of them? Can we use it on both?
Apr 30 2016 at 11:18am Copy Link
0
Dragos Pruteanu Yes, this is a Java application. It requires Java 1.8. Most of the installation kits include an embedded Java. DbSchema can run on Windows, Mac and Linux. Supported are SQL and NoSQL databases ( MySql, MariaDb, PostgreSQL, Oracle, Db2, MongoDb, Cassandra, Sqlite and more ).
WiseCoders - Apr 30 2016 at 10:40pm Copy Link
0
Shazza Given it is Java based, does that mean it will install the Java Runtime Libraries?
Mar 13 2018 at 1:00am Copy Link
1
Caveman Hi! I've seen I could apply for an Academic license in you web site, how do upgrades work and how much they cost in this case? Thank you.
Mar 14 2018 at 5:35am Copy Link
0
Retired Engineer To clarify ...

Do I do the design *graphically*, or is the graphics just a way of understanding by-text designs?
Mar 14 2018 at 9:58am Copy Link
0
Dragos Pruteanu Yes, you design graphically. Just double-click a table, column for foreign key to edit. Changes will be applied in the database and DbSchema Project ( if you are online ) or only to the DbSchema project if you are offline.
WiseCoders - Mar 14 2018 at 11:17pm Copy Link
0
Dragos Pruteanu About academic licenses, they are for Schools and non-Profit institutions. The license will work forever, the renewal is to get the new developed versions. The renewal for academic is about 25$/year. And we will continue to add new Features: now we migrate the Code to latest technologies ( JavaFx ), then will add data Analysis Tools ( Business Intelligence ) and Support for Elastic Search database.
WiseCoders - Mar 14 2018 at 11:19pm Copy Link
0
Dragos Pruteanu Yes, DbSchema is a Java-based application. It checks if Java 8 is installed on your computer, if not it downloads a minimal package. Using Java has as advantages:
- connectivity through JDBC Drivers to all databases.
- Switch to latest Technologies in UI - JavaFx - will come soon
- run on all platforms
WiseCoders - Mar 14 2018 at 11:34pm Copy Link
0
Shazza @Roberto. Thanks for clarifying. I don’t consider the security deficiencies in the JRE to be an advantage so I’ll have to pass.
Mar 15 2018 at 12:16am Copy Link
1
Dragos Pruteanu JDBC drivers are slowly migrating as well to higher Java versions. So we have to keep track of them...
WiseCoders - Apr 15 2021 at 7:13am Copy Link
0
Philippe User Would it be possible to create a lifetime license which includes major versions ?
Many application on BitsDuJour have a lifetime licence.

I don't mind to pay extra.
May 15 2022 at 6:36am Copy Link
0
Dragos Pruteanu Right now we don't have this feature. We have in plan to extend our licensing code, this would be a feature we could include.
WiseCoders - May 15 2022 at 9:29pm Copy Link
0
Philippe User Any update on the lifetime license ?
Dec 3 2022 at 6:18am Copy Link
0
Dragos Pruteanu The license is for lifetime, and includes 1-year upgrade to newly released versions. To continue to get the latest releases you will need a renewal licenses. The license you purchased will continue to work with the version you purchased + 1year.
WiseCoders - Dec 3 2022 at 10:38am Copy Link
0

Database Deals

Brilliant Database Pro (PC) Discount
for PC
Brilliant Database Pro
Create Database Apps Without Programming Skills
askSam 7 Professional (PC) Discount
for PC
askSam 7 Professional
A FreeForm Database for Everyone
SQL Pretty Printer (PC) Discount
for PC
SQL Pretty Printer
Beautify Your SQL Code!
My Visual Database (PC) Discount
for PC
My Visual Database
Discover How to Build Databases Without Programming
SQL Sets (PC) Discount
for PC
SQL Sets
Easily Capture and Share SQL Server Data
Like BitsDuJour on Facebook
BitsDuJour is for People who Love Software
Every day we review great Mac & PC apps, and get you discounts up to 100%
Follow Us
© Copyright 2024 BitsDuJour LLC. Code & Design. All Rights Reserved. Privacy Policy