P is for Practical | |
PerlMonks |
Re: Re: Automatically altering tables from different schema'sby liz (Monsignor) |
on Jan 08, 2004 at 16:54 UTC ( [id://319864]=note: print w/replies, xml ) | Need Help?? |
Instead I'd create a SQL script that has the ALTER TABLE statements so that it can be checked, and that the update operation is run in a controlled manner.
I'm going for ease of use, so any changes would be "automatic" (with maybe the option of not deleting columns automatically). But there would be an API to get at the primitives, so that you can indeed do what you propose. Liz
In Section
Seekers of Perl Wisdom
|
|