Re: [Bodington-developers] MySQL support now in HEAD

[Jon M. <jo...@te...>]

Peter Crowther wrote:

>>From: Matthew Buckett
>>But don't we just provide SQL migration?
>>    
>>
>
>If you can work out how to rename tables in a portable way, you're doing
>better than I am (SQL Server uses EXEC sp_rename 'oldname', 'newname',
>but there are limitations).  Or would you create the new table and move
>all the data and constraints across?
>  
>
I think the latter is a perfectly fine upgrade method - were talking 
about small amounts of data anyway in the tables in question. There are 
version upgrade routines anyway so it won't be hard to add some more 
work there;
if ( new tables don't exist)
{
    create new tables;
    copy records from old tables to new tables.
}