[SPT/CWIS] merging data...

[Chris Beck]

Along those lines, can you upgrade using the web install version?

--
Dr. Christopher Beck
Department of Biology
Emory University
1510 Clifton Rd.
Atlanta, GA 30322

Email: christopher.beck at emory.edu
Phone: 404-712-9012
FAX: 404-727-2880

> -----Original Message-----
> From: spt-cwis-users-bounces at scout.wisc.edu [mailto:spt-cwis-users-
> bounces at scout.wisc.edu] On Behalf Of Hunter, Tim
> Sent: Thursday, April 17, 2008 3:30 PM
> To: SPT / CWIS Users Discussion List
> Subject: Re: [SPT/CWIS] merging data...
> 
> 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
> 
> _______________________________________________
> SPT-CWIS-Users mailing list
> SPT-CWIS-Users at scout.wisc.edu
> http://www.scout.wisc.edu/mailman/listinfo/spt-cwis-users
>