Obviously I agree it's very hard to design a DB upgrade tool for models
you don't know about.

And all those SQL features you don't make use (like me) but hardcore SQL
addicts know about.


Matthias:  What's the input for your tool ? a DB text dump file or the
TG SQLObject model ?



Tim Lesher wrote:
> On 1/10/06, Matthias Urlichs <[EMAIL PROTECTED]> wrote:
>   
>> Hi,
>>     
>>> There is no automated way to do this, because this is a hard thing to
>>> do reliably.
>>>       
>> It's just a lot of work (write a parser for SQL's CREATE+ALTER TABLE
>> statements, save old and table structure, generate ALTER TABLE
>> statements from the difference)
>>     
>
> It's not hard to do for your own data model, because you already know
> what's there and what needs to be done.
>
> It's very hard to create a tool that will always do it correctly on
> every conceivable data model, on every database that TurboGears
> supports.
>
> --
> Tim Lesher <[EMAIL PROTECTED]>
>
>
>   

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to