Bartek Czupa
Active Member
JDE 9.1 installed from VM templates, running on OVM 3.2
Enterprise Server running on Oracle Linux
Database Server running Oracle Database on Oracle Linux
I want to migrate both servers to a single Windows 2008 R2 Server running MS SQL Server.
On new server I already installed EnterpriseOne code, setup SQL server and copied all tables from Oracle Database to MS SQL server and can access data from Deployment with new datasources I created.
Now it is time to switch 'System - 910' datasource from Oracle to MSSQL. What would be the best approach:
1. Add a new server with Add-On Server Plan (Doc ID 1071557.1) to register new configuration.
2. From SQL side modify datasource definition in F98611 in both sources for JDEPLAN and DEP910 and point 'System - 910' datasource to a new SQL server where all tables are already copied, update JDE.ini and start new enterprise server to work with new database.
Since the old enterprise server will be decommission I can keep the server name and avoid registration of a new enterprise server.
A bit tricky migration and I'm doing it for the fist time so I'm confused a bit. EnterpriseOne server running on UNIX is not supported with MS SQL server, so migrating from Oracle database to MSSQL requires an enterprise server migration as well.
Welcome any advice or hints to do it.
Enterprise Server running on Oracle Linux
Database Server running Oracle Database on Oracle Linux
I want to migrate both servers to a single Windows 2008 R2 Server running MS SQL Server.
On new server I already installed EnterpriseOne code, setup SQL server and copied all tables from Oracle Database to MS SQL server and can access data from Deployment with new datasources I created.
Now it is time to switch 'System - 910' datasource from Oracle to MSSQL. What would be the best approach:
1. Add a new server with Add-On Server Plan (Doc ID 1071557.1) to register new configuration.
2. From SQL side modify datasource definition in F98611 in both sources for JDEPLAN and DEP910 and point 'System - 910' datasource to a new SQL server where all tables are already copied, update JDE.ini and start new enterprise server to work with new database.
Since the old enterprise server will be decommission I can keep the server name and avoid registration of a new enterprise server.
A bit tricky migration and I'm doing it for the fist time so I'm confused a bit. EnterpriseOne server running on UNIX is not supported with MS SQL server, so migrating from Oracle database to MSSQL requires an enterprise server migration as well.
Welcome any advice or hints to do it.