REM Ebase Upgrade script based on upgrade instructions from Ebase 4.XX to 5.0.1
REM Created By Segi Hovav 12/15/2015

@echo off
SET SOURCEPATH=C:\Users\Segi\Desktop\EbaseXi_5.0.1_20151118_upgrade\Ebase_V501_upgrade\
SET DESTINATIONPATH=c:\ebaseXi5\

SET WEBAPP=%DESTINATIONPATH%\UfsServer\tomcat\webapps\ufs

ECHO *** Section 1: Starting Ebase Server upgrade ***
ECHO.
ECHO Step 1 Copying InternalWorkspace to %DESTINATIONPATH%
XCOPY /E %SOURCEPATH%\Server\InternalWorkspace %DESTINATIONPATH%

ECHO Step 2 Copying the contents of Samples to %DESTINATIONPATH%\UfsServer\samples
XCOPY /E /Y %SOURCEPATH%\Server\samples\*.* %DESTINATIONPATH%\UfsServer\samples

ECHO Step 3 Copying index.htm and search.jsp to %WEBAPP%
XCOPY /Y %SOURCEPATH%\Server\web_content\index.jsp %WEBAPP%
XCOPY /Y %SOURCEPATH%\Server\web_content\search.jsp %WEBAPP%

ECHO Step 4 Deleting doc directory from %WEBAPP%
IF EXIST %WEBAPP%\doc DEL /S /Q  %WEBAPP%\doc

ECHO Step 5 Copying doc directory to %WEBAPP%
XCOPY /Y %SOURCEPATH%\Server\web_content\doc %WEBAPP%

ECHO Step 6 Copying the ebaseConf directory to %WEBAPP%
XCOPY /Y %SOURCEPATH%\Server\web_content\ebaseConf %WEBAPP%

ECHO Step 7 Copying the ebaseInternal directory to %WEBAPP%
XCOPY /Y %SOURCEPATH%\Server\web_content\ebaseInternal %WEBAPP%

ECHO Step 8 Deleting getting_started from %WEBAPP%
IF EXIST %WEBAPP%\getting_started DEL /S /Q  %WEBAPP%\getting_started

ECHO Step 9 Copying the getting_started directory to %WEBAPP%
XCOPY /Y %SOURCEPATH%\Server\web_content\getting_started %WEBAPP%

ECHO Step 10 Copying the contents of javascript directory to %WEBAPP%\javascript
XCOPY /E /Y %SOURCEPATH%\Server\web_content\javascript\*.* %WEBAPP%\javascript

ECHO Step 11 Copying the contents of samples\logon to %WEBAPP%\samples\logon
XCOPY /E /Y %SOURCEPATH%\Server\web_content\samples\logon %WEBAPP%\samples\logon

ECHO Step 12 Copying web.xml to %WEBAPP%\WEB-INF
XCOPY /E /Y %SOURCEPATH%\Server\web_content\WEB-INF\web.xml %WEBAPP%\WEB-INF\web.xml

ECHO Step 13 Deleting docidx directory from %WEBAPP%\WEB-INF\docidx
IF EXIST %WEBAPP%\WEB-INF\docidx DEL /S /Q  %WEBAPP%\WEB-INF\docidx

ECHO Step 14 Copying docidx directory to %WEBAPP%\WEB-INF
XCOPY /E /Y %SOURCEPATH%\Server\web_content\WEB-INF\docidx %WEBAPP%\WEB-INF\

ECHO Step 15 Copying ebaseCache.xml to %WEBAPP%\WEB-INF\classes
XCOPY /E /Y %SOURCEPATH%\Server\web_content\WEB-INF\classes\ebaseCache.xml %WEBAPP%\WEB-INF\classes\ebaseCache.xml

ECHO Step 16 Please check %WEBAPP%\WEB-INF\lib for obsolete jar files according to Appendix 2 of the upgrade instructions and then press any key twice to continue
pause
pause

ECHO Step 16 Copying JAR files to %WEBAPP%\WEB-INF\lib
XCOPY /E /Y %SOURCEPATH%\Server\web_content\WEB-INF\lib\*.* %WEBAPP%\WEB-INF\lib

ECHO Step 17 Adding upgrade=true to UFSSetup.properties
ECHO upgrade=true >> %WEBAPP%\WEB-INF\classes\UFSSetup.properties

ECHO Step 18 Start the server now to begin the upgrade of the server. After the server has started and you see the message *** UPGRADE TO EBASE VERSION 5.0.0 COMPLETED ***, stop it and press any key to continue
pause

ECHO Step 19 Removing upgrade=true from UFSSetup.properties
type %WEBAPP%\WEB-INF\classes\UFSSetup.properties | find /v upgrade=true > %WEBAPP%\WEB-INF\classes\UFSSetup.properties

ECHO Step 20 Copying DeploymentMaintenance.eb to SOURCEPATH%\Server\Workspace\ebaseSamples\Scheduled_Tasks
XCOPY /E /Y %SOURCEPATH%\Server\Workspace\ebaseSamples\Scheduled_Tasks\DeploymentMaintenance.eb %DESTINATIONPATH%\Workspace\Shared\Scheduled_Tasks

ECHO Step 21 Start the server now

ECHO *** Section 2: Starting Ebase Client upgrade ***
ECHO.
ECHO Step 1 Copying derby.properties to %DESTINATIONPATH%\UfsClient
XCOPY /E /Y %SOURCEPATH%\Client\derby.properties %DESTINATIONPATH%\UfsClient

ECHO Step 2 Deleting %DESTINATIONPATH%\UfsClient\images
IF EXIST %DESTINATIONPATH%\UfsClient\images DEL /S /Q  %DESTINATIONPATH%\UfsClient\images

