I've not seen a response to your enquiry on this list, so thought I
would reply by saying that I think the link you refer to is for updating
between versions of WebPA 1, and does not relate to WebPA 2.
When converting the code from WebPA 1 to WebPA 2 I did write a script to
validate the existing WebPA 1 data (check for internal consistency as
the database did not include any referential integrity constraints) and
generated a set of SQL statements for copying data from the old
structure to the new. I am not aware of these being documented or
released, but if you're interested I can try to dig out a copy on an
"as-is" basis. I suspect the view taken was that there was little value
in transferring old data into the new system, so these scripts were not
necessary.
Stephen
On 20/03/2014 10:28, Barratt, John wrote:
> Dear Webpa helpdesk,
>
> I am an Sys Admin working at Liverpool John Moores University. We are
> currently using webpa version 1.1.0.1, but would like to upgrade to
> latest stable version 2.0.0.11. Is there a recommended procedure to
> transform the data from v1 to v2. Your upgrade web pages
> http://www.webpa.ac.uk/?q=node/226 (dated 2008) describe using the
> “tables_updates.sql” file which doesn’t appear to exists in the v2 kit.
>
> Any help you can provide would be greatly appreciated.
>
> Regards
>
> John Barratt
>
> *Liverpool John Moores University* <http://www.ljmu.ac.uk/>**
>
>
>
> *John Barratt*M.Eng*
> Senior Systems Engineer (Unix / Linux) - *Information Technology Services*
> *JMU Tower, 24 Norton Street, Liverpool, L3 8PY
> t: +44 (0) 151 231 5605 e: [log in to unmask]
> <mailto:[log in to unmask]>_**
>
>
> ------------------------------------------------------------------------
> */Important Notice:///*///the information in this email and any
> attachments is for the sole use of the intended recipient(s). If you are
> not an intended recipient, or a person responsible for delivering it to
> an intended recipient, you should delete it from your system immediately
> without disclosing its contents elsewhere and advise the sender by
> returning the email or by telephoning a number contained in the body of
> the email. No responsibility is accepted for loss or damage arising from
> viruses or changes made to this message after it was sent. The views
> contained in this email are those of the author and not necessarily
> those of Liverpool John Moores University.///////////
|