|
|
Posted by Robert Klemme on 09/28/79 11:59
a_dba_used_to_oracle wrote:
> I have recently purchased: Learning SQL on SQLServer 2005 -
> O'Reilly Books, and I was given a SQL2000 Microsoft Library; I'm
> finding many
> of the things applicable to SQL2005 as well.
I would start with the conceptual sections in BOL. They describe pretty
well how SQL Server works and looks inside much similar to the Concepts
guide of Oracle.
> I will probably be sent to a SQLServer class in about a year
> (ha)...actually, I've found with new technologies, there's nothing like
> the "throw-the-DBA-in-the-pool-and-let-her-learn-how-to-swim" - it's
> how I learned IMS, CICS, JCL, TSO, UNIX, Oracle and now SQLServer....
Not the worst approach around. At least you have to tackle real world
problems as opposed to those often found in classes / tutorials.
> Oracle DBA's (especially the ones working on UNIX) are very, very
> oriented to writing scripts...I've been using the SQL2005 Enterprise
> Studio, but
> our PeopleSoft 8.9 Financials system has over 70,000 tables!
> Arrrrgh!
As was mentioned: osql.
> I do admit that SQLServer has features superior in some ways to
> Oracle; however - Microsoft: Come up with an Export/Import utility (and
> I don't mean the Bulk Data Transfer or the select....into!)
DTS, BCP you can even use osql for that.
I'm sorry, but somehow I still have the feeling that you grunt about
having to work with SQL Server. It's a quite different beast than
Oracle but it definitively has its merits. If you look at Oracle 10's
Enterprise Manager / Database Control you'll find a lot features that
improve manageability - things present in SQL Server for several years.
Kind regards
robert
Navigation:
[Reply to this message]
|