ECHO Step 3 Copying images directory to %DESTINATIONPATH%\UfsClient\images
XCOPY /E /Y %SOURCEPATH%\Client\images %DESTINATIONPATH%\UfsClient\

ECHO Step 4 Copying preferences directory to %DESTINATIONPATH%\UfsClient\
XCOPY /E /Y %SOURCEPATH%\Client\preferences %DESTINATIONPATH%\UfsClient\

ECHO Step 5 IntegratedServer directory to %DESTINATIONPATH%\UfsClient\
XCOPY /E /Y %SOURCEPATH%\Client\IntegratedServer %DESTINATIONPATH%\UfsClient\

ECHO Step 6 Deleting %DESTINATIONPATH%\UfsClient\lib
IF EXIST %DESTINATIONPATH%\UfsClient\lib DEL /S /Q  %DESTINATIONPATH%\UfsClient\lib

ECHO Step 7 Copying the lib directory to %DESTINATIONPATH%\UfsClient\
XCOPY /E /Y %SOURCEPATH%\Client\lib %DESTINATIONPATH%\UfsClient\

ECHO Step 8 Copying installation_preferences.xml to %DESTINATIONPATH%\UfsClient\preferences
XCOPY /E /Y %SOURCEPATH%\UFSServer\preferences/installation_preferences.xml %DESTINATIONPATH%\UfsClient\preferences

ECHO Step 9 Copying systemTexts directory, userFunctions.xml and log4j.properties to %DESTINATIONPATH%\UfsClient\preferences
XCOPY /E /Y %SOURCEPATH%\Client\properties\systemTexts %DESTINATIONPATH%\UfsClient\preferences
XCOPY /E /Y %SOURCEPATH%\Client\properties\userFunctions.xml %DESTINATIONPATH%\UfsClient\preferences
XCOPY /E /Y %SOURCEPATH%\Client\properties\log4j.properties %DESTINATIONPATH%\UfsClient\preferences

ECHO Step 10 Start the designer and accept the default for the workspace location. Wait for the Updating Data Dictionary.. message on the status bar at the bottom of the designer to disappear; this make take some minutes for a large workspace.
pause

ECHO Step 11 Then select File > Preferences from the menu, select the Test Server tab, select the Use External Server radio button and change the three properties under this option to match your server. These are supplied with default values of Host name: localhost, Port: 3030, Web application name: ebasetest. These should be changed to match your server system, typically Host name: localhost, Port: 3030, Web application name: ufs. Then click OK.

ECHO *** Section 3: Updating FPL definitions ***
ECHO.
ECHO Step 1 Copying Fpl.jj to %DESTINATIONPATH%\LanguageBuilder\Fpl
XCOPY /E /Y %SOURCEPATH%\LanguageBuilder\Fpl\FPL.jj %DESTINATIONPATH%\LanguageBuilder\Fpl

ECHO Step 2 Copying LanguageBuilder\*.* to %DESTINATIONPATH%\LanguageBuilder\
XCOPY /Y %SOURCEPATH%\LanguageBuilder\*.* %DESTINATIONPATH%\LanguageBuilder\

ECHO Step 3 Deleting ecj-3.3.jar from %DESTINATIONPATH%\LanguageBuilder\
IF EXIST %DESTINATIONPATH%\LanguageBuilder\ecj-3.3.jar DEL %DESTINATIONPATH%\LanguageBuilder\ecj-3.3.jar

ECHO *** Section 4: Upgrading the Ebase dating FPL definitions ***
ECHO.
ECHO Step 1 Copying databaseSchemas to %DESTINATIONPATH%\UfsServer
XCOPY /E /Y %SOURCEPATH%\databaseSchemas %DESTINATIONPATH%\UfsServer

ECHO *** Section 5: Upgrading the external Ebase programs ***
ECHO.
ECHO Step 1 Copying ebaseTrigger.jar to %DESTINATIONPATH%\External\EbaseTrigger\lib
XCOPY /E /Y %SOURCEPATH%\External\EbaseTrigger\lib\ebaseTrigger.jar %DESTINATIONPATH%\External\EbaseTrigger\lib

ECHO Step 2 Copying processBatchFiles.jar %DESTINATIONPATH%\External\processXML\lib
XCOPY /E /Y %SOURCEPATH%\External\processXML\lib\processBatchFiles.jar %DESTINATIONPATH%\External\processXML\lib

ECHO *** Section 6: Upgrading Workflow Administrator ***
ECHO.
ECHO If you have modified the WORKFLOW_ADMINISTRATOR, please read Appendix 5 of the upgrade instructions
ECHO.
ECHO If not, follow these steps:
echo In the designer, right click on the SAMPLES project in the tree panel on the left-hand side and select Import > Ebase Archive
echo Click Browse.. then navigate to the WorkflowAdmin folder at the root of the upgrade package, select file workFlowAdministratorChanges.zip, click Open, then click Next
echo Click Automatically overwrite existing entities checkbox then click Import

ECHO *** Section 7: Test the installation by running the Server Administration Application ***
ECHO.
ECHO From the designer, check that the Manage Server icon (in the top right-hand corner) is green, indicating that the server is running OK. Click on this icon
ECHO and select Start Server Admin App to launch the application in a browser. You should be able to sign on to the application using the ebaseuser user. If this
ECHO doesn’t work, then new users can be added by editing file <webapp>/ebaseConf/sysAdmin.properties on the server (any designer userids from V4 can be added).
ECHO Once the application is started, click some of the options within the application to test that the system is working correctly.