SEO

#1 (**permalink**) 04-08-2008, 08:56 PM

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

#2 (**permalink**) 04-08-2008, 08:57 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.

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

#3 (**permalink**) 04-08-2008, 08:57 PM

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

#4 (**permalink**) 04-08-2008, 08:57 PM

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
>

#5 (**permalink**) 04-08-2008, 08:57 PM

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.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#6 (**permalink**) 04-08-2008, 08:57 PM

> 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#7 (**permalink**) 04-08-2008, 09:00 PM

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

gsql-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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode