December 10, 2007 at 2:32 pm
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.
February 24, 2008 at 2:11 pm
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
March 14, 2008 at 3:42 am
[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
August 8, 2013 at 7:30 am
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
August 8, 2013 at 8:17 am
If you took 30 minutes to leatn about SQL Server you would know how to answer this yourself.
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]
August 8, 2013 at 11:08 am
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
August 8, 2013 at 3:41 pm
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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply