tags:

views:

118

answers:

2
+3  Q: 

Is there a script for generating a migration SQL (postgres) file?

On a project I work I have sometimes have to deal with changes on the table structure, like adding fields. Is there a script that can I use for generate a migration SQL file with only the changes?

PHP, bash or Perl would be nice. The database is postgresql.

+3  A: 

I only know this - Another PostgreSQL Diff Tool (it's java, though), but personally I don't trust computers that much and prefer hand-crafted update scripts.

Michael Krelin - hacker  2009-09-28 09:20:29
+3  A: 

Looking on CPAN there is this module which appears to fit the bill: DBIx::Migration::Directories.

/I3az/

draegtun  2009-09-28 11:00:23
Interesting. But for what I can tell by the list of packages, `postgresql` may not be supported.
Michael Krelin - hacker  2009-09-28 11:56:25
Under Features section it says "Works with Postgres, MySQL, and SQLite2". The list of packages you're referring to is to "handle quirks" in MySQL and SQLite2 ;-)
draegtun  2009-09-28 12:30:10
draegtun. Good to know. It just didn't occur to me that there's a single SQL that has no quirks to handle ;-) But then if it was a reference platform... +1 then ;-)
Michael Krelin - hacker  2009-09-28 13:53:04

related questions

IDE suggestions: Eclipse IDE vs. Zend Studio ( confused )
MySQL/Apache Error in PHP MySQL query
Lightweight IDE for Linux
What PHP framework would you choose for a new application and why?
Why is my ternary expression not working?
How can I get at the matches when using preg_replace in PHP?
Mechanisms for tracking DB schema changes
Wordpress theme development offline tools
Using object property as default for method property
How can I get the authenticated user name under Apache using plain HTTP authentication and PHP?
Make XAMPP/Apache serve file outside of htdocs
How do you debug PHP scripts?
PHP Variables passed by value or by reference?
Best way to implement unit testing in PHP
Connect PHP to an AS/400
Best way to access Exchange using PHP?
PHP Session Security
How do I access a remote form in php?
What's the best way to generate a tag cloud from an array? (using h1 through h6 for sizing)
Apache/PHP: error_log per Virtual Host?
How do I track file downloads with apache/PHP
How would you access Object properties from within an object method?
Flat File Databases in PHP
Best way to allow plugins for a PHP application
Latest information on PHP upcoming releases