Hi Baz, We're also in the process of upgrading a V3 site to V4. Started with a clean V4 install, and then did table schema comparisons between V3 and V4. Results are in the attached Excel file. Please note that it includes tables for our own custom rules and types. I wrote scripts to delete V4 data from the specified tables, and then migrate data table by table from V3 to V4. In the case where the schema did not change, it was a simple select from v3 and insert into V4 operation. In the case where V4 has added new columns, the script is populating the new columns (e.g. many tables have now added column 'datetimelastupdated'). Script details are in the file. Plase be aware that the site is not in production yet, we are still doing a lot of testing, but this should at least help get you started. Email me at [EMAIL PROTECTED] if the attachment doesn't come across.
On Oct 4, 7:40 am, BazD <[EMAIL PROTECTED]> wrote: > Hi > > Thanks for all your replies. > > What Im after is not a migration/upgrade from V3 to V4 within the same > server/database. Its copying the data from a v3 database to a v4 > database that resides on a new server, with fresh install of v4 > Farcry. My guess is that v4 uses different database tables, and > perhaps those tables that share the same name with v3 tables may have > different field names etc. I will try copying table at a time and see > what happens (!) > > Thanks > > B > > On Oct 4, 3:33 pm, "Liz Porter" <[EMAIL PROTECTED]> wrote: > > > I've prob to got that treat in store then. Joy :-) > > > -----Original Message----- > > From: Stephen Moretti [mailto:[EMAIL PROTECTED] > > Sent: 04 October 2007 14:25 > > To: [email protected] > > Subject: [farcry-dev] Re: Moving database from V3 to V4 > > > On 04/10/2007, Liz Porter <[EMAIL PROTECTED]> wrote: > > > Hi Baz, > > > I asked this recently although about moving from v2 to v3. I was going > > to create a new v3 site then over write the db with the v2 site one. > > As far as I recall - cant find the email atm - the advice was that once > > the lower version db is in place you just run the appropriate version > > updates via the farcry admin. Im fairly sure this is what was suggested. > > > Liz, > > > v3 to v4 isn't that simple I'm afraid. The major structural changes to > > the application have made the upgrade process a manual process. > > > Now that the wiki is back up you can find details here > > :http://docs.farcrycms.org:8080/confluence/display/FCDEV40/Upgrading+from > > +Earlier+Versions > > > Regards > > > Stephen > > > -- > > This message has been scanned for viruses and > > dangerous content by MailScanner <http://www.mailscanner.info/> , and is > > > believed to be clean. > > > -- > > This message has been scanned for viruses and > > dangerous content by MailScanner, and is > > believed to be clean. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
