sql server - How can I store my Microsoft SQL Database_Diagram inside SSDT project? -
i'm using microsoft sql server data tools (ssdt), in projects try keep in order. wondering if know how store database diagram ssdt project, in order don't lose work , keep model updated team?
i tryed compare using schema, didn't exists. couldn't find database diagram in visual studio 2013.
am wrong try use model type? there better ways it? also, possible create jobs throught ssdt?
thank much,
the database diagrams stored in internal tables add definitions , include data in post deploy script but end deploying environments unusual (i don't know circumstance won't wrong!).
unless particularly needed diagrams in ssms else, redgate have database diagramming tool, prefer keep copy of visio 2010 pro generate them, vsd files can added project , shared between team.
i assume document databases if wanted editing , designer support diagrams other ways ssdt.
re: jobs, there no native object can create them in pre/post deploy scripts.
Comments
Post a Comment