On 02/13/2012 03:24 PM, Reindl Harald wrote:
> hi
>
> is there a really good reason dropping all foreign keys
> and create them new? this queries are running a very
> long time (i am testing your convert-sql this moment)
This script was changed to be more robust in the face of slightly
different BIGINT columns.
Changing the widths on columns involved in key constraints is only
possible after first dropping the key entirely.
If the 'old' script (pre-today) worked for you: use that.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/i...@nfg.nl/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
