How to use model diagram Manager ?

- be sure that your connection string is valid : e.g. if you use option 'use single con.string', you just have to put your mds database name after initial catalog, in 'single connection string' textbox

(and it should work if you use integrated security for your db in sql server) 

- using SSMS (SQL server management studio) :(drop and) create a new DB and name it MDSmodelling

- go back to MDS Manager and press red arrow button- if no error, you should have some tables created in MDSmodelling Db : just generate a model diagram of MDSmodelling with SSMS and you will see your graphical MDS model

-db tables generation can last a few minutes

example diagram generated from MDS sample model : customers



Last edited Jun 21, 2013 at 7:13 AM by xavave, version 1


No comments yet.