We have a publishing site with some custom webparts but I'm not really concerned about those as I can probably recompile and redeploy them. Having said that, I'm trying the "database attach" method. I was following a word document titled SharePoint 2010 Cookbook: How to Migrate a SharePoint 2007 site to SharePoint 2010 Using Database Attach".
It describes three steps in which the first step rather redundant: "Move the site to a new web application in SharePoint 2007". So if there is a hidden magic in the step that I don't see please explain, as I skipped this part.
Step two instructs to "Copy a content database backup to the SP2010 SQL Server". What we have is a 64 bit Win 2008 running a SQL 2008 R2.
Next I had created a web application and blank site collection. For convenience I've renamed the database to match it with "migrating" database.
After all that, I've restored the 'migrating" database over the database on the SP2010 SQL server.
Needless to say it did not work. The browser has a plain black on white error: "500 INTERNAL SERVER ERROR". In the manage database upgrade status of the Central Administration the said database status is "not responding". SQL server is running; service account is a domain level account with full admin rights; both servers on the same domain. Have you any ideas as to how to make this work?