Hello all,

I am trying to build, deploy, and the run another process against a Database all under one button.  The problem is that I don't know when the DeployMetaData is finished before moving on.

Is there a way for me to know that the process has finished from within c#?

As always thanks for the help

-Cory

Cory Cookson

Software Developer

Occupational Health Research

Hi Cory.

Would the DDT Profile Scripts be the case?

Have a look at the help file under the Database Deployment Toolkit / Profile Scripts. You can tell it to run Pre or Post Deployment.

If you are trying to do this all through T-SQL, then Ivan's suggestion of the Profile scripts may be helpful.  However, if you are just wanting to do something outside of the DDT altogether, and I assume that you are using the database Migrator, then there are events that tell you each phase of what is going on, including when the meta-data has been completed.  For a sample of these events, look at the Database Installer Sample.