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).
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).
