Running SQL in Developer Studio
-
In Developer Studio Enterprise Architect you can run SQL scripts right from within the UI. In Dev Studio Professional, you can only run single statements in the query editor, and the "SQL View" completely re-formats the SQL each time you run it. My question is, is there any way to get Dev Studio Professional to let you run full SQL scripts (from an SQL file rather than from that query view) like in the Enterprise Architect version without upgrading to the higher version? Is there an expansion that Microsoft (or anyone else) might sell just to allow that one feature? Thanks! ~Steve (I posted this in the SQL forum too... hope noone's perturbed by my double-posting)
-
In Developer Studio Enterprise Architect you can run SQL scripts right from within the UI. In Dev Studio Professional, you can only run single statements in the query editor, and the "SQL View" completely re-formats the SQL each time you run it. My question is, is there any way to get Dev Studio Professional to let you run full SQL scripts (from an SQL file rather than from that query view) like in the Enterprise Architect version without upgrading to the higher version? Is there an expansion that Microsoft (or anyone else) might sell just to allow that one feature? Thanks! ~Steve (I posted this in the SQL forum too... hope noone's perturbed by my double-posting)
I do it all the time in VS.NET Professional. Create a Database project, add a script, add a connection (database reference), and then right-click on the script and select Run or Run On. The scripts I have are batch scripts that are very long and they run completely with no problems. This also works with views.
-----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----
-
I do it all the time in VS.NET Professional. Create a Database project, add a script, add a connection (database reference), and then right-click on the script and select Run or Run On. The scripts I have are batch scripts that are very long and they run completely with no problems. This also works with views.
-----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----
Thanks Heath, but what I really want to do is be able to edit the script and run it time and time again until I get it debugged without having to turn it into a stored procedure. I can't seem to do that. For example, I'd like to be able to load an SQL file from the harddrive and just run it straight away (no stored procedure), make changes in the text editor, and run it again, just like you can do in Query Analyser (the editor that ships with SQL Server). I even like to be able to select a portion of it and run only what's selected (again, possible in Query Analyser). All of this can be done in the Enterprise version of Dev Studio, but I can't figure out how to turn it on in the pro version... anyone with ideas (other than upgrading)? ~Steve