|SQL Developer Tools|
| Book Review: Web Services and development require more cross database tool
Feature: Finding s good ones that help in movement of data between DBMS is hard
There is no doubt that the three biggest challenges to IT development are 1)the blur of OS/platforms, languages, services, and databases that make up "a system"; 2)figuring out the governance of a company's systems - who pays for development, operation, data streams in and data streams out; and 3)the ever increasing size and mmore demanding interoperability requirements between systems. In essence, IT problems are general cases of nearly the same problems confronting database developers. As hospital administrator pointed out - "many different databases, growing like weeds and 'you want them all hooked together when ??' "
One of the difficulties of working with multiple different databasesis the fact that each database has tools, query builders and control centers that stop distinctly at their own proprietary boundaries. Thus, though IBM's DB Control center is admirable it hardly knows anything about IBM's Informix, Derby or Notes datbases. Ditto for Microsoft's new Visual Studio-based SQL Server 2005 Express or Oracle's SQL Developer. So as we prepare to review the major databases we have been confronted with the problem of not only making cross platform joins work (nearly mission impossible); but simply shuttling data between the databases with some degree of efficiency. So we have been looking for some good SQL Developer tools. Here is what we have found so far.
However, that generality has its limits. Note in the screenshot, the syntax used for adding a filter condition - dbQwik Edit is very intolerant of departures from that exact syntax. In addition, each database has extended its SQL with dozens of uniquely named (but of course comon function) commands - dbQwikEdit rarely knows those database specific SQL commands and functions. For other database objects like constraints, triggers, stored procedures, views and other advanced entities, dbQwikEdit has only barebones facilities. Nonetheless for $100, dbQwikEdit provides good value for viewing and basic development of a wide range of databases - and its fall-off-the-log easy to use.
Quest Toad Data Modeler Freeware
Top of Page Home Tutorials