![]() |
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. |
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.
|
|
If you come into some cash, red gate and idera do some cool stuff too. :)
|
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 |
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. |
Quote:
|
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 |
If you have Microsoft Visio, that can be used to reverse engineer a SQL Database.
|
Quote:
|
All times are GMT. The time now is 01:52 PM. |
Powered by vBulletin® - Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.