Tool to QA SqlServer or Oracle database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eschneider - 08 Jul 2008 19:18 GMT

Hello,

Does anyone know of any tools which perform various design, best practice
checks on a database?
Something that looks at the schema, table definitions, internal procedures /
functions.

Something similar to FxCop but for databases.
FxCop shows all the Rules and definitions, and also allows users to disable
specific rules.

Support for Sql Server and Oracle is desired.

Thanks,

Schneider

Reply to this Message

Alan Brewer [MSFT] - 09 Jul 2008 03:39 GMT

There is a SQL Server 2005 Best Practices Analyzer at:
http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA
-F0E3FBD05E63&displaylang=en

Signature

Alan Brewer [MSFT]
SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

eschneider - 09 Jul 2008 20:33 GMT

That seems to be for the Server environment & Configuration, not the design
of the database.

But thanks, I will check it out also.

Schneider

> There is a SQL Server 2005 Best Practices Analyzer at:
> http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA
-F0E3FBD05E63&displaylang=en

Reply to this Message

Ekrem Önsoy - 10 Jul 2008 09:10 GMT

I can suggest you Database Engine Tuning Advisor which is a Performance Tool
of SQL Server, it comes with Standard and Enterprise Editions of SQL Server
2005.

There is also equivalent of this tool in SQL Server 2000.

It'll assess your indexes according to some workload files and then suggest
you changes on existed indexes, or it'll suggest you to create new indexes
or to drop some existed ones.

Signature

Ekrem Önsoy

> That seems to be for the Server environment & Configuration, not the
> design of the database.
[quoted text clipped - 5 lines]
>> There is a SQL Server 2005 Best Practices Analyzer at:
>> http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA
-F0E3FBD05E63&displaylang=en

Reply to this Message

Jean-Pierre Gutsatz (DMC) - 14 Jul 2008 11:41 GMT

Hello,

Maybe take a look at DMC : www.dmc-fr.com

It will read all SQL and Oracle (and more) Tables

let me know if I can help more... :)

Signature

Thank you

Cordialement - Best regards
Jean-Pierre GUTSATZ

CGF
32 Rue Jean Moulin
34 630 Saint-Thibéry
Tel : (33) 467 322 167
Fax : (33) 1 5301 4749

DMC - Data Management Center - A tool to let you Migrate Import Export
Transfer all your Data very easily
www.dmc-fr.com cgf@dmc-fr.com
Certified by Microsoft : "Works with Vista" & "Works with Windows Server
2008"

> Hello,
>
[quoted text clipped - 12 lines]
>
> Schneider

Reply to this Message