{"id":13237,"date":"2018-01-08T16:03:08","date_gmt":"2018-01-08T23:03:08","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?p=13237"},"modified":"2020-08-26T16:28:20","modified_gmt":"2020-08-26T23:28:20","slug":"how-to-migrate-the-existing-transact-database-to-another-server","status":"publish","type":"post","link":"https:\/\/ephesoft.com\/docs\/how-to-migrate-the-existing-transact-database-to-another-server\/","title":{"rendered":"How to Migrate the Existing Transact Database to Another Server"},"content":{"rendered":"
Here are the steps you will need to take to successfully migrate your current MYSQL, MSSQL or Oracle database to a new server for Transact Version 4.x. All current data archived in the existing databases will be moved.<\/p>\n
<\/p>\n
1. Stop the Transact Service<\/p>\n
2. Make a backup of your entire Ephesoft folder directory and your current set of Ephesoft databases<\/p>\n
3. Export the whole databases from the DBserver: ephesoft, report, report_archive with a tool by choice (maybe ask the db-admin to do this)<\/p>\n
4. Import the exported databases into the new DBserver\u00a0with a tool by choice (maybe ask the db-admin to do this)<\/p>\n
5. Check the database user and his rights as dbo – should be identical after Export\/Import<\/p>\n
6.\u00a0Modify the\u00a0server.xml<\/em>\u00a0file found in \\Ephesoft\\JavaAppServer\\conf to use the updated connection details.\u00a0Look for the portion under the tag <GlobalNamingResources> and edit the Serveradress<\/strong>,\u00a0dataSource.user<\/strong>,\u00a0dataSource.password<\/strong> in each tag. You will need to confirm the Database names for the new Ephesoft, Report and Report_Archive databases match what you imported in step 4 above.<\/p>\n 7. Edit the dcma-db.properties<\/em> file found in\u00a0\\Ephesoft\\Application\\WEB-INF\\classes\\META-INF\\dcma-data-access and update the following entries if they were changed:<\/p>\n dataSource.password=<\/em> 8. Save all the changes<\/p>\n 9. Stop the old database server or set the old databases offline.<\/p>\n 10. Start the Transact service and make sure the new database is beeing used (take a look into the logfile: JavaAppServer\/logs\/*stout*)<\/p>\n <\/p>\n Issues:<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Here are the steps you will need to take to successfully migrate your current MYSQL, MSSQL or Oracle database to […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12358],"tags":[155,1239,361,1238,153,721,737,1237,1240,1167,1236],"yoast_head":"\n
\ndataSource.username=<\/em>
\ndataSource.databaseName=<\/em><\/p>\n\n
\n