14

I have been using database project in Visual Studio 2010 to maintain/version control database schema and are quite happy with that since I can also use VBDBCMD to deploy the version controlled schema to any database instance quite easily.

Now I need to work with PostgreSQL and I am wondering if there is any tool similar to the "database project" thing in Visual Studio to help version control database schema as well as schema deployment.

Thanks.

Improve this question
3
  • sigh, not even a suggestion? just downvote? no love for new comer?
    – Jach
    Commented Dec 2, 2013 at 6:20
  • 5
    Perfectly reasonable question, as this isn't a "what's best" or "what should I pick", but "does anything exist". There's not much out there, really.
    – Craig Ringer
    Commented Dec 5, 2013 at 11:27
  • 1
    wonder why I didn't find this last time :P Liquibase seems like the solution I am looking for. stackoverflow.com/questions/846659/…
    – Jach
    Commented Oct 22, 2015 at 1:11

1 Answer 1

Reset to default
5

The closest thing I could suggest would be Eclipse with the Toad plugin.

In general, shopping list questions are disfavored on Stack Exchange sites because they tend to solicit opinions and tend to go out of date quickly.

The other option is to use a source code management solution like git or subversion, and then just use your standard text editors on the SQL files. This is what we do in the LedgerSMB project.

Improve this answer
1
  • I know that's a long shot after a couple days of fruitless googling. But thanks for sharing your experience and I afraid that's what best for now.
    – Jach
    Commented Dec 6, 2013 at 2:23

Not the answer you're looking for? Browse other questions tagged or ask your own question.