(SQL server 2005 express to SQL server 2005)
By Lee Sykes
July 2007
In this tutorial we demonstrate how to transfer a localhost DotNetNuke installation to a live hosted website.
This covers how to transfer a localhost site which uses an SQL Server 2005 Express database to a hosting provider which uses an SQL Server 2005 database.
This method is much more reliable than the portal template and site wizard method for transferring data from a localhost installation to a live website as it does not suffer the same problems as the portal template method.
For example, this method transfers all data and modules, all registered users and security roles etc, the tab ids remain the same and it can easily transfer the data from a large site. The portal template method has problems with each of those elements. We have already covered the portal template method in this tutorial:
DotNetNuke Portal Templates and the Site Wizard
Once you have watched this video tutorial, make sure you follow this tutorial: Find and Replace SQL queries for DotNetNuke (To fix any image URL problems after transferring a localhost database to a live site and other useful functions)
Video 1
- Introduction
- Demonstration of localhost DotNetNuke installation
- How to add the live url to the portal alias of the localhost portal (www.igfilm.com)
- How to create a backup file of the localhost SQL Server express 2005 database
- Viewing the current location of the database in the DotNetNuke installation files
- Opening SQL server management studio express
- How to attach the localhost DotNetNuke database to SQL server express
- Viewing the tables of the localhost DotNetNuke database
- How to create a backup file of the localhost DotNetNuke database
- How to locate and create a copy of the backup database file
Time Length: 8min 51secs
Video 2
- How to fix errors when viewing the localhost DotNetNuke installation after attaching it to SQL server express
- How to create a login using SQL server express
- How to add the new user login to the attached localhost igfilm database
- Editing the web.config file
- Editing the connection string for SQL Server express using the new attached igfilm localhost database
Time Length: 6min 28secs
Video 3
- Editing the web.config file for the live server
- Editing the connection string for connecting to the hosting providers SQL server 2005
- How to upload via FTP the backup database file to the hosting provider
- How to create an app_offline.htm file
- How to upload the DotNetNuke installation files to the hosting provider
Time Length: 8min 44secs
Video 4
- Viewing the hosting providers control panel
- How to check ASP.NET 2.0 is enabled
- How to create an SQL Server 2005 database
- How to specify the database name, database login and database password
- How to restore the SQL server 2005 express localhost database over the new SQL server 2005 hosting providers database
- Renaming the web livesite.config file
- Sending a support ticket to your hosting provider, requesting the correct permissions for DotNetNuke and the database
- Viewing the live site: ww.igfilm.com
- Renaming the app_offline.htm file
- Viewing the live site: www.igflim.com
- Demonstration of images not displaying
- Viewing the pages
- Checking the FileManager to ensure the image files have been uploaded
- How to manually fix the display of the images
Time Length: 8min 58secs
Total Time Length: 33min 01secs