[Vtigercrm-developers] 回复： Upgrade from 5.3

[Matt Bracewell]

Hi Sunny,

Thanks for that.  I've seen your posts recently and understand that you're
a fan of this approach.  If the schemas were the same between 5.3 & 6.2 I
might be tempted but there is a migration tool for each version for very
good reasons.
I fear that you'll continue to find issues with your upgrade for some time
yet with that method.

Kind regards,

Matt Bracewell

On 20 April 2015 at 10:07, sunny <1250572980 at qq.com> wrote:

>
> I think the my method is copy the tables directly from database,not take
> care of the data size.
>
>
> ------------------ 原始邮件 ------------------
> *发件人:* "Matt Bracewell";<mattbracewell at eclipse-tech.co.uk>;
> *发送时间:* 2015年4月20日(星期一) 下午4:58
> *收件人:* "vtigercrm-developers"<vtigercrm-developers at lists.vtigercrm.com>;
> *主题:* Re: [Vtigercrm-developers] Upgrade from 5.3
>
> Thanks for the helpful input Alan,
>
> I've got no PBX integration so I'm clear on that count.
>
> Is trawling this list archive the best way to get your improved script?
> Do you test after each step or is the absence of errors a sufficient
> indication of success?
>
> Kind regards,
>
> Matt Bracewell
>
> On 20 April 2015 at 09:51, Alan Lord <alanslists at gmail.com> wrote:
>
>> On 20/04/15 09:35, Matt Bracewell wrote:
>>
>>> Hi List,
>>>
>>> There has been much discussion here on upgrade scripts over the years
>>> and many examples of partial upgrades due to (silent) execution timeout
>>> etc.
>>>
>>> Is there any decent documentation on multi-version upgrades? Advice on
>>> best practice, ideas for testing, command line tools etc, etc etc.
>>>
>>
>> This is not straightforward.
>>
>> The web-based migration generally works for small databases and/or you
>> will get an error when something goes wrong :-)
>>
>> However for bigger databases the web-based scripts suck. They almost
>> always time out and die silently :-(
>>
>> When going from 5 to 6 you really need to "fix" the database beforehand
>> to prevent the migration script trying to create and population the new
>> crmentity label column - the migration code is incredibly slow and
>> inefficient. (I have posted in here before an alternative script that
>> reduced the time from >10 hours to a few minutes.)
>>
>> If you have PBXManager beware going from 6.1. to 6.2 - the script to
>> migrate the PBXManager table doesn't really do anything as far as I can
>> tell and again takes eons to do it... I have also commented on this in this
>> list before.
>>
>> Documentation? Not that I have found.
>>
>> Best practice? One step at a time, keep your fingers and toes crossed,
>> keep notes on what you do.
>>
>> HTH
>>
>> Al
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150420/4eb03a13/attachment.html>