RE: Server Explorer & Databases

Hi Schneider,

As for the visual studio's database server explorer, SQL Server is the most
well integrated one as the development of the two product are in close
lifecycle so that visual studio can choose the best provider. However, for
oracle, visual studio generally use the OLD DB provider which is for Oracle
7, and support of most general funcctionalitis in latest version of Oracle.
Therefore, there does exists quite many features of new Oracle versions
that are not fully utilized via server explorer. The following MSDN
reference has also mentioned many information about the visual studio
designer tools support for orable databases(also mentioned something about
the database object's naming convention requirement...):

#Server Explorer for Oracle Databases
http://msdn.microsoft.com/en-us/library/aa290286(VS.71).aspx

#General Considerations for Using Visual Database Tools with Oracle
Databases
http://msdn.microsoft.com/en-us/library/aa290250(VS.71).aspx

In addition, I've found the following Orable deverloper tools for visual
studio from oracle site, that is declared to support the lastest Oracle
features and integrated with all the visual studio versions. You may have a
look:

#Oracle Developer Tools for Visual Studio
http://www.oracle.com/technology/tech/dotnet/tools/index.html

Hope this helps.

Sincerely,

Steven Cheng
Microsoft MSDN Online Support Lead


Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@xxxxxxxxxxxxxx

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
Reply-To: "eschneider" <eschneider@xxxxxxxxxxxxxxxx>
From: "eschneider" <eschneider@xxxxxxxxxxxxxxxx>
Subject: Server Explorer & Databases
Date: Mon, 16 Jun 2008 11:24:51 -0500


Hello,

Just curious; Does anyone really use this for databases?

I have used it for Sql Server some, create tables, Database diagrams (love
this), a lot of the cool stuff does not work with other providers.

There seems to be issues when using Oracle:
1. Unable to see objects which should visible by synonyms & schemas:
Yes they are listed in the synonyms node, but has no details, unless you
name things good, you can't even determine the object type.

The functionality for databases seems very limited to me...


I have been using PLSQL Developer for Oracle, and MS SQL Management Studio
for Sql Server.

I would like one tool which works well with all provides (or at lease Sql
Server & Oracle), don't think I have ever seen one, and the VS Server
Explorer does not even come close.

Thanks,
Schneider




.

Relevant Pages

  • SUMMARY: Hardening Solaris 8 with Oracle
    ... Oracle *not* offering a CLI install is a new trend. ... My reason for asking about Oracle Reports Server was a recent issue I ... # To Support X-Application need the LibC library ...
    (SunManagers)
  • US-PA: Newtown - Junior to Mid-Level Oracle DBA
    ... Inc. is seeking an experienced junior to mid-level Oracle DBA to support multiple highly available transactional and data warehouse databases underpinning a 24x7 global web services application. ... Position responsibilities consist of both operational and application support primarily in a Red Hat Linux environment. ...
    (comp.databases.oracle.marketplace)
  • US-PA: Philadelphia Area - Junior to Mid-Level Oracle DBA (FT Permanent)
    ... Inc. is seeking an experienced junior to mid-level Oracle DBA to support multiple highly available transactional and data warehouse databases underpinning a 24x7 global web services application. ... Position responsibilities consist of both operational and application support primarily in a Red Hat Linux environment. ...
    (comp.databases.oracle.marketplace)
  • Re: Perl and Oracle
    ... If you want to use sqlldr, ... MySQL then to fix the driver for Oracle. ... I believe that Tim favors open source databases and that DBI supports ... DBD::Pg seems to support array inserts the same ...
    (comp.databases.oracle.server)
  • Re: Server Explorer & Databases
    ... I did not know the Oracle addins, ... As for the visual studio's database server explorer, ... designer tools support for orable databases(also mentioned something about ... #Server Explorer for Oracle Databases ...
    (microsoft.public.vsnet.ide)