Anyone know of a decent free DB schema reverse engineering tool?
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.
Andrew Lackenby
Updated on June 08, 2022Comments
-
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 almost 7 yearsWhat is the value of "last_run_time" that doesn't work? What specific error are you getting?
-
Johnny Mopp almost 7 yearsTry "hh" instead of "HH".
-
-
Andrew Lackenby almost 7 yearsThat works a treat. Thanks very much