>I get an error from the VFP 8 upsize wizard that it can't set SQL Server to the right compatibility mode. Is there a work around or does someone have something that will generate SQL 2005 scripts.

You've acces to the upsizing Wizard source code which is located in Tools/Xsource/Xsource.zip. Feel free to explore it.