[SPT/CWIS] merging data...

[Hunter, Tim]

Where can I get a copy of the older CWIS versions?

-----Original Message-----
From: spt-cwis-users-bounces at scout.wisc.edu [mailto:spt-cwis-users-bounces at scout.wisc.edu] On Behalf Of Edward Almasy
Sent: Thursday, April 17, 2008 2:51 PM
To: SPT / CWIS Users Discussion List
Subject: Re: [SPT/CWIS] merging data...

On Apr 17, 2008, at 2:30 PM, Hunter, Tim wrote:
> We tried the web based install in a new directory with the sample  
> data provided.  The web install is nice, but we want to know the  
> best way to go about merging older data into the new structure.   
> Should we just replace the tables with the same name and leave the  
> new ones alone in MySQL?  Or is it better to just upgrade the whole  
> package through the command line.

The 100% web-based install beta 1.5.0 version is only intended for new  
installations, not upgrades.  (There's a note about this on the  
download page;  future versions will support upgrading via the web- 
based install.)  For existing sites we recommend using the command- 
line-based stable 1.5.0 release, which will upgrade both the files and  
the database when pointed at an existing SPT or CWIS installation.

Generally I would not recommend upgrading the database for an existing  
site by hand -- there are a lot of details to cover, and missing just  
one or two can result in some significant headaches -- but if you want  
to look at what database changes are required, most are contained in  
the "SPT--Upgrade--X.X.X--DBTables.sql" files, where "X.X.X" indicates  
the version for which the incremental changes are intended.

Ed


---
    Edward Almasy                             ealmasy at scout.wisc.edu
    Co-Director                                 1210 W Dayton Street
    Internet Scout                                  Madison WI 53706
    Computer Sciences Department                608-262-6606 (voice)
    University of Wisconsin - Madison             608-265-9296 (fax)





_______________________________________________
SPT-CWIS-Users mailing list
SPT-CWIS-Users at scout.wisc.edu
http://www.scout.wisc.edu/mailman/listinfo/spt-cwis-users

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.0/1382 - Release Date: 4/16/2008 5:34 PM
 

No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.3/1390 - Release Date: 4/21/2008 4:23 PM