SQL Modelling Tool

[MarillionFan]

Ok. I am after something very very specific.

I have a number of SQL Statements that have been sent to me.(no cursors just loads of joins etc).

I would like to paste each SQL statement into something that will then show be the relationship model with inner/outer/joins in a graphical format.

Thats it.

Anyone with any ideas because I will be buggered if I can find anything.

Oh and must be free or demo available.

 

[DimPrawn]

Wow that's a hard one isn't it?

I mean it's not like you have a visual query designer viewer in SQL Server is it?

http://msdn2.microsoft.com/en-us/library/ms172013(VS.80).aspx

Or even VS.NET 2005 Database Projects is it?

http://msdn.microsoft.com/library/d.../html/dvconquerydesignvisualdatabasetools.asp

Feck me you are a chancer.

 

[Spacecadet]

if its too complex, and it sounds like it probably is, then the modelling tool won't be able to parse it into a visual representation

 

[mashetti]

Wow that's a hard one isn't it?

I mean it's not like you have a visual query designer viewer in SQL Server is it?

http://msdn2.microsoft.com/en-us/library/ms172013(VS.80).aspx

Or even VS.NET 2005 Database Projects is it?

http://msdn.microsoft.com/library/d.../html/dvconquerydesignvisualdatabasetools.asp

Feck me you are a chancer.

Not sure about these ones you speak of but I think he actually wants something to reverse engineer the query into a data model... can these do that? There are plenty of visual ones out there to design, but to go the other way is quite different...

 

[Weltchy]

Ok. I am after something very very specific.

I have a number of SQL Statements that have been sent to me.(no cursors just loads of joins etc).

I would like to paste each SQL statement into something that will then show be the relationship model with inner/outer/joins in a graphical format.

Thats it.

Anyone with any ideas because I will be buggered if I can find anything.

Oh and must be free or demo available.

If the SQL is ansi-92 compliant then using any of the standard query designers that come out of the box with t-sql or p-sql will do what your after no problems. Christ, you could drop it into ms access and get that kind of info, tho no proper database guru would ever mention Access and SQL in the same sentence.

If your after a nice free tool however, check out http://www.toadsoft.com/.

 

[MarillionFan]

"I mean it's not like you have a visual query designer viewer in SQL Server is it?

http://msdn2.microsoft.com/en-us/li...013(VS.80).aspx"

The problem with trying to be clever DImprawn is you actually completey miss the point and never listen. Come across contractors like you all the time. Love the sound of your own voice.

I am attempting to reverse engineer complex SQL Statements not draw pretty diagrams from scratch. Sheesh.

Anyway I understand Visio for developers does it.

 

[MarillionFan]

"http://www.toadsoft.com/."

Toad couldnt do it either.

"If the SQL is ansi-92 compliant then using any of the standard query designers that come out of the box with t-sql or p-sql will do what your after no problems. Christ, you could drop it into ms access and get that kind of info, tho no proper database guru would ever mention Access and SQL in the same sentence."

Again. Somebody who doesnt know but offers a solution thinking theyre clever.

Bunch of Atws on here!

 

[MarillionFan]

"Not sure about these ones you speak of but I think he actually wants something to reverse engineer the query into a data model... can these do that? There are plenty of visual ones out there to design, but to go the other way is quite different..."

Only person who read this. Well done.

 

[_V_]

I think you'll find that SQL Server client and VS.NET 2005 tools allow you to paste in the SQL and it will draw the pretty diagrams and it allows you to draw pretty diagrams and it will generate the SQL.

PS. Never call someone an AtW, that is a very nasty thing to do.

 

[Weltchy]

"http://www.toadsoft.com/."

Toad couldnt do it either.

"If the SQL is ansi-92 compliant then using any of the standard query designers that come out of the box with t-sql or p-sql will do what your after no problems. Christ, you could drop it into ms access and get that kind of info, tho no proper database guru would ever mention Access and SQL in the same sentence."

Again. Somebody who doesnt know but offers a solution thinking theyre clever.

Bunch of Atws on here!

Actually, I think you'll find, as _V_ said, that SQL Query Designer will in fact take a raw SQL statement and drop it into a pretty relationship diagram at the top.

My question is, did you actually attempt to do this or just drop into 'Slag' mode automatically without giving it a reasonable attempt. As we appeared to be quite condescending, I will concede the latter part of the statement and apologise for it.

Now get off your lazy arsed contractor behind and do what they pay you to do and 'Work it out'

PS - Damn monday morning's always put me in a grouchy mood!!!!