I'm looking to convert a database that was converted to 2008 format back to 2000 format. I've tried all the methods available in SQL Server Management Studio. Export data, script database, all that, and they all fail. Export doesn't seem to export everything needed, and the generated scripts always contain errors. The database is so huge, its impossible to find the errors in the generated scripts.
Does anybody have any advice.
You'll have export/import using SSIS/DTS (whether wizard or manual) or SMO. Or use a 3rd party compare tool such as Red Gate SQL Compare
There is no downgrade option