Hello,
If you transfer DotNetNuke using this method:
How to copy a live site to a localhost installation(but in reverse)
You need to transfer all of your DotNetNuke installation files and the SQL database. - But, you are using an SQL express database and your server is probably an SQL 2005 database so I'm unsure if this is possible.
Your best bet will be to use the
How to copy the content from a localhost install to a live hosted website method. - But this method has problems if you have a large site and it can also have problems with URLs. - ie. the tab IDs of your pages change when you use the template method.
I tend to use the localhost for testing skins and modules etc but for adding content I add it directly to the live website. Remember, you can you use the security settings so that no users (Only admin) can view the new pages as you are adding them to the live website.
Thanks,