Pretty easy. You just have to make sure that your SELECT-SQL are not ambigous (see help file on SET ENGINEBEHAVIOR)

>Just wondering if anyone here had any experience upgrading from 6.0 to 8.0. If yes, how smooth was the transition?