Re: Installing MS-SQL and Oracle into a same server

achan006_at_gmail.com wrote:

> On Dec 4, 3:27 am, DA Morgan <damor..._at_psoug.org> wrote:
> > achan..._at_gmail.com wrote:
> > > Hi ! I have 3 questions that I need help on:
> > > 1. Is it possible to install and run MS-SQL and Oracle from a
> > > single Windows-server box ?
> >
> > Yes.
> >
> > > 2. What specific area should I beef-up the server to enable the 2
> > > database engine to run without problems ?
> >
> > Without problems and Windows? I'd suggest a good anesthetic.
> >
> > > 3. Am I crazy to do this ???
> >
> > Yes.
>
> hear ya loud and clear, thanks anyway.

Contrary to what Daniel says, your requirement is entirely feasible, *depending* on usage. I mainly deal with very small companies (typically fewer than 10 users), many of whom run other applications on their Oracle server (including SQL Server), simply because they don't have the budgets to buy & maintain a server for every function. They also all use Windows.

Whilst we recommend a dedicated server, the only configuration we won't support is doubling up as a domain controller - anything else is fair game. We obviously make them aware that performance may not be optimal, but it's their choice. The only time Oracle gets hammered is at the end of each month, & they're happy to take a performance hit on their other systems at that time if necessary.

So if you have the available free resources on the server, on can add resources at significantly less cost than buying an additional server, there's no reason why you can't do as you suggest. Your 2nd question is impossible to answer though without knowing the database usage.

-- 
Preston.