<div dir="ltr"><div>So, are you using custom scripts for migrating? <br></div><div><br></div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><i><b>Steve Kenow</b></i><br></div><div>Retail Data Systems of Minnesota<br></div><span>End-User Services & Support Manager</span><br><div>Direct: (952) 392-2686</div><div>Office: (952) 934-4002</div><div><a href="mailto:skenow@rdspos.com" target="_blank">skenow@rdspos.com</a></div><div><br><img src="http://rdspos.com/Portals/0/Web-RDS-Logo.jpg" width="96" height="39"><br><br>Support Questions/Issues? Email <a href="mailto:rdshelp@rdspos.com" target="_blank">rdshelp@rdspos.com</a> (non-emergencies) or call (952) 934-4002 24/7</div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, May 19, 2023 at 9:28 AM Alan Lord <<a href="mailto:alanslists@gmail.com">alanslists@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Search <a href="http://code.vtiger.com" rel="noreferrer" target="_blank">code.vtiger.com</a> issues for "migration". I've reported loads of <br>
issues. I am amazed it works at all sometimes.<br>
<br>
<a href="https://code.vtiger.com/vtiger/vtigercrm/-/issues/?search=migration&sort=updated_desc&state=all&first_page_size=20" rel="noreferrer" target="_blank">https://code.vtiger.com/vtiger/vtigercrm/-/issues/?search=migration&sort=updated_desc&state=all&first_page_size=20</a><br>
<br>
HTH<br>
<br>
Al<br>
<br>
<br>
On 19/05/2023 14:44, Steve Kenow wrote:<br>
> Tried it with a fresh 6.5.0 install - same thing.<br>
> image.png<br>
> <br>
> /*Steve Kenow*/<br>
> Retail Data Systems of Minnesota<br>
> End-User Services & Support Manager<br>
> Direct: (952) 392-2686<br>
> Office: (952) 934-4002<br>
> <a href="mailto:skenow@rdspos.com" target="_blank">skenow@rdspos.com</a> <mailto:<a href="mailto:skenow@rdspos.com" target="_blank">skenow@rdspos.com</a>><br>
> <br>
> <br>
> <br>
> Support Questions/Issues? Email <a href="mailto:rdshelp@rdspos.com" target="_blank">rdshelp@rdspos.com</a> <br>
> <mailto:<a href="mailto:rdshelp@rdspos.com" target="_blank">rdshelp@rdspos.com</a>> (non-emergencies) or call (952) 934-4002 24/7<br>
> <br>
> <br>
> On Thu, May 18, 2023 at 10:06 PM Steve Kenow <<a href="mailto:skenow@rdspos.com" target="_blank">skenow@rdspos.com</a> <br>
> <mailto:<a href="mailto:skenow@rdspos.com" target="_blank">skenow@rdspos.com</a>>> wrote:<br>
> <br>
> It could actually happen when starting at anything less than 7.3.0,<br>
> from what I can tell.<br>
> <br>
> I've been cleaning up and getting ready for upgrading a 650 instance<br>
> and looking at what should be there and wasn't. One of the things I<br>
> found missing was the ability for each user to set a default landing<br>
> page, which was introduced in 7.3.0. My process is to have a clean<br>
> install of the target version, copy in the custom module files,<br>
> disable all the custom modules, and then point the new instance at<br>
> the existing database. Then, open up a browser and navigate to<br>
> /index.php?module=Migration&view=Index&mode=step1.<br>
> <br>
> Everything appeared to go as desired, with the above notable<br>
> exception. Repeating these steps, I notice that the results page<br>
> after the migration is complete doesn't have any database upgrade<br>
> results for 7.2.0 to 7.3.0. Verified files, permissions, etc.<br>
> Looking at /modules/MIgration/schema/, I notice 73_to_740.php and<br>
> 730_to_740.php, the former just including the latter. This is where<br>
> that feature should be added, among other things.<br>
> <br>
> /modules/MIgration/models/Module.php includes both in the allowed<br>
> migration versions, which is what caused my problems. The migration<br>
> gets to 7.2.0 and the next version isn't 7.3, but 7.3.0. So, this<br>
> step gets skipped. Removing array('73' => '7.3') from the list and<br>
> starting the migration over does successfully apply all the changes<br>
> in that step.<br>
> <br>
> This led me to look for any other differences in the database<br>
> schemas of a fresh 7.5.0 install and an instance upgraded to 7.5.0,<br>
> other than custom fields and modules. There are a lot more than I<br>
> expected. Some appear to be just cosmetic - like indexes having<br>
> different names. In other places, foreign keys are added and/or<br>
> removed, data types are changed, there are even some missing fields.<br>
> <br>
> Performance and data integrity are critical to us - how can we<br>
> improve them both? Are there better options for migrating to newer<br>
> versions? I'm willing to test more and provide results and feedback,<br>
> now that I've got a test environment that can load a copy of our<br>
> database and do a migration in under an hour.<br>
> <br>
> /*Steve Kenow*/<br>
> Retail Data Systems of Minnesota<br>
> End-User Services & Support Manager<br>
> Direct: (952) 392-2686<br>
> Office: (952) 934-4002<br>
> <a href="mailto:skenow@rdspos.com" target="_blank">skenow@rdspos.com</a> <mailto:<a href="mailto:skenow@rdspos.com" target="_blank">skenow@rdspos.com</a>><br>
> <br>
> <br>
> <br>
> Support Questions/Issues? Email <a href="mailto:rdshelp@rdspos.com" target="_blank">rdshelp@rdspos.com</a><br>
> <mailto:<a href="mailto:rdshelp@rdspos.com" target="_blank">rdshelp@rdspos.com</a>> (non-emergencies) or call (952) 934-4002<br>
> 24/7<br>
> <br>
> <br>
> _______________________________________________<br>
> <a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div>