locked
CaseWise RRS feed

  • Question

  • I am working with CaseWise and I have connected the database to SQL. How can I reverse engineer the ERD schema?

    Thanks, Peter

    Tuesday, August 3, 2010 4:06 PM

Answers

  • You can create a diagram in the GUI to start with.

    There you will get FK constraints. If this kind of logic is in the application instead, you can use profiler to capture sql statements, analyze theese and from there determine the relations between various tables.

    I don't know CaseWise explicitly, but these general tips will get you started.


    Regards Marten Rune Microsoft Certified IT Professional Database Administrator/Developer 2008
    Tuesday, August 3, 2010 4:40 PM