Upgrading Idempiere from 7.1 to 9

[Syed Muhammad Taha Najam]

What are the steps that I should follow in order to perfectly migrate my idempiere production to new version? Here's what I did so far:
I installed idempiere production version 9 on my local machine.
I ran RUN_DBExport.sh file on my live production server which generated ExtDat.dmp file and a packaged jar file. 
I'll move these files to my local machine and try to restore the db by running RUN_DBRestore .sh. 
Will that work?
We've also did many development in our current live idempiere. How we are going to move those changes along with it? 
Any suggestion would be highly appreciated. 
Thanks in advance.

[Carlos Antonio Ruiz Gomez]

Hi Syed,

> What are the steps that I should follow in order to perfectly migrate
> my idempiere production to new version? Here's what I did so far:
> I installed idempiere production version 9 on my local machine.
> I ran RUN_DBExport.sh file on my live production server which
> generated ExtDat.dmp file and a packaged jar file.
> I'll move these files to my local machine and try to restore the db by
> running RUN_DBRestore .sh.
> Will that work?

Yes, and then you cycle running RUN_SyncDB.sh and fixing the errors that
appear.

RUN_SyncDB.sh
fix problems
RUN_SyncDB.sh
fix problems ...
until no errors are shown

> We've also did many development in our current live idempiere. How we
> are going to move those changes along with it?

Changes in core?  Better if you check if they are worthy for everyone
and contribute them back to iDempiere.

If the changes are not for everyone, then I suppose they were made in
plugins, so you need to port your plugins to version 9.


Regards,

Carlos Ruiz

[Syed Muhammad Taha Najam]

Thank you so much for your detailed answer, sir. I restored the database and it went well, but when I tried to log in. It showed a database version error and immediately ran migrations. How can I do that? How can I update the database version to the newest?
I'm attaching a screenshot of the message when I tried taking up the backup. Is it all okay? 

[Syed Muhammad Taha Najam]

Hello Carlos Ruiz, I hope you are doign great. Thanks for personally assisting me and writing a response to my query. Can you a bit more. I'm stuck here in migrating the DB. I'm getting an invalid command errors so many times while restoring the database.

[Syed Muhammad Taha Najam]

I restored the database but didn't fix the errors. Turned on eclipse. Clicked on install app. It's stuck on port 8080 and keeps on revolving. What could be the issue?

I'm attaching a screenshot.

[Syed Muhammad Taha Najam]

I was able to pull that off. DB is imported successfully in production version 9. Thanks for your guidance, Sir Carlos.
I want to implement the same in- evelopment version but development version 9 is not available. I was able to only download development version 10. Does anyone share the link maybe?

[Carlos Antonio Ruiz Gomez]

That's good news Syed!

The version 9 is what we call stable, it is maintained for one year, and some of us use it for production, it's updated almost in a weekly basis with non-disruptive things and bug fixes.

The version 10 is what we call development, it's not so safe for production (although I think some people still use it for production), because we add there things that tend to be more disruptive and some time requires a bit of time for stabilization.

Regards,

Carlos Ruiz

El 29/6/22 a las 19:52, Syed Muhammad Taha Najam escribió:

[Syed Muhammad Taha Najam]

Hello Carlos, Sorry for bothering you again. I'm now trying to restore the database in development version in windows but unable to do so. Can you guide me a bit how can I do that? There are many dbrestore.bat files in development directory. Which should I use? Can you tell me specific steps just like you told me in restoring in production version? I shall be very thankful to you. When I manually try to run the bat file it says "Can't open ./myEnvironment.sh" I tried running it from server-feature/utils.unix. What steps should I follow.

Regards,

Taha Najam,

[Carlos Antonio Ruiz Gomez]

Hi Syed, I don't use windows for development, so I cannot be very helpful there.

However I prepared a full tutorial about how to install development environment in windows:

Please check the videos at youtube here:

https://www.youtube.com/watch?v=hIPBdjTKavQ&list=PL-yzcOCOKCBN6k6z2aHetk91yYAxQZmZ-

Regards,

Carlos Ruiz

El 4/7/22 a las 10:56, Syed Muhammad Taha Najam escribió: