I understand that you can't just go from SQL 2000 to 2012, you must first attach the db's to SQL 2005 or 2008.
Not all of our clients have access to an SQL 2005/2008 nor do they really want me to install the eval 2008 onto their server
So what I want to know is what really happens to the db's when you attach them to a later version of SQL?
If it just changes some header info or something surely we can make a script to 'trick' the db's into telling SQL 2012 that they've already been upgraded to SQL2008, or a script that actually does upgrade them?
No, all system objects get updated when you attach the database... If the database is less than 10 GB you can attach to SQL Server 2008 Express edition which is free product, otherwise, you can try building SSIS package to move the data (I
have not done this personally).
Best Regards,Uri Dimant SQL Server MVP,