Sql-server – Can we generate SQL Server MDS Model from an existing database schema

master-data-servicessql serversql-server-2016

I have googled this quite a bit and am surprised to not find an answer.

I'm considering using SQL Server MDS to manage our canonical schema, but I certainly don't want to key in my entire database schema to create the Model.

  • Does SQL Server MDS support creating a Model by reverse engineering a database?

Best Answer

Does SQL Server MDS support creating a Model by reverse engineering a database?

I wrote a command-line utility to do this, called MdsModelImport. It's intended to be a one-time import, and simply save you from having to type all the attributes.