Applying additional Migration Scripts - Revision history

CarlosRuiz: Update documentation with release-11 information

2023-12-28T13:29:57Z

Update documentation with release-11 information

Diego.ruiz: Categorize and tag

2022-09-01T14:16:08Z

Categorize and tag

Diego.ruiz at 09:57, 14 July 2022

2022-07-14T09:57:47Z

Diego.ruiz at 09:36, 5 May 2022

2022-05-05T09:36:02Z

Diego.ruiz at 09:27, 5 May 2022

2022-05-05T09:27:16Z

CarlosRuiz at 16:46, 4 November 2020

2020-11-04T16:46:49Z

CarlosRuiz: Where to find output to review if needed

2020-03-15T08:42:51Z

Where to find output to review if needed

CarlosRuiz: new way to apply changes on development

2019-12-30T23:15:50Z

new way to apply changes on development

CarlosRuiz: new way to apply changes on development

2019-12-30T23:11:41Z

new way to apply changes on development

New page

<font size=-2>
⇐
[[Installing_iDempiere|Table of Contents]] |
[[Configuring iDempiere within Eclipse]] |
Running iDempiere within Eclipse |
[[Running iDempiere within Eclipse]]
⇒
</font>

== Applying additional migration scripts ==

=== Automated way (just for linux) ===

In the console, go to the $IDEMPIERE_REPOSITORY folder and execute the following command:

bash RUN_SyncDBDev.sh

Verify there are no errors, in case of errors you must solve the error and then execute the command again.

=== Manual way ===

First get the list of all the migration scripts from here:

ls $IDEMPIERE_REPOSITORY/migration/*/postgresql

Now get the list of all the migration scripts already applied in the database from psql with this command:

select name from ad_migrationscript order by 1

Compare the list of migration scripts with the contents of your AD_MigrationScript table. Apply all the migration scripts pending to apply, in order of file name.

Please check carefully the output of each migration scripts, if you find errors, try to solve it, or ask for help on the [http://groups.google.com/group/idempiere support forums]

You must repeat the previous for each unapplied migration scripts, it's recommended also to take note of the last applied for future reference.

''This tutorial is brought to you by [[User:CarlosRuiz|Carlos Ruiz]] from [http://globalqss.com GlobalQSS]. Feel free to improve directly or suggest using the Discussion tab.

[[Category:User Manual|I]]
[[Category:Installation|E]]
[[Category:Installation Eclipse]]
[[Category:Swing Client]]
[[Category:Development‏‎]]
[[Category:Developer documentation‏‎]]


<font size=-2>
⇐
[[Installing_iDempiere|Table of Contents]] |
[[Configuring iDempiere within Eclipse]] |
Running iDempiere within Eclipse |
[[Running iDempiere within Eclipse]]
⇒
</font>

@@ Line 33: / Line 33: @@
 Please check carefully the output of each migration scripts, if you find errors, try to solve it, or ask for help on the [http://groups.google.com/group/idempiere support forums]
-You must repeat the previous for each unapplied migration scripts, it's recommended also to take note of the last applied for future reference.
+You must repeat the previous for each unapplied migration script, it's recommended also to take note of the last applied for future reference.
-''This tutorial is brought to you by [[User:CarlosRuiz|Carlos Ruiz]] from [https://www.bx-service.com/ BX Service GmbH].  Feel free to improve directly or suggest using the Discussion tab.
+''This How-To is brought to you by [[User:CarlosRuiz|Carlos Ruiz]] from [https://www.bx-service.com/ BX Service GmbH].  Feel free to improve directly or suggest using the Discussion tab.
@@ Line 45: / Line 45: @@
 [[Category:Development‏‎]]
 [[Category:Developer documentation‏‎]]
 [[Category:Updated2022]]

@@ Line 39: / Line 39: @@
-[[Category:How To]]
+[[Category:HowTo-Technical]]
 [[Category:User Manual|I]]
 [[Category:Installation|E]]

← Older revision		Revision as of 16:46, 4 November 2020
Line 36:		Line 36:


−	''This tutorial is brought to you by [[User:CarlosRuiz\|Carlos Ruiz]] from [~~http~~://~~globalqss~~.com ~~GlobalQSS~~]. Feel free to improve directly or suggest using the Discussion tab.	+	''This tutorial is brought to you by [[User:CarlosRuiz\|Carlos Ruiz]] from [https://www.bx-service.com/ BX Service GmbH]. Feel free to improve directly or suggest using the Discussion tab.

← Older revision		Revision as of 08:42, 15 March 2020
Line 16:		Line 16:

	Verify there are no errors, in case of errors you must solve the error and then execute the command again.		Verify there are no errors, in case of errors you must solve the error and then execute the command again.
		+
		+	NOTE: If you want to review the output of specific migration scripts, the script leaves the output of every script executed in a folder /tmp/SyncDB_out_[##] - where number is a "random" numeric value (process ID of the running script)

	== Manual way ==		== Manual way ==

@@ Line 9: / Line 9: @@
 </font>
-== Automated way (just for linux) ==
+== Automated way ==
 In the console, go to the $IDEMPIERE_REPOSITORY folder and execute the following command:
@@ Line 15: / Line 15: @@
   bash RUN_SyncDBDev.sh
-Verify there are no errors, in case of errors you must solve the error and then execute the command again.
+Verify there are no errors.
 NOTE: If you want to review the output of specific migration scripts, the script leaves the output of every script executed in a folder /tmp/SyncDB_out_[##] - where number is a "random" numeric value (process ID of the running script)
-== Manual way ==
+'''NOTE FOR WINDOWS:''' There is not a batch file to run in windows, but if you install git, this installs a "git bash" command that can execute <code>RUN_SyncDBDev.sh</code> without problem
 First get the list of all the migration scripts from here:

@@ Line 4: / Line 4: @@
 [[Installing_iDempiere|Table of Contents]] |
 [[Configuring iDempiere within Eclipse]] |
-Running iDempiere within Eclipse |
+Applying additional Migration Scripts |
 [[Running iDempiere within Eclipse]]
 &rArr;
 </font>
 == Automated way (just for linux) ==
 In the console, go to the $IDEMPIERE_REPOSITORY folder and execute the following command:
@@ Line 20: / Line 17: @@
 Verify there are no errors, in case of errors you must solve the error and then execute the command again.
-=== Manual way ===
+== Manual way ==
 First get the list of all the migration scripts from here:
@@ Line 44: / Line 41: @@
 [[Category:Installation|E]]
 [[Category:Installation Eclipse]]
 [[Category:Development‏‎]]
 [[Category:Developer documentation‏‎]]
@@ Line 53: / Line 49: @@
 [[Installing_iDempiere|Table of Contents]] |
 [[Configuring iDempiere within Eclipse]] |
-Running iDempiere within Eclipse |
+Applying additional Migration Scripts |
 [[Running iDempiere within Eclipse]]
 &rArr;
 </font>