Photo of DanaS S


Data Model / Schema

Hi, all

How would I get the physical data model / schema of the underlying tables of Rock?  (I appreciate being able to see the listing of table & column info in the Model Map or via the SQL Map (plug in) in Power Tools, but an actual diagram showing the table relationships and fields would be very very helpful.)

Any advice?



  • Photo of DanaS S


    You can ask your DBA to provide you with a bacpac file of just the database schema (i.e. no data) and then import this file into a local instance of sql server using SSMS on your laptop.  This will create all the tables (empty... no data).  Then you can use the Database Diagrams functionality in SSMS to draw out selected tables.  You can also use system tables to query which tables have a particular column name.