StrataFrame Forum

Automate DDT to import database

http://forum.strataframe.net/Topic18778.aspx

By Chan - 8/26/2008

Hi,

I am using xcase database diagramming tool to design my database instead of using DDT. However, I want to use DDT as database deployment toolkit to deploy/upgrade database at customer site. Therefore, I would like to :-



1. Design at xcase

2. Create clean SQL database using xcase.

3. Import database to DDT

4. Build DDT package

5. Run installation build.



I want to automate the whole process. My question is, how could I automate step 3 and 4?



Thank you
By Dustin Taylor - 8/27/2008

There isn't any way to automate step 3 (other than building the database schema in the DDT to start with, of course Smile).

You can automate step 4 using the command line capabilities of the DDT.  Whenever you deploy a package, it shows you the command line build text used to create that build.  You coud call that command from within any automated build procedure to "refresh" your DDT package before deployment. This is what we do during our own build process to ensure the most recent DDT schema and contents always get deployed.