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.