Recent

Author Topic: [External tool] DBLint to check your database design  (Read 1936 times)

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
[External tool] DBLint to check your database design
« on: April 02, 2012, 03:11:09 pm »
Just found this:
dblint.codeplex.com/

It's written in .Net and analyzes your database schema (and apparently data) for potential problems.

Just ran it on an MS SQL db, also runs on Firebird, PostgreSQL and more.

Only ran it on the one db which I thought was well designed; still it flagged some entirely valid issues.

Perhaps a nice thing to use when designing databases...

Oh, and it's open source, so if somebody wants to port it to the Lazarus Database Desktop ;)
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

JuhaManninen

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3865
  • I like bugs.
Re: [External tool] DBLint to check your database design
« Reply #1 on: April 02, 2012, 05:02:53 pm »
Just found this:
dblint.codeplex.com/
It's written in .Net and analyzes your database schema (and apparently data) for potential problems.
Just ran it on an MS SQL db, also runs on Firebird, PostgreSQL and more.

Looks interesting and useful.
In fact I will start a new work tomorrow, involving Delphi code and MSSQL DB.
I may need such a tool. Thanks for the link!

Juha
Mostly Lazarus trunk and FPC 3.2 on Manjaro Linux.

 

TinyPortal © 2005-2018