[SPT/CWIS] merging data...

[Hunter, Tim]

Hi Ed,

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.

Thanks,
-Tim 

-----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:18 PM
To: SPT / CWIS Users Discussion List
Subject: Re: [SPT/CWIS] merging data...

On Apr 17, 2008, at 12:15 PM, Hunter, Tim wrote:
> We've got an older version of CWIS with 38 tables in the MySQL  
> database and the new 1.5 version has 45 tables.  What is the best  
> way to go about merging the data to make everything work with  
> minimal problems?  Should we just replace the 38 tables that  
> (probably) exist on the 1.5 version and leave the new 7 other tables  
> alone?

If you're upgrading to 1.5.0 via the command-line installation script,  
it will create any new tables or columns required in your database as  
part of the upgrade process.

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.0/1382 - Release Date: 4/16/2008 5:34 PM