Equivalent SQL Server tools

  • sampathgowri

    SSC Veteran

    Points: 292

    I am new to SQL Server. I want to know the Oracle equivalent tools in SQL Server.

    1. Oracle - PL SQL : What is is the similar tool in SQL Sever.

    2. Oracle - Forms : What is is the similar tool in SQL Sever.

    3. Oracle - Reports : What is is the similar tool in SQL Sever.

    4. Oracle - Datawarehousing : What is is the similar tool in SQL Sever.

    5. Oracle - BI (Discoverer) : What is is the similar tool in SQL Sever.

    6. Oracle - Designer : What is is the similar tool in SQL Sever.

    Thank you.

  • Vijaya Kadiyala

    SSCrazy Eights

    Points: 9119

    Hi,

    Rather posting what is the equivalent tool in SQL Server, what is your requirement?

    Oracle Datawarehousing -- is not a tool..

    Oralce PL/SQL is not a tool -- its a language and TSQL is equivalent to this.

    Thanks -- Vj

  • Teshome-283915

    Old Hand

    Points: 367

    [qoute]

    1. Oracle - PL SQL : What is is the similar tool in SQL Sever.

    [/quote]

    Transact-SQL

    [qoute]

    2. Oracle - Forms : What is is the similar tool in SQL Sever.

    [/quote]

    No equivalent to this. But you can use visual studio 2005 to do similar thing.

    [qoute]

    3. Oracle - Reports : What is is the similar tool in SQL Sever.

    [/quote]

    SQL server reporting services

    [qoute]

    4. Oracle - Datawarehousing : What is is the similar tool in SQL Sever.

    [/quote]

    This as it posted previously is not a tool. Oracle uses in build materalised views for your warehouse needs. But, I beleive warehouse should be designed by its own right. Refer to Kimball for multidimentional modelling.

    [qoute]

    5. Oracle - BI (Discoverer) : What is is the similar tool in SQL Sever.

    [/quote]

    Similar but not exactly the same, I would probably say SQL server integration services.

    [qoute]

    6. Oracle - Designer : What is is the similar tool in SQL Sever.

    [/quote]

    None I know. Again, visual studio will do most of the stuff you want to do.

    regards

    Teshome

  • sqlhuntingdog

    SSC Veteran

    Points: 269

    Hi,

    the basic tools are:

    SQL Server Management Studio (SSMS)- for designing and administering SQL Servers

    SQL Server Integration Service (SSIS) - probably to generate your datawarehouse

    SQL Server Reporting Service (SSRS) - to generate Reports

    please use free productivity tool for SSMS - SQL Hunting Dog [/url]

  • Alvin Ramard

    SSC-Forever

    Points: 41190

    If you took 30 minutes to leatn about SQL Server you would know how to answer this yourself.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Ed Wagner

    SSC Guru

    Points: 286958

    If you're making the move from Oracle to SQL Server, here are my thoughts on the major differences.

    1. SSMS is so much faster and more capable than Oracle Enterprise Manager, which is uber-slow.

    2. SSMS replaces both Enterprise Manager and SQLPlus.

    3. You cannot create packages in SQL Server.

    4. There's no tnsnames.ora or sqlplus.ora in SQL Server.

    5. There is no TO_CHAR.

    6. In PL/SQL development, you WANT to use cursors because of how they're handled in upper memory. In t-SQL, you DON'T want to use cursors because they're very slow. The numbers table approach is still a great way to go for set-based programming.

    7. I think you'll find .NET to be an order of magnitude better than Oracle Forms and Reports. I was very happy to say "goodbye" to them - they were powerful, but also excruciatingly painful.

    These are just the highlights and only represent my two cents, but the differences are many.

    HTH

  • PaulB-TheOneAndOnly

    SSC Guru

    Points: 66773

    Alvin Ramard (8/8/2013)


    If you took 30 minutes to leatn about SQL Server you would know how to answer this yourself.

    Don't worry, he knows nothing about Oracle either - thinks "data warehousing" is an Oracle tool.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply