I imagine by "foreign keys" do you mean via constraints or triggers?
For the Triggers and UDFs, if we put those into a SQL Script, is there a document somewhere that can explain to us how to run those in a post-update process?
Lastly, I remember from the Amarillo class, that the entire DDT is stored in SQL Server. Is the database documented somewhere enough to allow us to figure out how to "import" the remaining items rather than entering them by hand?
Or, is someone working on a "xCase" synchronization add-in tool?
Dan Neuman
I'm not sure we have any documentation on how to deploy additional scripts after the deployment process. You cannot do it directly through the "Deploy to Server" button in the DDT, but if you use the MicroFour StrataFrame DBEngine DLL (the one tht deploys DDT packages programmatically), you can programmatically execute the script as soon as the deployment process has completed.
As for the documentation on the DDT table structures, there isn't any... mainly because we don't release the source code for the DDT. However, the names are very straightforward and if you have any questions regarding the table structure and what pieces are requied where, I'm sure I can answer them.