Visual Studio has had some support for SQL Server for quite some time, but that does not help the developers who are targeting Oracle. Fortunately Oracle has taken steps to address this by releasing Oracle Developer Tools for Visual Studio .NET.
Oracle promises seamless support for PL/SQL debugging, with the ability to "step from your .NET code into your PL/SQL stored procedure code and back out again."
Oracle also included a set of tools for managing Oracle databases from inside Visual Studio. Compared to the clumsy tools that ship with Oracle itself, these tools are quite impressive. But can it give Toad a run for its money?
The PL/SQL editor has full Intellisense support, something that Microsoft was not able to provide in its own SQL Server Management Studio. Being a professional grade add-in for Visual Studio, Oracle even thought to integrate their Help into the Microsoft Document Explorer.
One question remains, "When can expect deep DB2 and MySQL support for Visual Studio?"
Community comments
MySQL Tools for Visual Studio
by Steve Curry,
Re: MySQL Tools for Visual Studio
by Jonathan Allen,
DB2 Tools for Visual Studio
by Philip Nelson,
MySQL Tools for Visual Studio
by Steve Curry,
Your message is awaiting moderation. Thank you for participating in the discussion.
dev.mysql.com/downloads/visual-studio-plugin/in...
FYI ... On February 13, MySQL will present a webinar on MySQL Tools for Visual Studio: Designing data driven applications inside Visual Studio 2005
Re: MySQL Tools for Visual Studio
by Jonathan Allen,
Your message is awaiting moderation. Thank you for participating in the discussion.
Thanks for the tip, I'll try to get some more coverage of MySQL going.
Jonathan Allen
InfoQ
DB2 Tools for Visual Studio
by Philip Nelson,
Your message is awaiting moderation. Thank you for participating in the discussion.
I think you'll find that the DB2 support for Visual Studio has been there for quite some time. If I recall correctly, when the latest version of VS was released there wasn't even support for SQL Server, but the DB2 support was ready. Here's an article from July last year which covers some of the details.
www.databasejournal.com/features/db2/article.ph...
Basically you have the functionality you get in the standalone tools (e.g. Control Center) without having to leave VS.
HTH
Phil Nelson
ScotDB Limited
(teamdba@scotdb.com)