Thread: Data Modelling Tools
Postgres Newsgroup,
My company has been looking for a good database modelling tool for postgres and have yet to find something that completely satisfies our needs. We are currently using a product called DBWrench which is pretty good and has all the features we are looking for but is full of bugs and creates much head ache.
For example, this tool doesn’t realize that in postgres you can’t add a column and set not null in one ALTER TABLE statement. So we are forced to manually comb through the SQL scripts it creates and fix the buggy statements.
So my question is, postgres general newsgroup, what database modelling tools do you use? Open source or commercial it doesn’t matter to me.
Thank you,
Mark
Mark Borins wrote: > --> > > Postgres Newsgroup, > > > > My company has been looking for a good database modelling tool for > postgres and have yet to find something that completely satisfies our > needs. We are currently using a product called DBWrench which is pretty > good and has all the features we are looking for but is full of bugs and > creates much head ache. Case Studio? Sincerely, Joshua D. Drake -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedication Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
Sorry, I should have also specified that we are looking for a tool where we can save the schema externally. Then take that schema and have the tool compare it to a database and generate a change script. So the process would be to maintain database structure in a tool. Be able to save the schema. Then have the tool compare the schema to an existing database and generate a SQL change script to update the database model. I am not an expert user of pgadmin, but my understanding is that it lets you maintain a particular database, but does not have facilities for comparing schemas and generating change scripts, etc. ________________________________________ From: Matthew Terenzio [mailto:matt@jobsforge.com] Sent: May 9, 2005 5:48 PM To: Mark Borins Subject: Re: [GENERAL] Data Modelling Tools these are among some popular tools, the second being web based. http://www.pgadmin.org/ http://phppgadmin.sourceforge.net/ On May 9, 2005, at 5:35 PM, Mark Borins wrote: Postgres Newsgroup, My company has been looking for a good database modelling tool for postgres and have yet to find something that completely satisfies our needs. We are currently using a product called DBWrench which is pretty good and has all the features we are looking for but is full of bugs and creates much head ache. For example, this tool doesnt realize that in postgres you cant add a column and set not null in one ALTER TABLE statement. So we are forced to manually comb through the SQL scripts it creates and fix the buggy statements. So my question is, postgres general newsgroup, what database modelling tools do you use? Open source or commercial it doesnt matter to me. Thank you, Mark
Other possibilities:
http://www.datanamic.com/dezign/factsheet.html
http://www.visual-paradigm.com/product/dbva/
From: Dann Corbit
Sent: Monday, May 09, 2005 3:24 PM
To: 'Mark Borins'
Subject: RE: [GENERAL] Data Modelling Tools
Free trial:
http://www.dds-pro.com/main.html
Says it supports PostgreSQL:
http://www.casestudio.com/enu/default.aspx
See also:
http://www.inf.unibz.it/%7Efranconi/icom/
http://wwwhome.cs.utwente.nl/%7Etcm/
I use ER/Win for everything, but it is very pricey and it does not support PostgreSQL directly (only indirectly via ODBC).
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Mark Borins
Sent: Monday, May 09, 2005 2:35 PM
To: pgsql-general@postgresql.org
Cc: rickb@rigadev.com
Subject: [GENERAL] Data Modelling Tools
Postgres Newsgroup,
My company has been looking for a good database modelling tool for postgres and have yet to find something that completely satisfies our needs. We are currently using a product called DBWrench which is pretty good and has all the features we are looking for but is full of bugs and creates much head ache.
For example, this tool doesn’t realize that in postgres you can’t add a column and set not null in one ALTER TABLE statement. So we are forced to manually comb through the SQL scripts it creates and fix the buggy statements.
So my question is, postgres general newsgroup, what database modelling tools do you use? Open source or commercial it doesn’t matter to me.
Thank you,
Mark
This is my fav....its just awesome... http://www.sqlmanager.net/ On 5/9/05, Mark Borins <mark.borins@rigadev.com> wrote: > > > > Postgres Newsgroup, > > > > My company has been looking for a good database modelling tool for postgres > and have yet to find something that completely satisfies our needs. We are > currently using a product called DBWrench which is pretty good and has all > the features we are looking for but is full of bugs and creates much head > ache. > > > > For example, this tool doesn't realize that in postgres you can't add a > column and set not null in one ALTER TABLE statement. So we are forced to > manually comb through the SQL scripts it creates and fix the buggy > statements. > > > > So my question is, postgres general newsgroup, what database modelling tools > do you use? Open source or commercial it doesn't matter to me. > > > > Thank you, > > Mark
I have to say that ERwin is pretty much the bomb. It indirectly supports postgresql through ODBC, which I've used with much success. It will also port your schema to another RDBMS system if you wish. It can build a model from either a running database or DDL or by construction, and will also output to all of the above. Very excellent tool, but I think it's about $4k/license. Is it worth it? hell yeah. Alex Turner netEconomist On 5/9/05, Mark Borins <mark.borins@rigadev.com> wrote: > Sorry, I should have also specified that we are looking for a tool where we > can save the schema externally. Then take that schema and have the tool > compare it to a database and generate a change script. > > So the process would be to maintain database structure in a tool. > Be able to save the schema. > Then have the tool compare the schema to an existing database and generate a > SQL change script to update the database model. > > I am not an expert user of pgadmin, but my understanding is that it lets you > maintain a particular database, but does not have facilities for comparing > schemas and generating change scripts, etc. > > ________________________________________ > From: Matthew Terenzio [mailto:matt@jobsforge.com] > Sent: May 9, 2005 5:48 PM > To: Mark Borins > Subject: Re: [GENERAL] Data Modelling Tools > > these are among some popular tools, the second being web based. > > http://www.pgadmin.org/ > > http://phppgadmin.sourceforge.net/ > > > On May 9, 2005, at 5:35 PM, Mark Borins wrote: > Postgres Newsgroup, > > My company has been looking for a good database modelling tool for postgres > and have yet to find something that completely satisfies our needs. We are > currently using a product called DBWrench which is pretty good and has all > the features we are looking for but is full of bugs and creates much head > ache. > > For example, this tool doesn't realize that in postgres you can't add a > column and set not null in one ALTER TABLE statement. So we are forced to > manually comb through the SQL scripts it creates and fix the buggy > statements. > > So my question is, postgres general newsgroup, what database modelling tools > do you use? Open source or commercial it doesn't matter to me. > > Thank you, > Mark > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >
Case Studio doesn't generate alter statements. It does have a database comparison tool, which I have found to be very cool. ""Joshua D. Drake"" <jd@commandprompt.com> wrote in message news:427FDC3F.3090700@commandprompt.com... > Mark Borins wrote: > > --> > > > > Postgres Newsgroup, > > > > > > > > My company has been looking for a good database modelling tool for > > postgres and have yet to find something that completely satisfies our > > needs. We are currently using a product called DBWrench which is pretty > > good and has all the features we are looking for but is full of bugs and > > creates much head ache. > > > Case Studio? > > Sincerely, > > Joshua D. Drake > > > > -- > Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 > PostgreSQL Replication, Consulting, Custom Programming, 24x7 support > Managed Services, Shared and Dedication Hosting > Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
Joshua D. Drake wrote: >> My company has been looking for a good database modelling tool for >> postgres and have yet to find something that completely satisfies our >> needs. We are currently using a product called DBWrench which is >> pretty good and has all the features we are looking for but is full of >> bugs and creates much head ache. > > Case Studio? I love Case Studio (www.casestudio.com). It's inexpensive, well-supported, easy to use. Problem is that it doesn't do the DDL diff that he wants. I was looking for exactly the same feature/tool last year to build update scripts for client schemas.
> For example, this tool doesn't realize that in postgres you can't add a > column and set not null in one ALTER TABLE statement. So we are forced to > manually comb through the SQL scripts it creates and fix the buggy > statements. AFAIK started from version 8 it can be combined into single alter statement. speaking of visual tools - does anyone know a tool to "pretty" SQL statement (ala "tidy")? Sometimes we have to dig thruogh auto-generated SQL queries 30k-60k size, which is quite hard to do when it's one row w/o any indents and line breaks. -- Vlad
Mark Borins <mark.borins@rigadev.com> wrote:
Postgres Newsgroup,
My company has been looking for a good database modelling tool for postgres and have yet to find something that completely satisfies our needs. We are currently using a product called DBWrench which is pretty good and has all the features we are looking for but is full of bugs and creates much head ache.
For example, this tool doesn�t realize that in postgres you can�t add a column and set not null in one ALTER TABLE statement. So we are forced to manually comb through the SQL scripts it creates and fix the buggy statements.
So my question is, postgres general newsgroup, what database modelling tools do you use? Open source or commercial it doesn�t matter to me.
Thank you,
Mark
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
Do you know if this program will do forward-engineering. I would like to be able to take a copy of my live database. Reverse engineer it into SQLManager, modify it. Then forward-engineer, do you know if SQLManager allows me to do that? -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Hrishikesh Deshmukh Sent: May 9, 2005 6:54 PM To: Mark Borins Cc: pgsql-general@postgresql.org; rickb@rigadev.com Subject: Re: [GENERAL] Data Modelling Tools This is my fav....its just awesome... http://www.sqlmanager.net/ On 5/9/05, Mark Borins <mark.borins@rigadev.com> wrote: > > > > Postgres Newsgroup, > > > > My company has been looking for a good database modelling tool for postgres > and have yet to find something that completely satisfies our needs. We are > currently using a product called DBWrench which is pretty good and has all > the features we are looking for but is full of bugs and creates much head > ache. > > > > For example, this tool doesn't realize that in postgres you can't add a > column and set not null in one ALTER TABLE statement. So we are forced to > manually comb through the SQL scripts it creates and fix the buggy > statements. > > > > So my question is, postgres general newsgroup, what database modelling tools > do you use? Open source or commercial it doesn't matter to me. > > > > Thank you, > > Mark ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org