RE: Oracle to MSSQL conversion?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Thursday, July 31, 2003 22:05 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? SNIP What would be the point of installing two SQL Server servers on the same box? Similar to setting up 2 or more instances on one host? No point that I can think of, I just know it can be done. Timothy described one reason - differing sort orders, which also can imply differing code pages/character sets ... sometime a reason for having multiple Oracle instances as well. Another reason for having multiple SQL Server instances is differing security models. SQL server can operate with windows authentication only, or combined windows authentication and traditional username/passwords managed by the server. For those with strict security needs, some people run a separate instance configured to allow mixed authentication for off-the-shelf apps that can't be changed. This would be analogous in Oracle to having one instance that only allowed global or external authentication, and another that allowed those as well as normal Oracle logins. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Thursday, July 31, 2003 19:09 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I think I understand what you have said, Oracle runs an instance per database where MSSQL is one instance running multiple databases. Is this right thinking? Yep, spot on. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
SNIP Wolfe Knowing SQL Server and moving to Oracle is going to be tough. The other way round is very simple though from Oracle to SQL Server. Interesting, why is it more difficult to go from SQL Server to Oracle than the other way around? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
For once, there are many more buttons to push when configuring/tuning Oracle instance/db (I'm not talking about GUI here -:). And, many more options when designing db. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Monday, August 04, 2003 7:15 AM To: Multiple recipients of list ORACLE-L SNIP Wolfe Knowing SQL Server and moving to Oracle is going to be tough. The other way round is very simple though from Oracle to SQL Server. Interesting, why is it more difficult to go from SQL Server to Oracle than the other way around? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
And it takes longer to install ;) -Mensaje original- De: Igor Neyman [mailto:[EMAIL PROTECTED] Enviado el: lunes, 04 de agosto de 2003 11:09 Para: Multiple recipients of list ORACLE-L Asunto: RE: Oracle to MSSQL conversion? For once, there are many more buttons to push when configuring/tuning Oracle instance/db (I'm not talking about GUI here -:). And, many more options when designing db. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Monday, August 04, 2003 7:15 AM To: Multiple recipients of list ORACLE-L SNIP Wolfe Knowing SQL Server and moving to Oracle is going to be tough. The other way round is very simple though from Oracle to SQL Server. Interesting, why is it more difficult to go from SQL Server to Oracle than the other way around? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
So Oracle offers much more fine grained control over what is going on and more options for problem solving? If so - and I'd agree - the surely going from the richer environment to the poorer would be more difficult, at least for DBAs who wish to achieve good business results on a more limited platform. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Neyman Sent: 04 August 2003 16:09 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? For once, there are many more buttons to push when configuring/tuning Oracle instance/db (I'm not talking about GUI here -:). And, many more options when designing db. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Monday, August 04, 2003 7:15 AM To: Multiple recipients of list ORACLE-L SNIP Wolfe Knowing SQL Server and moving to Oracle is going to be tough. The other way round is very simple though from Oracle to SQL Server. Interesting, why is it more difficult to go from SQL Server to Oracle than the other way around? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
I'll go along with that. Try writing SQL for MySQL when you're used to doing so on Oracle Niall Litchfield [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/04/2003 03:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle to MSSQL conversion? So Oracle offers much more fine grained control over what is going on and more options for problem solving? If so - and I'd agree - the surely going from the richer environment to the poorer would be more difficult, at least for DBAs who wish to achieve good business results on a more limited platform. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Neyman Sent: 04 August 2003 16:09 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? For once, there are many more buttons to push when configuring/tuning Oracle instance/db (I'm not talking about GUI here -:). And, many more options when designing db. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Monday, August 04, 2003 7:15 AM To: Multiple recipients of list ORACLE-L SNIP Wolfe Knowing SQL Server and moving to Oracle is going to be tough. The other way round is very simple though from Oracle to SQL Server. Interesting, why is it more difficult to go from SQL Server to Oracle than the other way around? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle to MSSQL conversion?
Heh-heh, when I saw MySQL first time had to design a small app on MySQL, I was naive enough to assume that a database that much widespread should have read consistency transaction handling mechanisms. Of course I was wrong, mysql was very trivial 5 years ago and I wasted several days when I actually read the documentation (as I should have done in the first place) and had to redesign the app. I won't be doing the same mistake again, though ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 2:44 AM I'll go along with that. Try writing SQL for MySQL when you're used to doing so on Oracle Niall Litchfield [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/04/2003 03:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle to MSSQL conversion? So Oracle offers much more fine grained control over what is going on and more options for problem solving? If so - and I'd agree - the surely going from the richer environment to the poorer would be more difficult, at least for DBAs who wish to achieve good business results on a more limited platform. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Neyman Sent: 04 August 2003 16:09 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? For once, there are many more buttons to push when configuring/tuning Oracle instance/db (I'm not talking about GUI here -:). And, many more options when designing db. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Monday, August 04, 2003 7:15 AM To: Multiple recipients of list ORACLE-L SNIP Wolfe Knowing SQL Server and moving to Oracle is going to be tough. The other way round is very simple though from Oracle to SQL Server. Interesting, why is it more difficult to go from SQL Server to Oracle than the other way around? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official
RE: Oracle to MSSQL conversion?
Yep, and they use the same definition of an hour as Oracle did with the Oracle Applications One-Hour Install :) Hmm, must be a one hour course then ;-) On Thursday 31 July 2003 12:34, you wrote: I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
Oracle, in a Real Application Clusters configuration, can run multiple instances against one database. --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I think I understand what you have said, Oracle runs an instance per database where MSSQL is one instance running multiple databases. Is this right thinking? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Grant Allen [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 12:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. But there are more things that the SQL Server database has controlled by its instance than things it can set itself (e.g. performance parameters, security settings, user sort space, processor affinity, connection handling etc. etc. are all instance settings). It's more accurate to say that an Oracle instance is closer to a SQL Server instance than a database, but is by no means exactly the same. Oracle just doesn't have the concept of multiple database support in one instance (and I mean database, not schema). That's not necessarily a bad thing, just means they are different to SQL Server (and DB2, Informix, Sybase and others which all have this). I'll stop there ... enough people on the list have heard my rant about this before :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
Stephen, I suggest reading the concepts manual... (for 9i Release 2, see http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/toc.htm in .pdf format http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96524.pdf ) If you're going to work with Oracle you will have to read through one of these anyway, might as well do it now to get it over with... Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
I would have to disagree there. We run multiple SQL Server instances (which consists of the memory structure, physical files and logical structure) on one server. The reason for this is multiple sort code, which is like the same as the character set in Oracle. Personally I think the developers had no good business case for a different sort-order and normally we run one instance per server with multiple databases. Some of our applications are using Case-Sensitive Dictionary sorting while others are using case-insensitive binary. There is another whole topic about sort-orders as they can be set at Instance Level (which is the same as an Oracle instance), database level or table level. The databases on SQL server are not the same as the schema in Oracle, since the schema in Oracle is based on a user. In SQL I can have a database an multiple users within the database, all the objects in Database A are belonging to User A, User B needs to be granted rights to objects in Database A - therefore not exactly the same as a schema in Oracle. In Oracle all the objects in a schema belong to a single user and they have access to them. I have been reading the forums for a while so if any of my comments are slightly wrong please do not flame me, I am busy typing this at work :-) If they are way wrong then please let me know that's why I read this forum - to learn. Cheers Timothy Clarkson SQL DBA/OCA -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 10:05 PM To: Multiple recipients of list ORACLE-L SNIP What would be the point of installing two SQL Server servers on the same box? Similar to setting up 2 or more instances on one host? No point that I can think of, I just know it can be done. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Clarkson, Timothy T SEOP-OEIRH/1 INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
Thanks, I didn't have much to do over the weekend anyway. g v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? Stephen, I suggest reading the concepts manual... (for 9i Release 2, see http://download-west.oracle.com/docs/cd/B10501_01/server.920/a 96524/toc.htm in .pdf format http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96524.pdf ) If you're going to work with Oracle you will have to read through one of these anyway, might as well do it now to get it over with... Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle to MSSQL conversion?
Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! __ ___ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com __ ___ ## ### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
I have a question re. these conversions... If an Oracle database has 120 tablespaces, how does that translate in MSSQL speak? (One of the tablespaces is USERS, home of dozens of schemas; the others are either RB, SYSTEM, TEMP or application tablespaces) How many separate schemas-tablespaces can MSSQL hold per server? Patrice. -Original Message- Sent: Thursday, July 31, 2003 7:34 AM To: Multiple recipients of list ORACLE-L I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! __ ___ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com __ ___ ## ### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle to MSSQL conversion?
Hmm, must be a one hour course then ;-) On Thursday 31 July 2003 12:34, you wrote: I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! __ ___ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com __ ___ ## ### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Anjo Kolk http://www.oraperf.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Boivin, Patrice J Sent: Thursday, July 31, 2003 12:59 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I have a question re. these conversions... If an Oracle database has 120 tablespaces, how does that translate in MSSQL speak? The closest analogy is Filegroups. Serve very similar purpose (to abstract the physical storage), but aren't quite as sophisticated (no surprises there) (One of the tablespaces is USERS, home of dozens of schemas; the others are either RB, SYSTEM, TEMP or application tablespaces) How many separate schemas-tablespaces can MSSQL hold per server? No practical limit on schemas, don't know about Filegroups. Be warned that some people will try to convince you an Oracle schema equates to a SQLServer database. They're talking rubbish. A schema is a schema in both. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle to MSSQL conversion?
You might like to buy the ebook SQL Server 2000 for Oracle DBA's by Chris Kempster: http://www.chriskempster.com/ I bought it, printed it and had it bound at Kinko's. Appears to be a very good book, though I've only read parts of it. Jared On Thu, 2003-07-31 at 02:34, Denham Eva wrote: Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5). At my installation I have 5 SQL-2000 database machines and recently acquired three Oracle 9i machines. The limit is essentially a function of your storage area and the amount of real memory available to the processor or processor array. I'm trying to draw similarities between the RDBM concepts now as I learn Oracle's idea of a database. Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I have a question re. these conversions... If an Oracle database has 120 tablespaces, how does that translate in MSSQL speak? (One of the tablespaces is USERS, home of dozens of schemas; the others are either RB, SYSTEM, TEMP or application tablespaces) How many separate schemas-tablespaces can MSSQL hold per server? Patrice. -Original Message- Sent: Thursday, July 31, 2003 7:34 AM To: Multiple recipients of list ORACLE-L I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! __ ___ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com __ ___ ## ### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing
RE: Oracle to MSSQL conversion?
An Oracle database with multiple applications using different schemas in the same database would be close to the SQL Server model. Ron Smith -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5). At my installation I have 5 SQL-2000 database machines and recently acquired three Oracle 9i machines. The limit is essentially a function of your storage area and the amount of real memory available to the processor or processor array. I'm trying to draw similarities between the RDBM concepts now as I learn Oracle's idea of a database. Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I have a question re. these conversions... If an Oracle database has 120 tablespaces, how does that translate in MSSQL speak? (One of the tablespaces is USERS, home of dozens of schemas; the others are either RB, SYSTEM, TEMP or application tablespaces) How many separate schemas-tablespaces can MSSQL hold per server? Patrice. -Original Message- Sent: Thursday, July 31, 2003 7:34 AM To: Multiple recipients of list ORACLE-L I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! __ ___ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com __ ___ ## ### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
RE: Oracle to MSSQL conversion?
Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. But there are more things that the SQL Server database has controlled by its instance than things it can set itself (e.g. performance parameters, security settings, user sort space, processor affinity, connection handling etc. etc. are all instance settings). It's more accurate to say that an Oracle instance is closer to a SQL Server instance than a database, but is by no means exactly the same. Oracle just doesn't have the concept of multiple database support in one instance (and I mean database, not schema). That's not necessarily a bad thing, just means they are different to SQL Server (and DB2, Informix, Sybase and others which all have this). I'll stop there ... enough people on the list have heard my rant about this before :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
An Oracle instance does not correlate to a SQL Server database. An Oracle instance is a running Oracle server, i.e., a set of background processes and a System Global Area in memory. It is what permits applications to _access_ the database. The database is on disk, the instance in memory. An Oracle _schema_ is analogous to a SQL Server database. (BTW, what does v/r mean?) --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5). At my installation I have 5 SQL-2000 database machines and recently acquired three Oracle 9i machines. The limit is essentially a function of your storage area and the amount of real memory available to the processor or processor array. I'm trying to draw similarities between the RDBM concepts now as I learn Oracle's idea of a database. Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I have a question re. these conversions... If an Oracle database has 120 tablespaces, how does that translate in MSSQL speak? (One of the tablespaces is USERS, home of dozens of schemas; the others are either RB, SYSTEM, TEMP or application tablespaces) How many separate schemas-tablespaces can MSSQL hold per server? Patrice. -Original Message- Sent: Thursday, July 31, 2003 7:34 AM To: Multiple recipients of list ORACLE-L I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! __ ___ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com __ ___ ## ### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
RE: Oracle to MSSQL conversion?
I haven't heard of an SQL Server instance before... do you mean a SQL Server server? (this is getting a bit confusing) Patrice. -Original Message- Sent: Thursday, July 31, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. But there are more things that the SQL Server database has controlled by its instance than things it can set itself (e.g. performance parameters, security settings, user sort space, processor affinity, connection handling etc. etc. are all instance settings). It's more accurate to say that an Oracle instance is closer to a SQL Server instance than a database, but is by no means exactly the same. Oracle just doesn't have the concept of multiple database support in one instance (and I mean database, not schema). That's not necessarily a bad thing, just means they are different to SQL Server (and DB2, Informix, Sybase and others which all have this). I'll stop there ... enough people on the list have heard my rant about this before :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
I think I understand what you have said, Oracle runs an instance per database where MSSQL is one instance running multiple databases. Is this right thinking? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Grant Allen [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 12:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. But there are more things that the SQL Server database has controlled by its instance than things it can set itself (e.g. performance parameters, security settings, user sort space, processor affinity, connection handling etc. etc. are all instance settings). It's more accurate to say that an Oracle instance is closer to a SQL Server instance than a database, but is by no means exactly the same. Oracle just doesn't have the concept of multiple database support in one instance (and I mean database, not schema). That's not necessarily a bad thing, just means they are different to SQL Server (and DB2, Informix, Sybase and others which all have this). I'll stop there ... enough people on the list have heard my rant about this before :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
Yes, MSSQL is running as an instance and you can multiple instances on the same server (that is W2K or 2003 server), each instance is SQL server consuming it's predefined resources. Each instance of MSSQL can be servicing different databases. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I haven't heard of an SQL Server instance before... do you mean a SQL Server server? (this is getting a bit confusing) Patrice. -Original Message- Sent: Thursday, July 31, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. But there are more things that the SQL Server database has controlled by its instance than things it can set itself (e.g. performance parameters, security settings, user sort space, processor affinity, connection handling etc. etc. are all instance settings). It's more accurate to say that an Oracle instance is closer to a SQL Server instance than a database, but is by no means exactly the same. Oracle just doesn't have the concept of multiple database support in one instance (and I mean database, not schema). That's not necessarily a bad thing, just means they are different to SQL Server (and DB2, Informix, Sybase and others which all have this). I'll stop there ... enough people on the list have heard my rant about this before :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
An SQL Server instance IS the Server... -Mensaje original- De: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Enviado el: jueves, 31 de julio de 2003 13:39 Para: Multiple recipients of list ORACLE-L Asunto: RE: Oracle to MSSQL conversion? I haven't heard of an SQL Server instance before... do you mean a SQL Server server? (this is getting a bit confusing) Patrice. -Original Message- Sent: Thursday, July 31, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. But there are more things that the SQL Server database has controlled by its instance than things it can set itself (e.g. performance parameters, security settings, user sort space, processor affinity, connection handling etc. etc. are all instance settings). It's more accurate to say that an Oracle instance is closer to a SQL Server instance than a database, but is by no means exactly the same. Oracle just doesn't have the concept of multiple database support in one instance (and I mean database, not schema). That's not necessarily a bad thing, just means they are different to SQL Server (and DB2, Informix, Sybase and others which all have this). I'll stop there ... enough people on the list have heard my rant about this before :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
: ) So an MS SQL server = an Oracle instance An MS SQL database = (roughly speaking) an Oracle schema. An MS SQL file set = (roughly speaking) an Oracle tablespace. and data files are data files. Is that correct? What would be the point of installing two SQL Server servers on the same box? Similar to setting up 2 or more instances on one host? Patrice. -Original Message- Sent: Thursday, July 31, 2003 2:14 PM To: Multiple recipients of list ORACLE-L An Oracle instance does not correlate to a SQL Server database. An Oracle instance is a running Oracle server, i.e., a set of background processes and a System Global Area in memory. It is what permits applications to _access_ the database. The database is on disk, the instance in memory. An Oracle _schema_ is analogous to a SQL Server database. (BTW, what does v/r mean?) --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5). At my installation I have 5 SQL-2000 database machines and recently acquired three Oracle 9i machines. The limit is essentially a function of your storage area and the amount of real memory available to the processor or processor array. I'm trying to draw similarities between the RDBM concepts now as I learn Oracle's idea of a database. Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I have a question re. these conversions... If an Oracle database has 120 tablespaces, how does that translate in MSSQL speak? (One of the tablespaces is USERS, home of dozens of schemas; the others are either RB, SYSTEM, TEMP or application tablespaces) How many separate schemas-tablespaces can MSSQL hold per server? Patrice. -Original Message- Sent: Thursday, July 31, 2003 7:34 AM To: Multiple recipients of list ORACLE-L I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! __ ___ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com __ ___ ## ### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
RE: Oracle to MSSQL conversion?
Thanks. v/r means Very Respectfully v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? An Oracle instance does not correlate to a SQL Server database. An Oracle instance is a running Oracle server, i.e., a set of background processes and a System Global Area in memory. It is what permits applications to _access_ the database. The database is on disk, the instance in memory. An Oracle _schema_ is analogous to a SQL Server database. (BTW, what does v/r mean?) --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5). At my installation I have 5 SQL-2000 database machines and recently acquired three Oracle 9i machines. The limit is essentially a function of your storage area and the amount of real memory available to the processor or processor array. I'm trying to draw similarities between the RDBM concepts now as I learn Oracle's idea of a database. Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I have a question re. these conversions... If an Oracle database has 120 tablespaces, how does that translate in MSSQL speak? (One of the tablespaces is USERS, home of dozens of schemas; the others are either RB, SYSTEM, TEMP or application tablespaces) How many separate schemas-tablespaces can MSSQL hold per server? Patrice. -Original Message- Sent: Thursday, July 31, 2003 7:34 AM To: Multiple recipients of list ORACLE-L I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! __ ___ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com __ ___ ## ### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services
RE: Oracle to MSSQL conversion?
SNIP What would be the point of installing two SQL Server servers on the same box? Similar to setting up 2 or more instances on one host? No point that I can think of, I just know it can be done. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
Correct. As for your second question, I have no idea! --- Boivin, Patrice J [EMAIL PROTECTED] wrote: : ) So an MS SQL server = an Oracle instance An MS SQL database = (roughly speaking) an Oracle schema. An MS SQL file set = (roughly speaking) an Oracle tablespace. and data files are data files. Is that correct? What would be the point of installing two SQL Server servers on the same box? Similar to setting up 2 or more instances on one host? Patrice. -Original Message- Sent: Thursday, July 31, 2003 2:14 PM To: Multiple recipients of list ORACLE-L An Oracle instance does not correlate to a SQL Server database. An Oracle instance is a running Oracle server, i.e., a set of background processes and a System Global Area in memory. It is what permits applications to _access_ the database. The database is on disk, the instance in memory. An Oracle _schema_ is analogous to a SQL Server database. (BTW, what does v/r mean?) --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5). At my installation I have 5 SQL-2000 database machines and recently acquired three Oracle 9i machines. The limit is essentially a function of your storage area and the amount of real memory available to the processor or processor array. I'm trying to draw similarities between the RDBM concepts now as I learn Oracle's idea of a database. Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I have a question re. these conversions... If an Oracle database has 120 tablespaces, how does that translate in MSSQL speak? (One of the tablespaces is USERS, home of dozens of schemas; the others are either RB, SYSTEM, TEMP or application tablespaces) How many separate schemas-tablespaces can MSSQL hold per server? Patrice. -Original Message- Sent: Thursday, July 31, 2003 7:34 AM To: Multiple recipients of list ORACLE-L I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! __ ___ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com __ ___ ## ### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized
RE: Oracle to MSSQL conversion?
Title: RE: Oracle to MSSQL conversion? Wolfe Knowing SQL Server and moving to Oracle is going to be tough. The other way round is very simple though from Oracle to SQL Server. Every database functions differently in many respects. Best is not to compare the both and try and learn the concepts of Oracle. Start with the Oracle Concepts guide and understand the functionality and working of Oracle. Regards Suhen -Original Message- From: Wolfe Stephen S GS-11 6 MDSS/SGSI [mailto:[EMAIL PROTECTED]] Sent: Friday, 1 August 2003 1:55 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5). At my installation I have 5 SQL-2000 database machines and recently acquired three Oracle 9i machines. The limit is essentially a function of your storage area and the amount of real memory available to the processor or processor array. I'm trying to draw similarities between the RDBM concepts now as I learn Oracle's idea of a database. Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 31, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I have a question re. these conversions... If an Oracle database has 120 tablespaces, how does that translate in MSSQL speak? (One of the tablespaces is USERS, home of dozens of schemas; the others are either RB, SYSTEM, TEMP or application tablespaces) How many separate schemas-tablespaces can MSSQL hold per server? Patrice. -Original Message- Sent: Thursday, July 31, 2003 7:34 AM To: Multiple recipients of list ORACLE-L I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks : MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! __ ___ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com __ ___ ## ### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You
RE: Oracle to MSSQL conversion?
Title: RE: Oracle to MSSQL conversion? What SQL Server calls databases I think of them as schemas in Oracle. Suhen -Original Message- From: Wolfe Stephen S GS-11 6 MDSS/SGSI [mailto:[EMAIL PROTECTED]] Sent: Friday, 1 August 2003 4:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? Yes, MSSQL is running as an instance and you can multiple instances on the same server (that is W2K or 2003 server), each instance is SQL server consuming it's predefined resources. Each instance of MSSQL can be servicing different databases. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 31, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I haven't heard of an SQL Server instance before... do you mean a SQL Server server? (this is getting a bit confusing) Patrice. -Original Message- Sent: Thursday, July 31, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. But there are more things that the SQL Server database has controlled by its instance than things it can set itself (e.g. performance parameters, security settings, user sort space, processor affinity, connection handling etc. etc. are all instance settings). It's more accurate to say that an Oracle instance is closer to a SQL Server instance than a database, but is by no means exactly the same. Oracle just doesn't have the concept of multiple database support in one instance (and I mean database, not schema). That's not necessarily a bad thing, just means they are different to SQL Server (and DB2, Informix, Sybase and others which all have this). I'll stop there ... enough people on the list have heard my rant about this before :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: oracle or mssql
I work on contract and as a consulting Oracle DBA. I've migrated several companies from SQL Server because the block level locking did not scale to Oracle. I never had anyone ask me if I could convert them from Oracle to SQL Server. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 31, 2002 11:19 AM Disagree. row-level locking in SQL Server was introduced in some capacity only in SQL Server 7 (not long time ago). Before, it was block-level locking, and I saw lots of problems with that. It's not the length of the single statement (select/update/...) that matters. It's the length of the transaction, that causes a problem, if block_level locking is used (and could be automatically escalated to extent or even table level lock). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 31, 2002 10:18 AM I don't see it as a gotcha, I've worked with SQL Server for almost 6 years on some pretty big databases and have never had a problem. At the end of the day, locking is at the row level, locks are held for a very short time (unless developers don't know what they are doing). A read will take a shared row level lock for a sub-second period of time (potentially), if your update is blocked for 0.2 seconds are you going to notice ? You have to realise that with row level locking the scope for blocking is minimal. Ade -Original Message- Sent: 31 October 2002 14:04 To: Multiple recipients of list ORACLE-L But this default mssql behaviour is the performance 'gotcha' where readers block writers and writers block readers isn't it? Mike. -Original Message- Sent: 31 October 2002 09:12 To: Multiple recipients of list ORACLE-L 'Dirty reads' in SQL Server means that you can view records that have not been committed. This is implemented by setting the TRANSACTION ISOLATION LEVEL to READ UNCOMMITTED. This is not default behaviour in SQL Server, the default TIL is READ COMMITTED (for very good reason). I can think of very few situations where you would want to see uncommitted records. Dirty blocks in SQL Server/Oracle are the same thing ie. a block/page in cache that has been changed but not flushed to disk. Ade -Original Message- Sent: 30 October 2002 18:43 To: Multiple recipients of list ORACLE-L It sounds like he is saying that, once an insert, update or delete statement has been issued (without a following commit), then the records acted upon are now considered dirty - i.e. needing writing to disk. this is, of course, NOT what Oracle considers a dirty block. I agree with you, Jared! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 30, 2002 1:21 PM To: Multiple recipients of list ORACLE-L At least one of us has the incorrect understanding of 'dirty' reads, or I am taking you too literally, or something. What are you really saying? Oracle does not allow dirty reads. All queries are consistent to a point in time, the beginning of a transaction, whether implicit (select) or explicit ( start transaction ). SQL Server and Sybase do not guarantee this. The 'dirty' reads you are speaking of sound more to me like sloppy programming. Is that what you're referring to? Jared Yechiel Adar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2002 08:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: RE: oracle or mssql I would like to point out that what you call dirty reads are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The dirty read method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until
Re: oracle or mssql
That was exactly my point. It is NOT 6 of one , half dozen of the other. You commit 1000's of times for each rollback. So the data you read is incorrect while you read it with enormous odds that the changes will be committed. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 8:09 PM But Yechiel, what is better? Getting data that has not been committed by the application, or data that has been updated by an application without a commit being issued? In the mssql option, do you really want to return data as valid, taking the chance that the person who updated the record may issue a rollback? I think it's 6 of one, half a dozen of the other. At least with Oracle, it's logical and under the applications control. If the user issues a commit, then the new data is available for query. If the application needs the data commited more frequently, then issuing commits more often is certainly available. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 30, 2002 11:55 AM To: Multiple recipients of list ORACLE-L I would like to point out that what you call dirty reads are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The dirty read method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City
Re: RE: oracle or mssql
Any database engine that offers dirty-reads as an option is doing so because it hasn't perfected the ability to avoid them. The dust settled on this issue over a decade ago. Check out Gray and Reuter Transaction Processing: Concepts and Techniques (ISBN: 1558601902 - it'll be in any college library) and read the section on the ACID properties, especially the sections on C for consistency and I for isolation... Oracle is doing the best thing. It supplies statement-level read-consistency by default. The ACID properties advise transaction-level read-consistency and Oracle offers that option, but it is not advisable to use it unless you are using a transaction-processing monitor besides... Thousand-to-one odds are awful. You can run across the exception millions of times per day. 90% of all coding is created to deal with 10% or less of the possible situations... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 9:54 AM I would like to point out that what you call dirty reads are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The dirty read method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
Re: RE: oracle or mssql
I would like to point out that what you call dirty reads are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The dirty read method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing
RE: oracle or mssql
But Yechiel, what is better? Getting data that has not been committed by the application, or data that has been updated by an application without a commit being issued? In the mssql option, do you really want to return data as valid, taking the chance that the person who updated the record may issue a rollback? I think it's 6 of one, half a dozen of the other. At least with Oracle, it's logical and under the applications control. If the user issues a commit, then the new data is available for query. If the application needs the data commited more frequently, then issuing commits more often is certainly available. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 30, 2002 11:55 AM To: Multiple recipients of list ORACLE-L I would like to point out that what you call dirty reads are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The dirty read method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing
Re: RE: oracle or mssql
At least one of us has the incorrect understanding of 'dirty' reads, or I am taking you too literally, or something. What are you really saying? Oracle does not allow dirty reads. All queries are consistent to a point in time, the beginning of a transaction, whether implicit (select) or explicit ( start transaction ). SQL Server and Sybase do not guarantee this. The 'dirty' reads you are speaking of sound more to me like sloppy programming. Is that what you're referring to? Jared Yechiel Adar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2002 08:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: RE: oracle or mssql I would like to point out that what you call dirty reads are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The dirty read method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
RE: RE: oracle or mssql
It sounds like he is saying that, once an insert, update or delete statement has been issued (without a following commit), then the records acted upon are now considered dirty - i.e. needing writing to disk. this is, of course, NOT what Oracle considers a dirty block. I agree with you, Jared! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 30, 2002 1:21 PM To: Multiple recipients of list ORACLE-L At least one of us has the incorrect understanding of 'dirty' reads, or I am taking you too literally, or something. What are you really saying? Oracle does not allow dirty reads. All queries are consistent to a point in time, the beginning of a transaction, whether implicit (select) or explicit ( start transaction ). SQL Server and Sybase do not guarantee this. The 'dirty' reads you are speaking of sound more to me like sloppy programming. Is that what you're referring to? Jared Yechiel Adar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2002 08:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: RE: oracle or mssql I would like to point out that what you call dirty reads are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The dirty read method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq
RE: RE: oracle or mssql
List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City
Re: RE: oracle or mssql
It's these readers-blocks-writers and dirty reads that makes people migrate their data to Oracle. Blocking writers kills performance. Of course constantly rolling back blocks to give queries consistent views uses i/o and cpu. But that extra overhead rarely impacts overall performance as badly as blocking readers/writers does. The typical impetus to migrate is that Oracle's redo/rollback/undo allows it to scale a lot better than MSSQL. It happens all the time. MSSQL was cheap, easy to set up and manage, ran as an integral part of WinTel, handled the low transaction rate. The transaction rate increases. Eventually all attempts to distribute the data amongst multiple boxes to handle the increased transaction rate fails. Exit MSSQL, enter Oracle. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 6:18 AM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
RE: oracle or mssql
goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: oracle or mssql
As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle or mssql
Because your boss is wrong on both issues: features and price. As for references, check this site: http://www.itsystems.lv/gints/compare_db.htm Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 3:38 AM Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle or mssql
It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle or mssql
No it doesn't. MicroSoft is a card-carrying member of the Axis Of Evil. Last I heard they were developing nuclear weapons, probably in a huge bunker under Bill Gates' house. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, October 23, 2002 8:54 AM To: Multiple recipients of list ORACLE-L It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle or mssql
If he really wants to go cheap tell him to go with mySQL! At least it will be an open solution. Greg -Original Message- Sent: Wednesday, October 23, 2002 11:09 AM To: Multiple recipients of list ORACLE-L No it doesn't. MicroSoft is a card-carrying member of the Axis Of Evil. Last I heard they were developing nuclear weapons, probably in a huge bunker under Bill Gates' house. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, October 23, 2002 8:54 AM To: Multiple recipients of list ORACLE-L It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mirsky, Greg INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle or mssql
Its been a while since I used MS SQL but one of the downsides that I experienced was the fact that MSSQL could not support the user loads we needed right out of the box. We had to cluster servers together to get the throughput that we got out of Oracle. MSSQL might be cheaper at the database software level but it was more expensive at the hardware level.. at least in our case. -Original Message- Sent: Wednesday, October 23, 2002 10:09 AM To: Multiple recipients of list ORACLE-L No it doesn't. MicroSoft is a card-carrying member of the Axis Of Evil. Last I heard they were developing nuclear weapons, probably in a huge bunker under Bill Gates' house. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, October 23, 2002 8:54 AM To: Multiple recipients of list ORACLE-L It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle or mssql
G - Actually, Oracle may not be more expensive. First, of all, you must do a little digging into what is included in licensing fees. There are some extras you must pay for with MS that aren't obvious at first glance, like the right to upgrade. If you compare list prices, both Oracle and MS have Enterprise and Standard versions. Yes, if you just compare Enterprise to Enterprise or Standard to Standard, then MS is cheaper. But if you look more closely at the included features, I would argue that MS Enterprise aligns most closely with Oracle Standard Edition. Oracle Enterprise Edition includes features that are far beyond MS SQL Enterprise. If you instead compare MS Enterprise with Oracle Standard, then Oracle is cheaper. To be honest, if the shop is totally devoted to developing everything using MS tools (like .NET), then I would seriously consider MSSQL. Personally, I would consider working somewhere else. Obviously you are willing to be locked into the Intel platform. MS development tools use some strange methods to access a database, and are difficult to understand. Also, Microsoft and Oracle do not seem to acknowledge each other's existence, so there isn't much documentation from either vendor in terms of things like how to get ADO to work with Oracle. But if you want more than superficial replies, then you're going to have to tell us more about your situation, and what your boss' priorities are. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 2:38 AM To: Multiple recipients of list ORACLE-L Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle or mssql
Is MSSQL server available on UNIX? -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 11:25 AM Its been a while since I used MS SQL but one of the downsides that I experienced was the fact that MSSQL could not support the user loads we needed right out of the box. We had to cluster servers together to get the throughput that we got out of Oracle. MSSQL might be cheaper at the database software level but it was more expensive at the hardware level.. at least in our case. -Original Message- Sent: Wednesday, October 23, 2002 10:09 AM To: Multiple recipients of list ORACLE-L No it doesn't. MicroSoft is a card-carrying member of the Axis Of Evil. Last I heard they were developing nuclear weapons, probably in a huge bunker under Bill Gates' house. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, October 23, 2002 8:54 AM To: Multiple recipients of list ORACLE-L It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle or mssql
I've heard that, too. We must be afraid because Microsoft ICBM's will be running Win2k/sp3 and .net. Knowing the security of that particular peace of software, I wouldn't be surprised if they blow the world up before their next release. -Original Message- From: Weaver, Walt [mailto:wweaver;rightnow.com] Sent: Wednesday, October 23, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: oracle or mssql No it doesn't. MicroSoft is a card-carrying member of the Axis Of Evil. Last I heard they were developing nuclear weapons, probably in a huge bunker under Bill Gates' house. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, October 23, 2002 8:54 AM To: Multiple recipients of list ORACLE-L It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle or mssql
-Is MSSQL server available on UNIX? Hahahahahahahahaha. ROTFLMAO :o) No. Only on windows. Dave -Original Message- Sent: Wednesday, October 23, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: oracle or mssql
ARE YOU AN IDIOT?? Otherwise, pass some of whatever your smoking this way because it must be good!! Dick Goulet Reply Separator Author: Rachna Vaidya [EMAIL PROTECTED] Date: 10/23/2002 7:59 AM Is MSSQL server available on UNIX? -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 11:25 AM Its been a while since I used MS SQL but one of the downsides that I experienced was the fact that MSSQL could not support the user loads we needed right out of the box. We had to cluster servers together to get the throughput that we got out of Oracle. MSSQL might be cheaper at the database software level but it was more expensive at the hardware level.. at least in our case. -Original Message- Sent: Wednesday, October 23, 2002 10:09 AM To: Multiple recipients of list ORACLE-L No it doesn't. MicroSoft is a card-carrying member of the Axis Of Evil. Last I heard they were developing nuclear weapons, probably in a huge bunker under Bill Gates' house. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, October 23, 2002 8:54 AM To: Multiple recipients of list ORACLE-L It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http
RE: oracle or mssql
It will be open, not necessarily a solution. -Original Message- From: Mirsky, Greg [mailto:gmirsky;Estee.com] Sent: Wednesday, October 23, 2002 11:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: oracle or mssql If he really wants to go cheap tell him to go with mySQL! At least it will be an open solution. Greg -Original Message- Sent: Wednesday, October 23, 2002 11:09 AM To: Multiple recipients of list ORACLE-L No it doesn't. MicroSoft is a card-carrying member of the Axis Of Evil. Last I heard they were developing nuclear weapons, probably in a huge bunker under Bill Gates' house. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, October 23, 2002 8:54 AM To: Multiple recipients of list ORACLE-L It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mirsky, Greg INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle or mssql
Re. the trial, does anyone know when the judge is expected to rule? Not a peep re. expected timeline in the media that I can find. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle or mssql
XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle or mssql
Xenix, now there an OS i've not heard about since '89. joe Boivin, Patrice J wrote: XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle or mssql
Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle or mssql
Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).