Home All Groups Group Topic Archive Search About

Oracle DBA to learn MS SQL

Author
10 Aug 2006 11:13 AM
sandiyan
Is there a materials such as the following for an Oracle DBA who would
like to learn MS SQL(e.g. 2005)

- Training courses
- Web sites/ebooks
- MS articles
- etc

SQL Server features and compare it with Oracle.
So, it should be something of learning method for a person with DBA
knowledge(i.e. not for a beginner!)


cheers
Sandiyan

Author
10 Aug 2006 11:27 AM
Bobbo
sandi***@yahoo.co.uk wrote:

> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)

Try typing this into Google:
migrate oracle microsoft sql server

It yields many results, including this:
http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
Author
10 Aug 2006 11:27 AM
Uri Dimant
Hi

Its really  funny because I'm a SQL Server DBA is going to learn  Oracle
:-))))))

Well, as for Oracle , there are lots of info  about SQL Server as well
I'd start with www.microsoft.com\sql
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm#Step1 
--administaiting best practices

http://vyaskn.tripod.com/sql_server_security_best_practices.htm  --------security
best practices

http://www.umachandar.com/resources.htm----------- very good site , a lot of
examples

http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q224071-------
Moving SQL Server Databases to a New Location

<http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q224453>---------
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
(Q224453)

http://www.mssqlcity.com/Articles/Replic/Replic.htm --------Setting All
Replica (Step by step)

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133-------- 
How To Transfer Logins and Passwords Between SQL Servers (Q246133)


<sandi***@yahoo.co.uk> wrote in message
Show quote
news:1155208415.129550.57030@q16g2000cwq.googlegroups.com...
> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)
>
> - Training courses
> - Web sites/ebooks
> - MS articles
> - etc
>
> SQL Server features and compare it with Oracle.
> So, it should be something of learning method for a person with DBA
> knowledge(i.e. not for a beginner!)
>
>
> cheers
> Sandiyan
>
Author
10 Aug 2006 12:04 PM
Dan Guzman
Check out Microsoft SQL Server 2000 for the Oracle Professional:

http://www.microsoft.com/sql/techinfo/whitepapers/sql-server-2005-oracle-pros.mspx

--
Hope this helps.

Dan Guzman
SQL Server MVP

<sandi***@yahoo.co.uk> wrote in message
Show quote
news:1155208415.129550.57030@q16g2000cwq.googlegroups.com...
> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)
>
> - Training courses
> - Web sites/ebooks
> - MS articles
> - etc
>
> SQL Server features and compare it with Oracle.
> So, it should be something of learning method for a person with DBA
> knowledge(i.e. not for a beginner!)
>
>
> cheers
> Sandiyan
>
Author
10 Aug 2006 12:14 PM
Dan Guzman
> Check out Microsoft SQL Server 2000 for the Oracle Professional:
>
> http://www.microsoft.com/sql/techinfo/whitepapers/sql-server-2005-oracle-pros.mspx

That link was for Microsoft SQL Server 2005 for the Oracle Professional,
which is probably most relevant for your situation.  If you are interested
in SQL 2000 too, that article is at the link below.  There are enough
architectural differences in the SQL Server versions to warrant different
articles.

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorpro.mspx



--
Hope this helps.

Dan Guzman
SQL Server MVP

Show quote
"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:Oe%23RVUHvGHA.3552@TK2MSFTNGP03.phx.gbl...
> Check out Microsoft SQL Server 2000 for the Oracle Professional:
>
> http://www.microsoft.com/sql/techinfo/whitepapers/sql-server-2005-oracle-pros.mspx
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> <sandi***@yahoo.co.uk> wrote in message
> news:1155208415.129550.57030@q16g2000cwq.googlegroups.com...
>> Is there a materials such as the following for an Oracle DBA who would
>> like to learn MS SQL(e.g. 2005)
>>
>> - Training courses
>> - Web sites/ebooks
>> - MS articles
>> - etc
>>
>> SQL Server features and compare it with Oracle.
>> So, it should be something of learning method for a person with DBA
>> knowledge(i.e. not for a beginner!)
>>
>>
>> cheers
>> Sandiyan
>>
>
>
Author
10 Aug 2006 12:14 PM
Hari Prasad
SQL Server Books online will a very good startup for learning SQL Server

Thanks
Hari
SQL Server MVP

<sandi***@yahoo.co.uk> wrote in message
Show quote
news:1155208415.129550.57030@q16g2000cwq.googlegroups.com...
> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)
>
> - Training courses
> - Web sites/ebooks
> - MS articles
> - etc
>
> SQL Server features and compare it with Oracle.
> So, it should be something of learning method for a person with DBA
> knowledge(i.e. not for a beginner!)
>
>
> cheers
> Sandiyan
>

AddThis Social Bookmark Button