Hi all,First, thanks for providing this great software.  We have been using 1.6ST for 4 years now.I would like to upgrade to 1.9.12 since there are many features in 1.9 that were not available in 1.6ST.  The issue is I have installed a lot of modifications to 1.6ST over the years, for things like the FAQ, additional fields on the ticket, etc.What I would like to do is migrate everything (primarily the tickets themselves, everything else I can re-create manually in 1.9) from 1.6ST to a new instance of 1.9.  I do not want to lose our existing system.Is there anyway to do this?  Any scripts available? I realize any custom fields on the 1.6 db would be lost, and I am OK with that, but I want to move the basic ticket information over to the 1.9 if possible.Any pointers or suggestions would be great!Thank you,Mark

There are a number of how to upgrade from X to Y articles at tmib.net.They pretty much all cover the basics, backing up the DB, filesystem, installing the new code, running the upgrader.http://www.tmib.net/how-to-upgrade-osticket-from-1.6st-to-1.7rc4http://www.tmib.net/how-upgrade-osticket-17st-172http://www.tmib.net/upgrading-osticket-1812-current-19rc

Thanks.The issue is my 1.6ST database has customization in it.I assume the upgrade wizard will not know how to handle extra fields and such and therefore wont work.Are there scripts available that perhaps I can modify to extract the data correctly, and then insert into a new DB instance?Or will the wizard simply ignore any extra fields?  If so, can I do a "migration" from one DB to another as I don't want t break our existing osTicket install while trying to upgrade things.

I had custom fields in my my 1.6 and didnt have a problem upgrading.I would give it a try first.But the scripts to make the DB are in the /setup/inc/streams/core/install-mysql.sqlThe scripts to upgrade the DB are in /include/upgrader/streams

Thanks.  Did you upgrade to 1.9?  or something in between?I guess there are no migration tools available I am assuming?Only option is to upgrade 1.6ST and hope for the best....I will take a look at the scripts.  Thanks for the help.

I went from 1.6ST to 1.7ST (and then do a bunch of 1.7 versions) to 1.8 (and then a bunch of 1.8 versions) and then to 1.9 (and then a bunch of 1.9 versions) and lastly to 1.10rc1 and 1.10rc2.  I've had to restore once.migration tools?You use the tools with MySQLto export/import.The source upgrades the DB for you.What more would you need?

You are correct.  Guess I was making things more complicated then I needed to.I can just copy the entire osticket DB and folder structure, point the new copy to the new DB, and have a complete working copy, then perform the upgrade on that copy.I actually did this yesterday, and the upgrade from 1.6ST to 1.9.12 seems to have worked.  I am still testing but so far it seems OK.  I have not checked to see what happened with the custom fields I added, but perhaps they are still there, just dormant for now.I got a bunch of DB errors being emailed to me during the upgrade process, but assume that is normal as once the upgrade completed, the messages stopped and it seems to be working.

Write a Reply...