SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Oracle and MS SQL locations
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

donafams
Starting Member

11 Posts

Posted - 01/17/2007 :  13:59:34  Show Profile  Reply with Quote
Can oracle91 and MS SQL2005 be on same server

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 01/17/2007 :  14:06:04  Show Profile  Visit spirit1's Homepage  Reply with Quote
probably yes, but why would you want this?



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

donafams
Starting Member

11 Posts

Posted - 01/17/2007 :  14:12:51  Show Profile  Reply with Quote
because im running sql2005 now, we have oracle and i want to lean it and maybe migrate existing db's to it. and right now the only available server i have to use is the one running the MS SQL
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 01/17/2007 :  14:28:17  Show Profile  Visit spirit1's Homepage  Reply with Quote
cool.

Is there a good reason that you'd like to migrate existing data to oracle?
sql server isn't that bad



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 01/17/2007 :  14:29:48  Show Profile  Reply with Quote
Sounds like a "career enhancement" driven project.



CODO ERGO SUM
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37119 Posts

Posted - 01/17/2007 :  14:32:45  Show Profile  Visit tkizer's Homepage  Reply with Quote
If you really want to learn Oracle, then you should do it on a Linux/Unix box rather than a Windows box.

Tara Kizer
Go to Top of Page

donafams
Starting Member

11 Posts

Posted - 01/17/2007 :  15:08:50  Show Profile  Reply with Quote
im not asking about learning oracle, im wondering if they can co-exist on the same server????
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37119 Posts

Posted - 01/17/2007 :  15:11:17  Show Profile  Visit tkizer's Homepage  Reply with Quote
I guess I don't know what "lean it" means. I thought it was a typo for "learn it".

Tara Kizer
Go to Top of Page

donafams
Starting Member

11 Posts

Posted - 01/17/2007 :  15:21:30  Show Profile  Reply with Quote
I guess I don't know what "lean it" means. I thought it was a typo for "learn it".

what???

does anyone know if they can run on the same server please?
Go to Top of Page

donafams
Starting Member

11 Posts

Posted - 01/17/2007 :  15:23:37  Show Profile  Reply with Quote
I guess I don't know what "lean it" means. I thought it was a typo for "learn it".

im not asking this forum about "LEARNING" oracle.. im asking if they can run on the same server
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37119 Posts

Posted - 01/17/2007 :  15:27:38  Show Profile  Visit tkizer's Homepage  Reply with Quote
Yes I realize that. I was just explaining why I posted what I did earlier. I don't know what "lean it" means, that's all.

Tara Kizer
Go to Top of Page

donafams
Starting Member

11 Posts

Posted - 01/17/2007 :  15:28:36  Show Profile  Reply with Quote
OMG... just forget it.
Go to Top of Page

snSQL
Flowing Fount of Yak Knowledge

USA
1837 Posts

Posted - 01/17/2007 :  17:10:18  Show Profile  Reply with Quote
Yes they can run on the same server. For learning SQL Server, Oracle or anything else though, I'd recommend creating virtual machines. Virtual PC is free and lets you create complete server installations in a virtual machine environment without having to install anything on your real machine.
See http://www.microsoft.com/windows/virtualpc/default.mspx
Go to Top of Page

agossage
Starting Member

USA
9 Posts

Posted - 01/17/2007 :  17:35:54  Show Profile  Reply with Quote
FYI... Microsoft and Oracle do not support installation on any version of VMWare, including Microsoft's.

Adam Gossage
Lake Wylie, SC, USA
Go to Top of Page

snSQL
Flowing Fount of Yak Knowledge

USA
1837 Posts

Posted - 01/18/2007 :  01:57:49  Show Profile  Reply with Quote
quote:
FYI... Microsoft and Oracle do not support installation on any version of VMWare, including Microsoft's.

What do you mean by that, Microsoft don't have a version of VMWare?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 01/18/2007 :  02:04:38  Show Profile  Visit SwePeso's Homepage  Reply with Quote
SQL Server 2005 works very well in virtual machines.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

snSQL
Flowing Fount of Yak Knowledge

USA
1837 Posts

Posted - 01/18/2007 :  02:09:45  Show Profile  Reply with Quote
Yes it does, in fact you can create a SQL Server fail-over cluster in virtual machines, which is why I'm wondering what agossage was getting at. I'm not suggesting you should put a cluster in virtual machines for a production server but it's great for testing and learning.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 01/18/2007 :  10:48:22  Show Profile  Reply with Quote
quote:
Originally posted by agossage

FYI... Microsoft and Oracle do not support installation on any version of VMWare, including Microsoft's.

Adam Gossage
Lake Wylie, SC, USA



I'm not sure what you mean by this. VMWare is an EMC product, not a Microsoft product.

Microsoft calls their product Virtual Server, and at least SQL Server is supported on it. I don't know about Oracle. I know it now supports Linux as a "guest" OS.








CODO ERGO SUM
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 01/18/2007 :  10:56:53  Show Profile  Visit spirit1's Homepage  Reply with Quote
as i understood him he meant that if you have sql server or oracle on a virtual machine and you need
MS or Oracle support they won't help you.



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

snSQL
Flowing Fount of Yak Knowledge

USA
1837 Posts

Posted - 01/18/2007 :  11:22:30  Show Profile  Reply with Quote
I don't think that's true either though - I'm not sure about Oracle, but Microsoft do support (as in technical support) SQL Server on Virtual Server, see
http://www.support.microsoft.com/kb/897613/
http://www.support.microsoft.com/kb/897614/
Go to Top of Page

agossage
Starting Member

USA
9 Posts

Posted - 01/18/2007 :  15:32:57  Show Profile  Reply with Quote
Please forgive me. When I wrote VMWare, I was referring to the Virtual Machine technology in general.

My advice is from a best practice point of view. I am not suggesting that SQL Server does not run on VM technology. I am sure it runs fine in some instances. Simply put, it is an untested environment. The total number of servers running SQL in VM technology is limited. Therefore, any issues generated from that type of environment will not be in the mix for the hotfixes/service packs. If you have difficulties and ask Microsoft for assistance, you will be provided limited support and no promises. I am sure each of you would agree that running SQL Server in an environment that is untested is considered risky.

The KB articles 897613 and 897614 are just information that Microsoft decided to publish. No where does it suggest that SQL Server is supported in a VM environment. Microsoft does not publish everything.

Adam Gossage
Lake Wylie, SC, USA
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000