InstantForum.NET v4.1.4StrataFrame Forumhttp://forum.strataframe.net/forum@strataframe.netFri, 21 Nov 2008 18:53:50 GMT20http://forum.strataframe.net/Topic10660-13-1.aspx[quote]In other words, is there anything like this I have to be careful of when using DDT ?[/quote]</P><P>No. The SF database does not rely on the name alone. It relies on the PKs of the profile (normalization :D). So you will not have any problems in the scenario that you described. 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. Taylorhttp://forum.strataframe.net/Topic10660-13-1.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. My changes are deployed.</P><P>Now the DBA makes some changes on the server. I want to keep my metadata in DDT in sync. If I import into the same project I get MYDATABASE_1 . Fair enough. 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. If I create a new DDT project - MYPROJECT2 - and import the MYDATABASE, am I going to confuse any of the data stored in Strataframe? ie. are surrogate keys keeping all this straight? Suppose I import MYDATABASE into MYPROJECT2 and then deploy a changed version of it to MYDATABASE2 on the same server? </P><P>In other words, is there anything like this I have to be careful of when using DDT ?</P><P>TIAWed, 01 Aug 2007 10:55:28 GMTCharles R Hankey