[Vtigercrm-developers] Upgrade bug - 6.5.0 to 7.5.0

[Steve Kenow]

I am using a fresh 7.5.0 install and pointing it at the database for 6.5.0
and going to /index.php?module=Migration&view=Index&mode=step1 for the
migration.

Using MySQL Workbench, I am able to compare the resulting db schema with
that of a fresh install and get the statements needed to make them the same
- for the most part. I haven't run the scripts yet. I'm thinking I may want
to alter the initial DB to uncover any data integrity issues before the big
migration.

I am just kind of surprised there is this much of a gap with as large a
user base as vTiger has.

*Steve Kenow*
Retail Data Systems of Minnesota
End-User Services & Support Manager
Direct: (952) 392-2686
Office: (952) 934-4002
skenow at rdspos.com



Support Questions/Issues? Email rdshelp at rdspos.com (non-emergencies) or
call (952) 934-4002 24/7


On Sat, May 20, 2023 at 8:24 AM Angelo Paglialonga <
info at angelopaglialonga.com> wrote:

> Same here with additional checks to disable foreign key checks , alreday
> inserted records errors and disable alter tables when altready changed, i
> think everyone have them.
>
> And instead of migration i suggest use those script for db update and copy
> files over a full 7.5 brand new install.
> All the best
> Angelo
>
> _______________
>
> Angelo Paglialonga
> Consulente per soluzioni CRM ad alto ROI.
>
> Telefono: 3386077866
> Web: https://www.angelopaglialonga.com
>
>
> Il giorno 20 mag 2023, alle ore 15:08, Alan Lord <alanslists at gmail.com>
> ha scritto:
>
> On 19/05/2023 18:51, Steve Kenow wrote:
>
> So, are you using custom scripts for migrating?
>
>
> Sort of, yes. They are basically the same as each of the version-version
> scripts in vtiger but patched where I deem fit, modified to work from the
> cli and they have die on error on the db set for most of the time.
>
> 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/20230520/7e05531c/attachment.html>