Solved

Are there logical database diagrams for Microsoft Dynamics SL 7.0?

Posted on 2008-10-08
5
756 Views
Last Modified: 2012-05-05
Are there logical database diagrams available for Microsoft Dynamics SL 7.0? I am interested in gaining a better understanding of how the database is laid out for reporting purposes, so hours are not wasted on determining where the data of interest resides in the database.
0
Comment
Question by:rdracer58
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 22675490
Hi,

You can use Visio for instance to "reverse engineer" the database and create your own diagram based on its structure.

HTH
  David
0
 

Author Comment

by:rdracer58
ID: 22678062
We already have laid out a very basic schema of the database using Visio and Word, however, I was wondering if there has been anything published along these lines?
0
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 22726398
M$ and your VARs won't really supply you with one. And none exist on the net that I know of. We have GP and M$ is of the viewpoint that messing with the DB directly without there advice and consent is bad juju.

Not what you want to hear, but.....
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 22730507
Sorry I couldn't be of more assistance. May all your days get brighter and brighter.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
T-SQL Query - Group By Year 3 29
SQL Syntax 6 41
add stored proc on publlication 4 20
SQL Query Across Multiple Tables - Help 5 20
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question