Yes, it is possible to install Oracle RDBMS and MS SQL Server on the same server and even on the same hard disk. When you install these two products, you'll need to make sure that you install the software in their own subdirectories. I'd also keep the database disk files in separate locations as well. As for gotchas... Make sure that you have enough memory on your server. Database systems can require a lot of memory. You want to ensure that you are not using more physical memory than is available on your server to avoid paging (performance killers for any database). Also, if you only have one hard drive, then you may experience disk contention as both databases systems try to read, or write, data on the disk. Multiple hard drives may be warranted.
Eli Leiba adds:
Yes, it is possible and I did it myself.
If you have enough disk space and enough memory on the server, both database servers can be installed and "live" side-by-side. Both have separate services that run on the machine and also have separate folders in disk:
c:oracleora90.... for 9i c:program filesmicrosoft sql server.... for SQL Server 2000
For More Information
- What do you think about this answer? E-mail the editors at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle database installation, upgrades and patches
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.