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
운영게시판
최근게시물
PostgreSQL Q&A 9046 게시물 읽기
No. 9046
GUI Database Design Tools / Data Modelling Tools / DBDesigner for PostgreSQL
작성자
DBDBDB
작성일
2012-11-18 12:18
조회수
9,963






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

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.
제목
작성자
작성일
조회
9064밑에 답변 주신분 감사합니다.
송기헌
2012-11-23
8781
9063VBA Recordset을 이용시 한글 데이터를 공란으로 인식하는 문제의 해결책 [1]
송기헌
2012-11-22
9370
9048C#에서 Postgresql 로그인 롤관련 에러문제입니다. 도와주세요. [2]
pride
2012-11-20
9320
9046GUI Database Design Tools / Data Modelling Tools / DBDesigner for PostgreSQL
DBDBDB
2012-11-18
9963
9044오라클(Oracle)을대용할수있는,오픈소스의갑(甲)PostgreSQL!!!
포스트그레SQL
2012-11-16
9075
9040프로시저에 대해서 질문합니다. [2]
VQ
2012-11-14
10384
9039언락상태로 데이터 읽기 [2]
VQ
2012-11-12
9059
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.025초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다