MauroDataMapper-Plugins / mdm-plugin-database-sqlserver

Apache License 2.0
2 stars 1 forks source link

Add source database name to profile on imported DataModel #35

Open joe-crawford opened 6 months ago

joe-crawford commented 6 months ago

For use in https://github.com/MauroDataMapper/mdm-standardisation, we should record the source database name in the Database profile on the imported DataModel.

pjmonks commented 6 months ago

One possibility for wider database metadata to record could be gleaned from the sys.databases system table, for example:

select 
    name, 
    database_id, 
    create_date, 
    compatibility_level, -- Gives the version of SQL Server installed on
    collation_name 
    -- ... and maybe other settings...
from 
    sys.databases