Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Open Source and Free Software

(3,270 posts)

3. MS Access has a database designer

Thu Jun 28, 2012, 09:58 PM

Jun 2012

so you can graphically create a database in a convenient UI driven tool. Foreign keys are as easy as dragging a link between the two tables, and you can print out the schema in its graphical representation.

MS SQL has the same, but I don't think SQL Server Management Studio comes with the free Express version. There are some other options if you want to use MS SQL Express:
TOAD for SQL Server - http://toadforsqlserver.com/index.jspa
Versabanq Squel - http://versabanq.com/products/squel.php
LinqPad (if you are a .Net dev) - http://www.linqpad.net/
Query ExPlus - http://sourceforge.net/projects/queryexplus/
SQuirreL SQL - http://www.squirrelsql.org/index.php?page=screenshots

For MySQL you have a lot of options too:
MySql Control Center - http://sourceforge.net/projects/mysqlcc/?source=directory

There are many SQL CRUD procedure generators out there on both CodePlex and SourceForge.

Best of luck,
-CF

Edit history

Please sign in to view edit histories.

0 members have recommended this reply (displayed in chronological order):

3 replies

= new reply since forum marked as read

Highlight:

Database schema document creator [View all] Ruby the Liberal Jun 2012 OP

Couple of options... ChromeFoundry Jun 2012 #1

Thanks CF Ruby the Liberal Jun 2012 #2

MS Access has a database designer ChromeFoundry Jun 2012 #3