I am in the process of migrating my DNN app to a new database on a different server.  The current database is a SQL Express instance mounted on a SQL Server v10.5 database.  The new database is not SQL express, it's a SQL Server database on version 10.0.

I was able to copy the database to the new SQL Server instance and have updated the Web.config file to point to it.  Now when I try to access my website, I get the DotNetNuke Installation Wizard.

I assume I shouldn't go through the install wizard, as I'm worried it might overwrite my existing application.  I also noticed there's a key in Web.config called UseInstallWizard.  Maybe I should set that to false.

Any suggestions are appreciated.

Cheers,
Matt

I think you're right.  After a fair amount of research, this is what I think we'll need to do.

Script the creation of all of the database objects and run the create script in the new database.
Use the SQL Server import/export data function to populate the tables in the new environment.

One sticking point that I'm aware of is that while importing data, we're going to run into foreign key constraints that prevent the inserts.  Maybe we'll end up deleting all FKs on the database and recreating after the import.

-Matt