| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL Server2000 Vs Oracle 8i <-- Attachment History Removed
Just a point of clarification a "database" in Microsoft-speak is a
"tablespace" in Oracle-speak. A "server" in Microsoft language is an "instance" in Oracle terminology. I don't know if you can have multiple "servers" of SQL Server on the same machine, in Oracle you can have multipleinstances on the same machine.
In Oracle a user's schema can store objects in multiple tablespaces, I don't know if that can be done in SQL Server (user A having objects that reference each other transparently on databases X and Y, both of which would be on the same "server").
Oracle8i now lets people detach and re-attach tablespaces, sounds to me a lot like attaching / detaching databases in SQL Server.
I have problems with Microsoft's terminology, they keep referring to their own code / software with the name of the physical object the code depends upon. e.g. a "printer device" for Microsoft is a printer driver, it's not the actual hardware that prints. Likewise a "server" for Microsoft is an installation of MS SQL Server, it's not the host. It can get a little confusing. For me at least...
"Cold" backups can be done online --> this must be new, I read that you can do "cold" backups with SQL Server, but you have to save the transaction log as well if you don't want to lose your latest database changes. You can then restore using the "cold" backup, then apply the transaction log... Hmmm what does this sound like. To me, a cold backup would be shutdown the SQL Server service, MSDTC and the Agent. copy the files physically using the OS. restart the services, and the database will become available automatically.
Maybe you can do a cold backup without backing up the transaction log, I don't know how much faster that would be.
10G is kind of small, when you think about it.
I am an Oracle DBA so if there are inaccuracies in here please correct me so I can learn more.
Patrice Boivin
Oracle Certified DBA
> -----Original Message-----
> From: bruce.taneja_at_mcd.com [SMTP:bruce.taneja_at_mcd.com]
> Sent: Tuesday, November 28, 2000 1:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: SQL Server2000 Vs Oracle 8i <-- Attachment History
> Removed
>
>
>
>
> I have worked as a DBA with both..
> Here are some differences..
>
> SQL server:
> - supports multiple databases within one instance
> - 'cold' backups can be done online (!!)
> - is quite stable in production mode upto 10GB in my experience, I have
> supported some live trading databases for large banks in downtown
> Chicago..
>
> I work as an independant consultant, so if you need to do some analysis/
> installations/etc. etc. feel free to email me back.
>
> Bruce Taneja
>
>
>
>
>
>
> Marcos.Vera_at_msconsultores.com.pe_at_fatcity.com on 11/28/2000 09:25:26 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
>
>
>
>
>
>
> me too.
>
>
>
>
>
>
>
>
> "bunyamin karadeniz" <bunyamink_at_havelsan.com.tr> on 28/11/2000 05:05:25 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
>
>
>
>
>
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
>
> cc: (bcc: Marcos Vera/M&S Consultores/51)
>
>
>
> Subject: Re: SQL Server2000 Vs Oracle 8i
>
>
>
>
>
>
>
>
> I am wondering the subject too...
>
> **********************************************
> Bunyamin K. Karadeniz
> Enformasyon Teknolojileri Dir.
> Veri Tabani Grubu tel : 2873565/1681
> HAVELSAN
> **********************************************
> ----- Original Message -----
> From: Waleed Haggagy
> To: Multiple recipients of list ORACLE-L
> Sent: Tuesday, November 28, 2000 12:10 PM
> Subject: SQL Server2000 Vs Oracle 8i
>
>
> I am looking for SQL Server2000 Vs Oracle 8i comparison..
>
>
> Regards
> Waleed Haggagy
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: bruce.taneja_at_mcd.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Tue Nov 28 2000 - 12:34:35 CST
 |
 |