Sharepoint 2007 to Sharepoint 2010 with separate MSSQL server
I currently have a 2003 server with Sharepoint 2007 on it. The databases are also on it, SQL 2008 express. I also have two virtual machines. One has SQL 2008 enterprise on it. The other is ready for Sharepoint 2010 to be installed.
I would like to migrate the databases to the dedicated SQL server and also upgrade to Sharepoint 2010. I am fairly new to this and have not performed this before. Can anyone provide me the best way to perform these actions and in what order as to not break the flow of production?
ExchangeMicrosoft SharePointMicrosoft SQL Server 2008