Hi,

I have questions as below:



1. How could I allow user to decide database name during DDT deployment?

2. I have some view that join tables from local and remote database. The remote database name could be vary among customer even though it is has the same structure. How could I tell DDT at runtime so that it will "change" my view defination to map to the remote database?



Please advice.



Thank you

Hi,

Hmmm... the reason to use .NET code in my case is not to execute something at SQL Server. Instead, during DDT deployment process. In order words, I would like to have custom logic during deployment database.



Any ideas?



Thank you

Well, at this point there is not anything like that from directly within the DDT.  That is why this thread was filled with some good ideas to use DDT variables (which don't presently exist) so that you can manipulate this at the time of deployment and add your own logic.  There are a lot of good ideas here.  However, at the moment, you could still create a CLR sproc that is deployed using the standard DDT logic and then executed as a post deployment script.  You could then use that CLR sproc to update any other elements that need updating.