SQL Server Schema viewer? - SV650.org

timwilky · 02-02-06, 02:21 PM

Can somebody recommend a good free tool to browse a Microsoft SQLServer schema. I seem have inherited responsibility for a crap app that uses SQLServer (Where is the spit emoticon?)and want to build some decent reports from the stored data instead of the limited stuff available from the app.

I have grown up with Oracle and MySQL and now have to fight the dark side. At present I just need to browse and attempt to work out where my required data is. Then I get my Java toolkit out and knife and fork it.

TSM · 02-02-06, 02:22 PM

Microsoft Query Analyser is good enough (Comes with SQL Server or MSDE SQL), it will also tell you the cost of a query and all its parts so you can optimise it.

02-02-06, 02:28 PM

I have used this free tool in the past to view SQL Data

http://www.asql.biz/DbaMgr.shtm

02-02-06, 02:32 PM

If you come into some cash, red gate and idera do some cool stuff too.

timwilky · 02-02-06, 03:15 PM

What do I want to achieve?

I want to visualise the available schema. See what tables exists and fields within. view constraints. then to drill down on the data.

The app authors refuse to provide a schema definition as they say it is their intellectual property and are supprised that we do not wish to buy their reporting tools

TSM · 02-02-06, 03:19 PM

If you have access to the SQL server, there is a tool with the MGMT console to create a relation table and show you all the links etc...

You can also just link to the SQL server with MS Access (Access Project) and it will also give you all the DB information.

timwilky · 02-02-06, 03:50 PM

Quote:

Originally Posted by TSM

If you have access to the SQL server, there is a tool with the MGMT console to create a relation table and show you all the links etc...

You can also just link to the SQL server with MS Access (Access Project) and it will also give you all the DB information.

Thanks for the heads up on this. Diagram creation is taking place. only 170 tables so a small DB. will I get a traditional ERD?

02-02-06, 04:05 PM

I sort of like MSSQL with query analyzer.

It's not as cool as MySQL console, but it's very nice!
And now im used to it, so i prefer it

13-04-06, 10:13 PM

If you have Microsoft Visio, that can be used to reverse engineer a SQL Database.

13-04-06, 10:16 PM

Quote:

Originally Posted by localhost

I sort of like MSSQL with query analyzer.

It's not as cool as MySQL console, but it's very nice!
And now im used to it, so i prefer it

lies, lies! mySQL is friggin awful..

02-02-06, 02:21 PM	#1
timwilky Member Mega Poster Join Date: Mar 2004 Location: Not in Yorkshire. (Thank God) Posts: 4,116	SQL Server Schema viewer? Can somebody recommend a good free tool to browse a Microsoft SQLServer schema. I seem have inherited responsibility for a crap app that uses SQLServer (Where is the spit emoticon?)and want to build some decent reports from the stored data instead of the limited stuff available from the app. I have grown up with Oracle and MySQL and now have to fight the dark side. At present I just need to browse and attempt to work out where my required data is. Then I get my Java toolkit out and knife and fork it. __________________ Not Grumpy, opinionated.

02-02-06, 02:22 PM	#2
TSM The Sick Man Mega Poster Join Date: Nov 2004 Location: Peckham.SE.LDN Posts: 4,768	Microsoft Query Analyser is good enough (Comes with SQL Server or MSDE SQL), it will also tell you the cost of a query and all its parts so you can optimise it. __________________ OTR: KTM 690 Duke R 2015 Full Akro SIDELINE: Kwak ZX636 A1P 2002, Red, R&G's, Yoshi, Double Bubble Screen GONE: Kwak ZX-7R P1, Full Akro, Undertray, Screen GONE: SV650S K2 Very Bruised & Without Fairing, Motovation Frame Sliders, R&G Ally Sprocket Toe Protector, HEL 2 Line Setup, GSXR K1 600 RWU Forks, Barnett Clutch & Springs, Penske 8981 Shock, Gilles Ti Rearsets, Steel Barends, Scottoiler, AFAM Chain & Sprockets, Twin FIAMM Horns, Skidmarx Bellypan, Full Micron Zeta Steel System, Cut down undertay. Forum Problems & Information / Site Suggestions

02-02-06, 03:15 PM	#5
timwilky Member Mega Poster Join Date: Mar 2004 Location: Not in Yorkshire. (Thank God) Posts: 4,116	What do I want to achieve? I want to visualise the available schema. See what tables exists and fields within. view constraints. then to drill down on the data. The app authors refuse to provide a schema definition as they say it is their intellectual property and are supprised that we do not wish to buy their reporting tools __________________ Not Grumpy, opinionated.

02-02-06, 03:19 PM	#6
TSM The Sick Man Mega Poster Join Date: Nov 2004 Location: Peckham.SE.LDN Posts: 4,768	If you have access to the SQL server, there is a tool with the MGMT console to create a relation table and show you all the links etc... You can also just link to the SQL server with MS Access (Access Project) and it will also give you all the DB information. __________________ OTR: KTM 690 Duke R 2015 Full Akro SIDELINE: Kwak ZX636 A1P 2002, Red, R&G's, Yoshi, Double Bubble Screen GONE: Kwak ZX-7R P1, Full Akro, Undertray, Screen GONE: SV650S K2 Very Bruised & Without Fairing, Motovation Frame Sliders, R&G Ally Sprocket Toe Protector, HEL 2 Line Setup, GSXR K1 600 RWU Forks, Barnett Clutch & Springs, Penske 8981 Shock, Gilles Ti Rearsets, Steel Barends, Scottoiler, AFAM Chain & Sprockets, Twin FIAMM Horns, Skidmarx Bellypan, Full Micron Zeta Steel System, Cut down undertay. Forum Problems & Information / Site Suggestions

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL server	Gnan	Idle Banter	2	31-05-06 05:40 AM
SQL server and VB	mysteryjimbo	Idle Banter	10	18-03-06 09:02 AM

02-02-06, 02:28 PM	#3
Iceman Guest Posts: n/a	I have used this free tool in the past to view SQL Data http://www.asql.biz/DbaMgr.shtm

02-02-06, 02:32 PM	#4
mysteryjimbo Guest Posts: n/a	If you come into some cash, red gate and idera do some cool stuff too.

02-02-06, 04:05 PM	#8
localhost Guest Posts: n/a	I sort of like MSSQL with query analyzer. It's not as cool as MySQL console, but it's very nice! And now im used to it, so i prefer it

13-04-06, 10:13 PM	#9
RichMercer Guest Posts: n/a	If you have Microsoft Visio, that can be used to reverse engineer a SQL Database.