database.sarang.net
UserID
Passwd
Database
ㆍDBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
DBMS Q&A 2500 게시물 읽기
No. 2500
GUI Database Design Tools / Data Modelling Tools / DBDesigner for PostgreSQL
작성자
DATABASE
작성일
2012-11-26 23:42
조회수
20,846






--------------------------------------------------------------------------------------------

GUI Database Design Tools - PostgreSQL wiki


http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools


--------------------------------------------------------------------------------------------

DBDesigner Fork - Browse /dbdesigner-fork at SourceForge.net
DB Designer Fork - Browse /dbdesigner-fork at SourceForge.net

http://sourceforge.net/projects/dbdesigner-fork/files/dbdesigner-fork/


--------------------------------------------------------------------------------------------

dbd4topostgres - Free program to generate sql scripts from DBDesigner 4 model to Postgresql - Google Project Hosting

http://code.google.com/p/dbd4topostgres/


--------------------------------------------------------------------------------------------

How to configure DBDesigner to connect with PostgreSQL (Win XP)

http://dev.bnet.pl/blog/?p=18




November 21 2006
How to configure DBDesigner to connect with PostgreSQL (Win XP)

First what you have to do is download odbc driver to PostgreSQL. You can find it on this site:
ODBC driver . Instalation is very simple, just click next, next … After that you can configure your postgresql odbc connection go to:

    * menu
    * control panel
    * admin tools
    * sources data (ODBC)

Open the last one, select user dsn tab, click add. Scroll down and find PostgreSQL driver name, select PostgreSQL Unicode, then click OK. After that you will see window perform field like below :

    * data source: PostgreSQL30W
    * database: your database name which you want connect
    * server: localhost (if it's on this same machine)
    * user name: user name ;)
    * description: can be empty
    * SSL mode: disable (or choice what you need)
    * port: 5432
    * password: ****** (user pass)

Then you can try test this setting by click test, if you will see "Connection succsessful" everything is ok now you can run dbdesigner;
Go:
-> file;
-> open from databse;
-> choice ODBC -> NewODBCConn
-> click New Database connection.

You will see window perform field like below:

    * connection name: whatever
    * driver: should be selected odbc if not select it
    * connection settings: don't touch
    * odbc dsn name: PostgreSQL30W
    * username: user name ;)
    * password: ***** (user pass)
    *
    *

Close this window and go to Database -> Reverse Engineering. You will see window called Select Database Connection, so select your connection and click Connect. On the next window you can select what you want import from db (choice it on Schema) after that just click "Execute”. And that`s all. After that you will see that what you selected on schema.

--------------------------------------------------------------------------------------------

DBDesigner 4 - Base de donne'es - Logiciels Libres - Framasoft

http://www.framasoft.net/article2656.htmlwww.framasoft.net/article4695.html#comments68083

--------------------------------------------------------------------------------------------

DBDesigner and PostgreSQL

http://www.tv.com.pl/stepbystep/dbdesigner/

--------------------------------------------------------------------------------------------

DBDesigner for PostgreSQL?

http://www.sitepoint.com/forums/showthread.php?373517-DBDesigner-for-PostgreSQL

--------------------------------------------------------------------------------------------

Data Modelling Tools

http://databaseanswers.org/modelling_tools.htm


DBDesigner-Fork : A Fork of DBDesigner 4 (see above)- generates SQL scripts for Oracle, SQL Server, MySQL and FireBirdSQL.

--------------------------------------------------------------------------------------------

Postgre DBDesigner tool - dBforums

http://www.dbforums.com/postgresql/1669385-postgre-dbdesigner-tool.html


MicroOLAP Database Designer for PostgreSQL: GUI tool for visual database generation, modification and reverse engineering

http://microolap.com/products/database/postgresql-designer/

--------------------------------------------------------------------------------------------

DbDesigner homepage

http://dbdesigner.sourceforge.net/


Visual Database Designer for KDE2 | Free Development software downloads at SourceForge.net

http://sourceforge.net/projects/dbdesigner/



Visual Database Designer for KDE2 - Browse /dbdesigner at SourceForge.net

http://sourceforge.net/projects/dbdesigner/files/dbdesigner/


--------------------------------------------------------------------------------------------












 

[Top]
No.
제목
작성자
작성일
조회
2600DB 설계를 위한 방법론 이란게
마루치
2013-07-24
21921
2587API로 ODBC 공부를 하고 있습니다.
박순호
2012-12-15
20737
2502간단한 데이터베이스 구축해주실분 연락주세요
이지은
2012-11-28
19754
2500GUI Database Design Tools / Data Modelling Tools / DBDesigner for PostgreSQL
DATABASE
2012-11-26
20846
2428[추천요청] 데이터베이스 설계,모델링툴 추천부탁 (PostgreSQL용/MariaDB용 등등) (오픈소스로.) (책,서적도 추천부탁)
DB초보
2012-11-17
18992
2420국내 리딩 솔루션 기업 Pre-Sales 엔지니어 모십니다.
김규빈
2012-09-10
17451
2419관계가 맺어지지 않은 테이블 분석을 어찌해야 할까요? [1]
분석초보
2012-08-22
16544
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2023 DSN, All rights reserved.
작업시간: 0.046초, 이곳 서비스는
	PostgreSQL v16.1로 자료를 관리합니다