DbSchema isn't for everyone, but if you work with or want to learn to work with relational databases, today's deal is especially for you!
DbSchema is an efficient and productive database work environment that facilitates an intuitive perception of a relational database based on a graphical image of the database architecture.
Relational Data Browse, one of the primary tools in DbSchema is an amazingly simple and efficient relational data explorer that offers simultaneous views of data from multiple tables and features numerous filters, data sorting mechanisms, and much more.
DbSchema is flexible, and operating-system/database independent. It features a SQL editor, a database-synchronization tool, round-trip-engineering and team-work features, and extensive documentation creation tools, making it a fantastic utility for developers, administrators, and system architects alike.
DbSchema v5 now includes a comprehensive Visual Query Builder that provides a simple and efficient way to graphically edit complex queries. Write complex queries with INNER, OUTER, EXISTS joins, filters, and group by clauses.
Yes, I think DbSchema is a very good tool for databases. I like the 'Data Browse' - I clicked on table, I saw the data, than in few clicks I saw data from more than 5 tables at a time. In other editors it would be a nightmare to type queries for this. And the tool has also an embedded SQL editor and diagrams - everything I needed. There are not many tools which brings new ideas in this area, but this does it. My database is MySql.
I see that this covers MySQL, Derby, HSQLDB, all of which I need, but I also need to use it with Firebird, H2 and MS Access' Jet engine. Any news about when or if these can be expected? All can connect through JDBC, I believe. I submitted a query on the developers' site 24 hours ago, but have not had a reply.
Using DbSchema you can connect to any database. In the Driver manager dialog you can add new databases and new JDBC drivers, besides the one included into the application. Because for many users the JDBC drivers are new, I post here a link to an interesting article about the JDBC and ODBC drivers: http://java.sun.com/docs/books/jdbc/intro.html
Thanks Roberto - I have bought dbSchema now. Firebird actually uses Jaybird. I'll have to experiment with whether this can connect to dbSchema, but our product accesses Firebird from Java. Roy
Please check download link for Windows installer package. Page is not responding at this time.
Thank you for writing us. Now the problem is fixed.
Installer with Java and Zip package both download fine for me, but Win installer without Java still doesn't work (waits... and finally fails "cannot display the web page"). Will the installer with Java detect if Java is already installed or will it overwrite?
The installer with Java does not overwrite. It just install the JRE into a subdirectory of DbSchema. The installer is build with NSIS, a wide-used software. We will try to reproduce the problem on our systems and get it fixed.
This looks like a nice product. One feature I'd love to see is the ability to connect to a Salesforce.com database.
Thank you for the nice words. I think Salesforce uses Oracle in background, and DbSchema works with Oracle. Check this link http://community.salesforce.com/sforce/board/message?board.id=scontrols&message.id=2202
Can this be run from a USB drive?
Yes, but only if you will use the zipped kit ( no installer ).
Hi Folks, The tool looks interesting, especially if the decision of a database to use for an application is in flux. Maybe I am researching MySQL, Daffodil, Frontbase or Mimer, or some of the higher-end ones, and I do not want to do a design for an app and then have to redo the whole thing when I go somewhere else. Kewl. This is a natural app for a users forum, comparing notes on what works how well where .. what can be tweaked how .. but I don't see one. May I presume that the more proprietary and oddball database programs (eg. WinDev, Magic, Alpha, Filemaker) would have some difficulty using DbSchema input ? How about Clarion and InfoQube ? Do I simply ask them if they have a JBDC inport option and that is the basic issues, plus some sludge work if the connection is new ? Thanks. Shalom, Steven Avery
Roberto, how is the licensing concept? Can DbSchema 5 be used by the same user on more than one PCs (Dekstop/laptop) and is the same license valid for cross platform uses? (my desktop is Windows, but my laptop is Linux).
Hi Alexander, The license is per user, with no installation restrictions. You can use it from desktop ( Windows ) as well as from laptop ( Linux ). Hi Steven, Yes, this is the idea: you have your project into DbSchema, and than you can implement it on different databases, as you want. Using the synchronization you can see the differences, refresh or commit any of them, etc. Besides this, the schema is represented in multiple layouts, with sql and relational data browse for each layout. They are saved together with the project and can be reopened. The project is saved as XML file.
The import from the database use first the JDBC driver standard methods. If the driver implements correctly the interface, the tables, columns, foreign keys and indexes will be imported. For procedures, triggers and sequences there are used database specific queries.
Using CodeGear/Borland/Embarcadero's RAD Studio (still v6) and until now only local databases (dBase2, Paradox), perhaps now is the time to go one step further to InterBase, which I've seen on your website is also supported directly by this compiler. Having downloaded your trial-version, I have seen it there, but as it seems I have to download some JDBC-drivers first. Can you tell me, what I have to do to connect DbSchema to the Interbase databases? I think it makes sense to get this done and be able to try how the two tools work together before buying...
DbSchema can work with any relational database, like InterBase, MySql, Postgres, Oracle, etc. The drivers are code libraries ( supplied by the database vendors ), required to connect to the database. All drivers are implementing some specific features. When you decide to connect to a database you need the database software to be installed and the database driver for connecting to it. That's the great advantage of Java: it uses a standard, so onece you learned how to connect to a database, you can connect to any other database, the procedure is the same, no matter if the database runs on Windows or Linux ( like the big companies does ). A detailed documentation about how to find the database drivers and how to connect to the database is included in DbSchema, as well as on DbSchema website. The driver is usually delivered with the database software. It is better to use that one, just to make sure it has the same version as the database.
I did a reverse engineer on 2 schemas while signed in as a different user with a DBA role. When attempting to browse the data, the program is telling me the table does not exist but it does because I can see it in TOAD. 1) I cannot find an option to append the owner to the table name when reverse engineering a schema and without the owner name the program is assuming the table belongs to me. It seems I can reverse engineer a different schema but cannot browse the tables afterwards. 2) read moreHow do you show the owner name on the ER diagram. 3) A serious bug was found. This program automatically hijacks files with a .sql extension. There was no option on the install to allow the program to do this, just did it on its own. This is a big NO-NO and needs to be corrected. I want to use my own SQL editor.
You are right, the problems you have wrote should be fixed. The opening of SQL files should be configurable during install, as you wrote. We plan a new DbSchema version in about 30 days, and we will try to include fixes too.
Posting here will also email WiseCoders directly.
Every day we offer 24 hour discount deals, on a Windows software application, or a web service. We feature our deals at a substantial discount; the discount is available for that day only.
We don't process the sales; we just arrange the discounts and provide the links. You buy the program right from its vendor. Everything we feature is a legal, current version of the product.
Want more information? Then read all about it.