JohannL,

My first thought is that you should not have any trouble migrating from one to another. You should be able to create a full database backup and restore that to SQL Server 2005 Express. This issue that you are seeing may be related to the database owner and object qualifier attributes in your web.config file. Are you using a different version of the code with this new database backup (therefore a new web.config?)

Look for these attributes on the SqlDataProvider element in the providers section:  objectQualifier="dnn_" databaseOwner="dbo"

Let me know if thats of any help,

Ian

For those migrating from SQL Server 2005 Developer edition to SQL Server 2005 Express there is one change that you will need to make in the web config file within DotNetNuke.

After migrating the website files and restoring the back up of the database that you want you may get an error or message informing that a particular table/stored proc cannot be found, and you notice that that the stored proc/table contains a "dnn_" prefix infront.

Have a look at the tables/stored procs in your database and briefly see if the object contain the following prefix "dnn_" in front of the objects. If they do then in the webconfig file search for the objectQualifier. This will be set as objectQualifier="". You will need to change it to read objectQualifier="dnn_".

This should fix your website up.