[SPT/CWIS] merging data...

[Edward Almasy]

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)