Open System Architect!

home http://codebydesign.com
http://codebydesign.com
creenshots http://codebydesign.com/ScreenShots
ownloads Downloads Microsoft Windows XP There are no special requirements for OSA on Windows XP. However; you will almost certianly want ODBC drivers installed for any particular databases you want to use. OpenSystemArchitect-4.0.0-XP-32bit.zip OpenSystemArchitect-4.0.0-XP-32bit.zip Linux OSA requires that unixODBC be installed preferrably with the GUI bits. Fortunately; unixODBC is included on all popular Linux distributions it just may not get installed by default. You will also want to install any ODBC drivers for the specific database(s you want to work with. For those unsure about whether to use the 32bit or the 64bit

Open System Architect alternatives

  • MySQL Workbench

  • MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, and much more. MySQL Workbench is available on Windows, Linux and Mac OS.

    tags: data-modeling database dba er-models gui-designer
  • dbForge Studio for MySQL

  • dbForge Studio for MySQL is the universal MySQL and MariaDB front-end client for database management, administration and development. Devart's MySQL GUI tool provides utilities to compare, synchronize, and backup MySQL databases with scheduling, and gives possibility to analyze and report MySQL tables data. dbForge Studio for MySQL now works with any MariaDB database servers, and supports all MariaDB objects types. Everyone can visually design database structures, execute SQL queries and scripts, and manage MariaDB users and privileges. »

    tags: builder code-completion debugger development export-to-mysql
  • SQL Power Architect

  • The SQL Power Architect data modeling tool was created by data warehouse designers and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.

    tags: database-layout forward-engineering reverse-engineering sql
  • Aqua Data Studio

  • Aqua Data Studio is a complete Integrated Development Environment (IDE) for database developers. It provides four major areas of functionality: 1) Database query and administration tools; 2) a suite of compare tools for databases, source control and file systems; 3) a complete and integrated source control client for Subversion (SVN) and CVS; and 4) a database modeler as powerful as the best standalone database diagramming tools.

    tags: database multiple-db-support mysql postgresql
  • DeZign for Databases

  • Database design and modeling tool - DeZign for Databases. Features: visual database design, data modeling ER Diagrams (ERD), Reverse Engineering, database creation, sql script generation.

    tags: database development diagramming er-diagram erd
  • erwin Data Modeler

  • erwin Data Modeler provides a collaborative environment to manage enterprise data though an intuitive, graphical interface. With a centralized view of key data definitions, you can leverage information as a strategic asset and more efficiently manage your data resources to save time and money.

    tags: data-management data-modeling database-development database-management java-ide
  • SAP PowerDesigner

  • SAP PowerDesigner: Enterprise Architecture tools for digital transformation successPlan and manage complex business transformation initiatives with SAP PowerDesigner. The software’s data modeling tools let you build a blueprint of your current enterprise architecture and visualize the impact of change before it happens. Automatically capture architecture layers and requirements, tap into a powerful metadata repository, and share discoveries with your team.

    tags: data-modeling entity-relationship-diagram erd uml
  • DB Designer

  • DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.

    tags: Discontinued mysql reverse-engineering
  • DbWrench

  • DbWrench is a multi-vendor, multi-platform database design and synchronization software. Features include a syntax highlighting SQL query editor, support for many of today's most popular databases, a graphic entity relation diagram (ERD) designer, and the ability to forward and reverse engineer databases.

    tags: code-completion database-design database-management database-sync diagramming
  • Model Xtractor

  • Free visual data modeling inspection tool for most popular one-way reverse-engineered relational databases. With a generic graphical interface, and auto-generated detailed, structural, relationships, simple, graph or topological models. Expanded, collapsed, minimized or transparent shapes. Chain relationships, custom joins and aliases, to enhance your model without altering the database itself.

    tags: data-modeling entity-relationship-diagram
  • ER/Studio Data Architect

  • ER/Studio is the an industry-leading data modeling tool helping companies discover, document, and re-use data assets.

    tags: architecture data-modeling
  • Mogwai ERDesigner

  • The Mogwai ERDesigner is an entity relationship modeling/design tool(ERD) such as ERWin and co. The only difference is that it is Open Source and does not cost anything. It was designed to make database modeling as easy as it can be and to support the developer in the whole development process, from database design to schema and code generation

    tags: Discontinued database-layout forward-engineering reverse-engineering sql
  • PostgreSQL Maestro

  • PostgreSQL Maestro allows you to create, edit, copy, drop and dump all Postgres database objects. It is a PostgreSQL GUI admin tool working as a Postgres client for Windows. You can also design your PostgreSQL database as ER diagram, build queries visually, execute SQL queries and scripts, debug PL/pgSQL functions, view and edit data including BLOBs, represent data as diagrams, export and import data from CSV and other file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), manage PostgreSQL roles, users, groups and privileges, and use a lot of other Postgres admin tools. »

    tags: database-management development graphical-user-interface postgres postgresql