No Graphic Query Designer in Beta 2?
-
Just downloaded Beta 2. VERY surprised to find that Microsoft has left off the graphic query designer. No "open table" feature either (for those quick and dirty little edits)
How is this supposed to make things more productive? Sure, I can write T-SQL, but sometimes for complex joins it's nice to have this feature to keep my head from exploding!
Did Microsoft figure this was only for girly men???
Oh, yeah-- diagrams are gone, too.
Bryan
-
Hi Byran,
There is no Open Table funcitonlaity in Beta 2. However, they are reviewing whether it can be added in future beta/releases (not sure). But thats the news. This is a request from many of SQL developers. And you can always use the sqlwish@microsoft.com for such requests
.Moreover using of Open Table did have a pitfall, with open table interface so many users don't bother to put a primary key on the table. So you right-click, open table, and try to modify a row, guess what? SQL Server can't figure out which row to modify!! This is just one instance. You might have other valuable reasons to get that back. So surely you can write to sqlwish
.But that aside, even diagrams have been removed for a good reason stating Visio can do all the capabilities of what Diagrams gave you. Hence, you can understand why
. I have not used Visio and feel its a great tool with capabilities that DB Diagrams cannot extend to.Vinod Kumar (MVP-SQL Server)
-
Ooops, wanted to say. I have used Visio
Vinod Kumar
-
Maybe "I have not used Visio and feel its a great tool." would be more in tune with the marketing department
Seriously, tho', the diagrams take forever to show (especially if you just hit that line with the mouse by accident !) and, very often, show little or nothing in the cases where you really need them - where you're inheriting someone else's software. Try diagramming J.D. Edwards, for example (and go for tea whie waiting !).
Maybe MS should restrict the "open table" command to just keyed tables, or make unkeyed ones "read-only".
IMHO, more important would be making the Stored Procedure editor a normal window and not application-modal any more, s I can look in the table I'm writing about in the SP. Another SP editor improvement would be to insert a list of al the fields in a table, to save typing ...
Then again, if wishes brought dollars, I'd be rich by now ...
Mike
-
And of course we're all in the practice of not putting primary keys on tables! 🙂
About the diagrams-- I've only used it once to actually print out a diagram. I mainly use it graphically to create relationships.
I've been keeping an eye on the Beta newsgroup at Microsoft-- and it seems like there is a lot of sentiment out there to put these features back in (I know, I know, there were never removed because SQL 2005 is a complete redesign from scratch blah blah blah...)
I have other folks here at work who aren't as savvy at T-SQL, and convincing them to jump on the bandwagon is rough if all the niceties are gone.
Any word on when Beta 3 will be out?
Bryan
-
>> Any word on when Beta 3 will be out?
Somewhere end of this year.
Vinod Kumar
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply