Schema errors

Apr 13, 2009 at 12:08 AM
Today, free SQL schema analysis tool was released named SqlTac Lite.  Running this onto a default KiGG database instance (itself running on SQL Server 2008) yielded many errors that should be reviewed, such as:

* StoryView and UserScore tables do not contain a Natural Key.
* KnownSource table PK has one or more segments which are not marked as identity/unique identifier.
* CommentSubscribtion and StoryMarkAsSpam tables contain a multiple segmented primary key.
* Id and UniqueName columns occur many times with one or more inconsistent definitions.
...and more

Would someone please take a look at this handy tool and consider using it for the next iteration?  Since this project is trying to go best practices, using all tools available will yield quantifiable results to the end result.

Thank you for this wonderful project!

mycall
Coordinator
Apr 15, 2009 at 3:09 PM
Sure anything for improving it, but would pls provide us the link.
Jun 7, 2009 at 11:27 AM

www.SqlTac.com