Remove, Reinstall, or Reconfigure? on Development Machine

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
1/5/2011 2:24:07 PM
NWResearch
Gravatar
Total Posts 2
View Posts

Remove, Reinstall, or Reconfigure? on Development Machine

Configuration needed to allow local development of mojoPortal for use on a .NET 3.5/MSSQL 2005 server.

Development machine has a dual-boot configuration:

Win7 Pro x64
mojoPortal current version
MSSQL 2008 Express database
Visual Studio 2010 Professional
(no issues on this installation)

Vista Ultimate x64
mojoPortal Version 2.3.3.9
MSSQL 2008 Express database.
Visual Web Developer 2008 Express SP1.
(ALL were installed via MS Web Platform Installer on 03/21/2010)
.NET Framework 3.5 SP1, as well as .Net Framework 4 Extended.


1) This mojoPortal install was never altered or used in any way, I just looked at. It has no value to me.
2) The MSSQL 2008 Express database was never altered or used in any way. It has no value to me, (I don't think).
3) mojoPortal was incorrectly installed in directory: inetpub/wwwroot/mojoportal so the url became localhost/mojoportal instead of localhost.


HERE IS MY DELEMA:

I'm faced with a site upgrade on a "Network Solutions" server providing .NET 3.5 and a MSSQL 2005 database.


To me it makes sense to setup this dual-boot machine on the Vista side for use with the older database.

1) This would mean removing/repairing/version_changing due to the incorrect install location of mojoPortal. How? (non-WPI?)
2) Removing (or altering) MSSQL 2008 Express database. (I don't think I need it) How?
3) Installing MSSQL 2005 Express database. (non-WPI?).

What issues do I face, and what would be the best approach?
Are there mojoPortal version or feature limitations based on a .Net Framework 3.5 server?
What versions of Visual Studio or Visual Web Developer (if any) work with MSSQL 2005 Express database, or is this an issue?
Are there IIS software version or removal issues involved when using MSSQL 2005?

I expect issues I've not thought of, and perhaps more than one approach.

Your thoughts and advice would be greatly appreciated.

Thanks in advance you for your help!

Kerry

1/6/2011 7:03:18 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Remove, Reinstall, or Reconfigure? on Development Machine

Hi,

I recommend backup the production site completely and do the upgrade on the production site.

http://www.mojoportal.com/upgrading.aspx

Then if you want a copy on your local machine you can copy all the files from production and get a backup from the SQL 2005 database at the host and restore it in SQL 2008 on your dev machine.

Once you have a production site in place the production database should always be the master and you can periodically get a backup and restore it on your dev machine to have it up to date on your dev machine, I would never go the other way and restore a database from dev to production except maybe for initial deployment of a site, after that new data comes in from production like users register on the site or make forum posts etc and the production db should always be the official version.

I would stick with Win7 and VS 2010 Pro for development. Note however that the production deployment files don't have any C# source code (it is all pre-compiled into dlls in the /bin) so they are not really meant for use in VS though you can typically run it in VS.

Hope it helps,

Joe

 

1/6/2011 1:07:30 PM
NWResearch
Gravatar
Total Posts 2
View Posts

Status of current website.

Thanks Joe for your quick response.

As hard as I tried to be complete in my post it appears I left out some valuable information, sorry.

The current website running on that server is all but worthless. It does not at this time use mojoPortal or make use of a database even though it's there. However being a business they need to keep running as is, until mojo is ready to bark (pun intended).

That is why I was leaning toward setting it all up & testing locally. Once uploaded and tweaked some more, tech support says they can redirect to the new mojoPortal site, leaving the old website intact as a backup.

Does this new information change your viewpoint?

Thank you sir.

Kerry 

1/9/2011 9:53:36 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Remove, Reinstall, or Reconfigure? on Development Machine

Hi Kerry,

Sorry meant to get back to this thread sooner.

You can create the site and content on your local machine then move it to production but you should read this article before you set it up on your local machine:

http://www.mojoportal.com/moving-an-installation-of-mojoportal-to-a-different-server.aspx

But the dilemma remains that you cannot take a backup from SQL 2008 and restore it on SQL 2005. So your options are to make an instance of SQL 2005 available in your dev environment somehow, possibly you could create virtual machine with Windows Virtual PC. Or the only other option that "might" be viable is to work in your local environment under SQL 2008 but then use a 3rd party tool or scripts to generate scripts that have both the schema and the data, tools such as Red Gate SQL Bundle can do it and you might be able to do it with this free tool/script.

Hope it helps,

Joe

You must sign in to post in the forums. This thread is closed to new posts.