Microsoft SQL Server for the Oracle-centric

I've recently taken over management responsibility for an application that uses Microsoft SQL Server 2000.

My experience is primarily in Oracle and I've already self educated myself about some of the differences (such as needing to initiate a BEGIN TRAN if I want a rollback segment.)

I couldn't readily find any resources that would coach me in the core differences between Oracle and SQL Server and I wondered if someone could point me in the right direction.

Thanks for your help.Basic Oracle to SQL dictionary

Tablespace = Filegroup

Archivelog = Full Recovery Mode

NoArchivelog = Simple recovery Mode

AutoArchive = well, there ain't no Santa Clause either...

Redo Log = Transaction log

Rollback Area = Transaction log

Block = Page

Extent = Extent (except you have no control on the size)

Sequence = Hmm. About the Easter Bunny...

sys = sa

system = sa

Control File = Remember when you put a tooth under your pillow, and got a quarter...?

System Catalog = Two dozen tables whose names all start with "sys"

SQLPlus = Query Analyzer

Enterprise Manager = Enterprise Manager...sorta

This enough to get you started, or was there a particular area you needed?|||Perhaps this guys book would be useful to you.

http://www.chriskempster.com/

Hans.|||I'm fairly comfortable with the tools and the layouts. So most of what you posted is already absorbed.

Let me give you an example:

Myself and my co-worker are both on this project straight from an Oracle shop. We've had no formal training as MS SQL DBA or programmers.

I knew about BEGIN TRAN just from experience. When I told her about it she was slightly shocked/surprised.

I'm looking for other pitfalls/suprises/traps that I might encounter as an Oracle-Centric.
Or do you think I should just bite the bullet and take some classes?|||Hopefully you know that readers block writers in SQL Server, whereas Readers are never blocked in Oracle?|||There's a bunch of stuff here...

obviously it's slanted toward M$

If you know Oracle, SQL Server will be a breeze....

Do you know if the system is using replication or clustering?

If not...It'll be a walk in the park....

And get some good books

http://www.sqlteam.com/store.asp

Oh, and the forums ain't to shabby either...|||Originally posted by nugenth
looking for other pitfalls/suprises/traps that I might encounter as an Oracle-Centric.


Well...You're gonna need to drop the cursor conciousnous...You know how Oracle uses Cursor pointers a lot?

Doesn't work that way here. You need to avoid cursors like the plague

Or do you think I should just bite the bullet and take some classes?

They gonna pay for it? Why not...Maybe South Beach...|||And there's tons of stuff to google..

http://www.databasejournal.com/features/mssql/article.php/2170201

And the search feature of the forums are useful

http://www.dbforums.com/showthread.php?threadid=694254&highlight=oracle+comparison

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=26552&SearchTerms=Oracle|||such as needing to initiate a BEGIN TRAN if I want a rollback segment.

That is incorrect.
This is the default settings for transactions in SQL Server (Auto Commit).
Look up SET IMPLICIT_TRANSACTIONS { ON | OFF } in BOL...

System Catalog = Two dozen tables whose names all start with "sys"

This is partical correct, but not advised.. Use the INFORMATION_SCHEMA Views that are used in DB2 and SQL Server but Oracle...|||Originally posted by MCrowley
Basic Oracle to SQL dictionary

Tablespace = Filegroup

Archivelog = Full Recovery Mode

NoArchivelog = Simple recovery Mode

AutoArchive = well, there ain't no Santa Clause either...

Redo Log = Transaction log

Rollback Area = Transaction log

Block = Page

Extent = Extent (except you have no control on the size)

Sequence = Hmm. About the Easter Bunny...

sys = sa

system = sa

Control File = Remember when you put a tooth under your pillow, and got a quarter...?

System Catalog = Two dozen tables whose names all start with "sys"

SQLPlus = Query Analyzer

Enterprise Manager = Enterprise Manager...sorta

This enough to get you started, or was there a particular area you needed?

sequence - identity (thought it was just a different lingo...
control file - sp_configure + sp_dboption, at least
system catalog - contents of master and msdb + system objects in every user database|||oye...it's nor Cursor pointers...

it's reference cursors...

Oracle doesn't move data around like sql server

It's all logical...

Damn, I need another Oracle project...it's been awhile....|||Are DB2 and SQL server not enough ...|||No!

You have to learn how to wash windows as well!

AND know how to make a MEAN margaritta!|||where Rownum() < 100 = select top 100

Originally posted by nugenth
I've recently taken over management responsibility for an application that uses Microsoft SQL Server 2000.

My experience is primarily in Oracle and I've already self educated myself about some of the differences (such as needing to initiate a BEGIN TRAN if I want a rollback segment.)

I couldn't readily find any resources that would coach me in the core differences between Oracle and SQL Server and I wondered if someone could point me in the right direction.

Thanks for your help.