Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Relational Schema Conversion to Directed Graphs Expand / Collapse
Author
Message
Posted Wednesday, February 09, 2011 8:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 1:57 PM
Points: 3, Visits: 82
Hello Everyone,

I am working on a project in which I need to convert relational tables in MS SQL Server 2008 R2 into directed graphs.
The idea would be to translate the native format of the schemas in ASCII files containing table definitions
in SQL DDL into graphs with nodes being the tables names and column names, and directed edges for example, from a table to a column.

The format of the ASCII files could be:
CREATE TABLE dbo.Claim (
[ClaimKey] [int] NOT NULL,
[ClaimID] [nvarchar](5) NOT NULL,
[ClaimType] [nchar](10) NOT NULL,
[ClaimDescription] [nvarchar](20) NOT NULL)

A reference to Metadata Repository for Open Information Model existed in MS SQL Server 2000, but I have been unsuccessful in getting a solution for MS SQL Server 2008.

An urgent solution is earnestly needed.

Thank you.
Post #1061205
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse