Set up a DotNetNuke site

1. Copy your site code to the new location
2. Update the connection string in web.config
3. Run the sql script on the server
4. Grant EXECUTE permissions to ur database user on all the stored procedures
5. update the application name in the aspnet_Applications table as well as the web.config applicationname attribute
6. update the PortalAlias table in the database to set the new location
7. browse your new site :)

http://michaelkizer.com/Blog/tabid/117/articleType/ArticleView/articleId/14/Setting-up-a-local-test-copy-of-your-hosted-DNN-site.aspx