The migration from sql 2005 to sql 2008 is an option and yet the site can be migrated without moving from SQL 2005 to sql 2008 if not possible the site for sitefintiy 6.2 which will accept the migrated data can be running sql 2005.
The options are to migrate sitefinity 3.7 site from sql 2005 to 2008 or keep the version of SQL server used as database server 2005 and create the new sitefinity 6 site at sql 2005.
I recomend to move to sql 2008 to benefit from its improvements.
We're moving a backup from one host to a new host.
We've successfully restored the web files to FTP and the DB.
I understand next step is to edit ~/App_Data/Sitefinity/Configuration/DataConfig.config
to point to the Database on the new host.
I've edited the original:
dbType="MsSql" name="Sitefinity" />
wwwww = IP addres of the DB
xxxxxx = Username to connect to the DB
yyyyyy = DB PAssword
zzzzzz = DB Name
The website still doesn't work. It's throwing the following:
Server Error in '/' Application.
Row not found: GenericOID@8f011a6 SchemaVersion id=d875511a-8a85-401c-b563-5ae0732150a0
UPDATE [sf_schema_vrsns] SET [connection_hash]=?, [last_upgrade_date]=? WHERE [id] = ? AND [connection_hash]=?
(set event logging to all to see parameter values)
Any suggestions on next steps?