How do I change the database provider in Orchard?

Question

After doing a test install of Orchard 1.0, I've decided I want to use regular SQL Server instead of SQLCE. How do I change the provider? And, how do I re-run the database setup?

Answer 1

Best thing to do is to delete all files from under your App_Data folder in Orchard.Web, this way you can start fresh :)