How To: Install two instances of ArcSDE for two different RDBMSs on the same Windows server
It is possible to successfully run an instance of ArcSDE for one relational database management system (RDBMS), such as Oracle, and an instance of ArcSDE for a different RDBMS, such as SQL Server, on the same Windows server.
Follow these steps to run two instances of ArcSDE for two different RDBMSs on the same Windows server.
Note: Both instances of ArcSDE must be the same version.
- Install ArcSDE for an RDBMS and complete the postinstallation setup.
- After the first installation delete the SDEHOME environment variable and remove %SDEHOME%\bin and %SDEHOME%\lib from the PATH environment variable.
- Make sure the ArcSDE service is shut down.
- Proceed with the installation of the second ArcSDE instance for the second RDBMS.
Do not proceed with the postinstallation setup.
- After the second ArcSDE installation, delete the SDEHOME environment variable and remove %SDEHOME%\bin and %SDEHOME%\lib from the PATH environment variable.
- Complete the postinstallation setup for the second instance from the command line and the RDBMS interface. Follow the installation instructions found in the "ArcSDE Administration Guide", which is included with the ArcSDE software.
When working with two instances of ArcSDE from the command line, it is best to have two environments set up. You can run a batch file to set up the individual environments.
When using the ArcSDE command line, the two ArcSDE environments need to be differentiated. When using ArcGIS, however, differentiation is not necessary because you enter all the information pertaining to what ArcSDE instance you are using.