InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 19 May 2026 13:08:14 GMT20http://forum.strataframe.net/FindPost32612.aspx<font color="#000000" face="Times New Roman" size="3"></font><p style="margin: 0in 0in 0pt;"><font color="#000000" face="Calibri" size="3">If I have 7 tables, 2 views and some stored procedures and a few functions. Iwant to add these to an existing database with different table names,different view names and different procedure names, different function names. Will the DDT package leavethe existing tables, views and procedures not defined in the package alone in the existing database? Orwill it delete them? If the default is to delete them, how do I change the default?</font></p><font color="#000000" face="Times New Roman" size="3"></font>Wed, 04 Jun 2014 08:52:34 GMTRoss L Rooker, Sr.(1)http://forum.strataframe.net/FindPost32613.aspxThe tables will merge, but the views, sprocs, and functions will be overwritten. &nbsp;The DDT puts an extended property on the sprocs, functions, and views that it deployed, so the DDT knows it can delete them. &nbsp;If you remove the extended property (called "DDT_Priority"), then the DDT will leave the old objects alone, assuming that an end-user added them to the database. &nbsp;However, when you go back to run the old DDT package, you'll need to swap over the DDT_Priority objects to the objects you want to overwrite. &nbsp;It can be done, but there would be some scripting involved to mark/unmark the objects you want to replace.<br/><br/><div>To script the extended properties: Check out 1) sys.fn_listextendedproperty, the UDF that retrieves the properties 2) sys.sp_addextendedproperty, sproc that adds extended properties 3) sys.sp_updateextendedproperty, sproc that updates the value on an existing property, and 4) sys.sp_deleteextendedproperty, sproc that removes an extended propertyWed, 04 Jun 2014 08:52:34 GMTStrataFrame Team