Anyone know of a decent free DB schema reverse engineering tool?

57

Solution 1

Check out SQuirreL.

You need to right click the table and choose the option, 'Add to Graph'. Then it will open a new tab. After switching to that tab you will see the table represented in a box. Just right click the box and select 'Add all children', and 'Add all Parent'. It will include the complete hierarchy, with the Entity, and Relationships. So, you can say it would generate an ERD.

Hope this would help.

Solution 2

If you have Microsoft Visio Professional, there is an built-in feature you can use to reverse engineer an existing database. You need to use the appropriate driver supplied by Visio. It also allows you to select which tables you want in the reverse engineered database model.

Please check http://office.microsoft.com/en-us/visio-help/reverse-engineer-an-existing-database-into-a-database-model-HA010115485.aspx

Share:
57
Andrew Lackenby
Author by

Andrew Lackenby

Updated on June 08, 2022

Comments

  • Andrew Lackenby
    Andrew Lackenby over 1 year

    I'm trying to read in 2 columns from a DataTable that will give me a date and time.

    I've tried the line of code:

    lastRun = DateTime.ParseExact(row["last_run_date"].ToString(), "yyyyMMdd", CultureInfo.InvariantCulture)
    .Add(TimeSpan.ParseExact(row["last_run_time"].ToString().PadLeft(6, '0'), "HHmmss", CultureInfo.InvariantCulture));
    

    The last_run_date part works OK but the time will not parse correctly.

    • juharr
      juharr almost 7 years
      What is the value of "last_run_time" that doesn't work? What specific error are you getting?
    • Johnny Mopp
      Johnny Mopp almost 7 years
      Try "hh" instead of "HH".
  • Andrew Lackenby
    Andrew Lackenby almost 7 years
    That works a treat. Thanks very much