Upgrade Database Only

[kenlyle]

It seems that sometimes it would be easier to just install a new version than upgrade.

For example, I am at 4.5.1, and having trouble upgrading, but have a nice, shiny, new 4.5.1b install, but I know from the Release Notes that there are database diffs. I see the Scripts that do the diffs in the patch package.

I can't find on the forum or Wiki, how to accomplish a database only upgrade, so that I can just point my new install at the upgraded (copy) of the database, and be down the road....

I wold love to see some simple SQL update files. I imagine that I could use the .php ones, but would have to set the database parameters somewhere, and don't know where.

Thanks in advance to anyone who can fill me in.

Ken

[Angel]

I haven't tried this myself, so your mileage might vary, but one idea would be to do something like this:

1. Empty the tables in the SugarCRM database corresponding with the new, fresh install.

2. Use SQLYog or other admin util with similar functionality to move the data from the old tables in the old database to the tables in the new database, a la DTS in MS-SQL.

I would think that should work without problems, but like I said, your mileage might vary.

[kenlyle]

Brilliant! I am going to gimp along with my current database, with the two little error messages, but now I at least know what to do when I need to. THANKS!

Hijacking my own thread ....

Angel, or anyone... I have done a little looking at MySQL tools, but haven't purchased one, well, except for the Access2MySQL from GalaxySoft, which is good. Is it your opinion that SQLYog Enterprise is a great product for the price? It seems so, with the conversion features...The MySQL Migration Tookkit doesn't seem as friendly...I don't think I've ever gotten it to work... Thanks again...

[Angel]

I haven't played with the Enterprise version of SQLYog, but I always use the free "Community" edition (which includes the referenced functionality) and haven't had any problems with it for other purposes.