Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Equivalent SQL Server tools Expand / Collapse
Author
Message
Posted Monday, December 10, 2007 2:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 2, 2011 8:09 AM
Points: 6, Visits: 64
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.
Post #431539
Posted Sunday, February 24, 2008 2:11 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 25, 2010 6:09 AM
Points: 1,621, Visits: 409
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


Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers



Post #459538
Posted Friday, March 14, 2008 3:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:09 AM
Points: 25, Visits: 537
[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
Post #469252
Posted Thursday, August 8, 2013 7:30 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, September 7, 2013 6:50 AM
Points: 11, Visits: 24
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
Post #1482321
Posted Thursday, August 8, 2013 8:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:41 PM
Points: 1,410, Visits: 8,095

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




Alvin Ramard
Memphis PASS Chapter

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.
Post #1482354
Posted Thursday, August 8, 2013 11:08 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:50 PM
Points: 3,971, Visits: 3,409
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



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1482482
Posted Thursday, August 8, 2013 3:41 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
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.
Post #1482590
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse