-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
-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
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
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,
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
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
:
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
:
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
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
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
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
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
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
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
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
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
-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
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:
: 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
: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
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
-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 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
-
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
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
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
: 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
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_
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
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
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
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
/30/2002 08:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: RE: oracle or mssql
I would like to point out that what you call dirty reads are mostly
the correct reads. Oracle method
: use oracle standard edition / mssql enterprise edition
in all other cases mssql standard edition
-Oorspronkelijk bericht-
Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
Verzonden:woensdag 23 oktober 2002 20:51
Aan: Multiple recipients of list ORACLE-L
Onderwerp:RE: oracle
-Oorspronkelijk bericht-
Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
Verzonden:woensdag 23 oktober 2002 20:51
Aan: Multiple recipients of list ORACLE-L
Onderwerp:RE: oracle or mssql
Xenix is history now...SCO itself stopped it sometime in 1990
Reply-To: [EMAIL
Onderwerp:RE: oracle or mssql
Xenix is history now...SCO itself stopped it sometime in 1990
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 23 Oct 2002 09:02:19 -0800
XENIX maybe.
: )
Regards,
Patrice Boivin
Systems Analyst
standard edition
-Oorspronkelijk bericht-
Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
Verzonden:woensdag 23 oktober 2002 20:51
Aan: Multiple recipients of list ORACLE-L
Onderwerp:RE: oracle or mssql
Xenix is history now...SCO itself stopped it sometime in 1990
to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: RE: oracle or mssql
I would like to point out that what you call dirty reads are mostly
the correct reads. Oracle method IS the dirty read.
I am sure that your users does
programming.
Is that what you're referring to?
Jared
Yechiel Adar [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2002 08:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: RE: oracle or mssql
PROTECTED]]
Verzonden:woensdag 23 oktober 2002 20:51
Aan: Multiple recipients of list ORACLE-L
Onderwerp:RE: oracle or mssql
Xenix is history now...SCO itself stopped it sometime in 1990
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
]]
Verzonden:woensdag 23 oktober 2002 20:51
Aan: Multiple recipients of list ORACLE-L
Onderwerp:RE: oracle or mssql
Xenix is history now...SCO itself stopped it sometime in 1990
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 23 Oct
[SMTP:[EMAIL PROTECTED]]
Verzonden:woensdag 23 oktober 2002 20:51
Aan: Multiple recipients of list ORACLE-L
Onderwerp:RE: oracle or mssql
Xenix is history now...SCO itself stopped it sometime in 1990
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Because your boss is wrong on both issues: features and price.
As for references, check this site:
http://www.itsystems.lv/gints/compare_db.htm
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday,
It depends on your companies needs.
On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote:
Hi list
Please input why my boss must invest into oracle rather than the cheaper
mssql.
His opinion is that most features are almost the same but mssql does that at
half the price as oracle does.
So why he
No it doesn't.
MicroSoft is a card-carrying member of the Axis Of Evil.
Last I heard they were developing nuclear weapons, probably in a huge bunker
under Bill Gates' house.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Wednesday, October 23, 2002 8:54 AM
To: Multiple
If he really wants to go cheap tell him to go with mySQL! At least it will
be an open solution.
Greg
-Original Message-
Sent: Wednesday, October 23, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
No it doesn't.
MicroSoft is a card-carrying member of the Axis Of Evil.
Last I
Its been a while since I used MS SQL but one of the downsides that I
experienced was the fact that MSSQL could not support the user loads we
needed right out of the box. We had to cluster servers together to get the
throughput that we got out of Oracle.
MSSQL might be cheaper at the database
G - Actually, Oracle may not be more expensive. First, of all, you must do a
little digging into what is included in licensing fees. There are some
extras you must pay for with MS that aren't obvious at first glance, like
the right to upgrade.
If you compare list prices, both Oracle and MS
Is MSSQL server available on UNIX?
-Rachna
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 11:25 AM
Its been a while since I used MS SQL but one of the downsides that I
experienced was the fact that MSSQL could not
[mailto:wweaver;rightnow.com]
Sent: Wednesday, October 23, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: oracle or mssql
No it doesn't.
MicroSoft is a card-carrying member of the Axis Of Evil.
Last I heard they were developing nuclear weapons, probably
in a huge bunker
-Is MSSQL server available on UNIX?
Hahahahahahahahaha. ROTFLMAO :o)
No. Only on windows.
Dave
-Original Message-
Sent: Wednesday, October 23, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L
Is MSSQL server available on UNIX?
--
Please see the official ORACLE-L FAQ:
It will be open, not necessarily a solution.
-Original Message-
From: Mirsky, Greg [mailto:gmirsky;Estee.com]
Sent: Wednesday, October 23, 2002 11:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: oracle or mssql
If he really wants to go cheap tell him to go with mySQL
Re. the trial, does anyone know when the judge is expected to rule?
Not a peep re. expected timeline in the media that I can find.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
XENIX maybe.
: )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | Région des
Xenix, now there an OS i've not heard about since '89.
joe
Boivin, Patrice J wrote:
XENIX maybe.
: )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics
Xenix is history now...SCO itself stopped it sometime in 1990
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 23 Oct 2002 09:02:19 -0800
XENIX maybe.
: )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin
56 matches
Mail list logo