InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumMon, 08 Jun 2026 22:31:39 GMT20http://forum.strataframe.net/FindPost10660.aspxI want to make sure I am clear on how DDT is intended to work and what to expect in certain scenarios.</P><P>If I have a SQL database MYDATABASE and I import this into a new DDT project MYPROJECT I would expect it to read all the structures, indexes, PKs etc ( if I have check the right boxes on the import wizard )</P><P>Now, I make changes in DDT and I deploy to the server.&nbsp; My changes are deployed.</P><P>Now the DBA makes some changes on the server.&nbsp; I want to keep my metadata in DDT in sync.&nbsp; If I import into the same project I get MYDATABASE_1 .&nbsp; Fair enough.&nbsp; I can now use that as the most current version of the metadata ( or use MYDATABASE to fix the server if the DBA has done something boneheaded. )</P><P>But I am not sure what is going on in the Strataframe database.&nbsp; If I create a new DDT project - MYPROJECT2 - and import the MYDATABASE, am I going to confuse any of the data stored in Strataframe?&nbsp; ie. are surrogate keys keeping all this straight?&nbsp; Suppose I import MYDATABASE into MYPROJECT2 and then deploy a changed version of it to MYDATABASE2 on the same server?&nbsp; </P><P>In other words, is there anything like this I have to be careful of when using DDT ?</P><P>TIAThu, 02 Aug 2007 09:28:54 GMTCharles R Hankeyhttp://forum.strataframe.net/FindPost10676.aspx[quote]In other words, is there anything like this I have to be careful of when using DDT ?[/quote]</P><P>No.&nbsp; The SF database does not rely on the name alone.&nbsp; It relies on the PKs of the profile (normalization :D).&nbsp; So you will not have any problems in the scenario that you described.&nbsp; In fact, we have a number of profiles with the same DB names and slightly different structures.Thu, 02 Aug 2007 09:28:54 GMTTrent L. Taylor