Monday, October 06, 2008 ..:: Forums ::.. Register  Login
 Forums Minimize
SearchForum Home
     
  Mainstream Forums  Help  Upgrade from 1....
 Upgrade from 1.3 to 2.1
 
pesler
13 posts
Joined
12/16/2007

Upgrade from 1.3 to 2.1
Posted: 17 Jul 08 12:48 AM

Hi

I have inherited the task of administering 5 SplendidCRM v1.3 open source sites on our server. I need to upgrade to v2.1 but cannot find any documentation about how to upgrade my existing sites. Can anyone tell me the upgrade process when I have 5 sites all running on the same server?

Thanks

Paul

support
1972 posts
1st
Joined
1/3/2006

Re: Upgrade from 1.3 to 2.1
Posted: 17 Jul 08 3:32 AM

You should be able to just run the 2.1 upgrade and it will take care of everything.  You should make sure to backup the database before the upgrade just in case there is a problem.

 

pesler
13 posts
Joined
12/16/2007

Re: Upgrade from 1.3 to 2.1
Posted: 21 Jul 08 8:01 PM

It would be nice if it was that easy, but it's not, and hence my post.

This is what I am upgrading from:-

 
Web server:-
Windows 2003 Server std
IIS 6
I have multiple IIS web sites setup running seperate instances of SplendidCRM v1.3
The files are each stored in a seperate folder for each site.
e.g. Site1 points at d:\web_sites\site1\web site, Site2 points at d:\web_sites\site2\web site, etc.
We use IIS host headers plus a DNS (A) record to resolve site names
 
I did not set these up but I assume these were created by installing one original copy of v1.3 and then copy/paste into each folder to create new sites. I say this because I cannot find a way to use the SplendidCRM v1.3 (or v2.1) installer to install multiple instances on the same server. Each time you run the installer with the intention of installing a new instance, it just assumes you want to uninstall/restore the existing original one.
 
Anyway, my database server is on a seperate physical server:-
Windows 2003 Server std
SQL 2000
I have one database for each Site from above
I use an SQL login, not Windows login.
 
The above scenario currently works fine and has been for a number of years. I now need to upgrade all the sites. I followed the logical process of:-
 
Copying the file "SplendidCRM_2.1.3074.33397_Upgrade.msi" to the server, double clicking it to start the upgrade
When it asks for the location of the files I point it at Site1 location
When it reaches the database connection stage I configure it to connect to the existing v1.3 database
It continues and completes the upgrade, however, it shows several errors saying 'The remote name could not be resolved: 'root''
When I browse to the site it shows server errors and is unable to start the site
support
1972 posts
1st
Joined
1/3/2006

Re: Upgrade from 1.3 to 2.1
Posted: 21 Jul 08 9:46 PM Modified By support  on 7/21/2008 9:48:29 PM)

It is usually best to install SplendidCRM on a QA machine and just copy the files to the production server.  Our installation program does not, and simply cannot, account for all possible production environments.

As for configuring the web site to point to separate databases, the trick is to specify Registry as the SplendidProvider in the Web.config file:

 <appSettings>
  <add key="SplendidProvider" value="Registry" />
 </appSettings>

In the registry, we use the domain name to lookup the database connection.  The following text can be customized, saved as a .REG file then run on you web server to create the required entries:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\SplendidCRM Software]

[HKEY_LOCAL_MACHINE\SOFTWARE\SplendidCRM Software\demo1.splendidcrm.com]
"SplendidProvider"="System.Data.SqlClient"
"ConnectionString"="data source=(local)\SplendidCRM;initial catalog=SplendidCRM_DEMO1;persist security info=True;packet size=4096;user id=sa;password=splendidcrm2005"

[HKEY_LOCAL_MACHINE\SOFTWARE\SplendidCRM Software\demo2.splendidcrm.com]
"SplendidProvider"="System.Data.SqlClient"
"ConnectionString"="data source=(local)\SplendidCRM;initial catalog=SplendidCRM_DEMO2;persist security info=True;packet size=4096;user id=sa;password=splendidcrm2005"

[HKEY_LOCAL_MACHINE\SOFTWARE\SplendidCRM Software\demo3.splendidcrm.com]
"SplendidProvider"="System.Data.SqlClient"
"ConnectionString"="data source=(local)\SplendidCRM;initial catalog=SplendidCRM_DEMO3;persist security info=True;packet size=4096;user id=sa;password=splendidcrm2005"

Once the registry is setup, you can run the SplendidCRM Configuration Wizard to update each database.  However, if you have the SQL source code, your best bet is to use SQL Studio to update each database using the Build.sql file.

 

pesler
13 posts
Joined
12/16/2007

Re: Upgrade from 1.3 to 2.1
Posted: 25 Jul 08 1:47 AM

Thanks for the advice. I essentially solved the problem by installing v2.1 on a qa box and during the install I pointed it at a copy of my v1.3 database. This successfully upgraded the database and then I copied everything to my production server. I will continue the same process for all the other sites now

thanks

  Mainstream Forums  Help  Upgrade from 1....

Forum Home  Search       

Copyright (c) 2006-2008 SplendidCRM Software, Inc. All Rights Reserved.   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2008 by Perpetual Motion Interactive Systems Inc.
SplendidCRM and SplendidCRM Software are trademarks of SplendidCRM Software, Inc. SugarCRM is a trademark of SugarCRM Inc. in the United States, the European Union and other countries. All other trademarks used in this web site are the property of their respective owners.