why datadeploy Creates Tables automatically?

Hi All,

Im working with datadeploy, Im deploying data to different databases, one for Proof of Concept(POC) work and one for real dev work. I create some new tables for POC work, so those tables are only present in POC database, but while I was working on that POC, I deployed data to real dev database by mistake, I was waiting for an deployment failed message but I didnt get that. Checking tha database, I saw that datadeploy created the tables (the same structure of the POC database), I checked the documentation and I couldn't find anything regarding that behavior.

Is there a configuration that I should turn off or something like that to avoid that datadeploy creates the tables?

Attached is my config file.

Thanks!

Find more posts tagged with

Comments

praveen t n

I don't think there is an option to disable this feature. One thing you can do is to restrict the privileges to insert, select, update and delete for the dd user in database. That way, dd won't be able to create new objects!

regards,

Praveen

cmejiasr

Thanks for the answer Praveen,

Im wondering, If I restrict the privileges to insert, select, update and delete, dd wont be able to create the temp tables?

Im not sure about that..

thanks

praveen t n

You can restrict the privileges after all the temp tables are created. In your case, all temp tables got created. In other scenarios an initial test deployment can be run by a user with create privilege which will create all temp tables.

regards,

Praveen

Rick Poulin

kingsilvestre wrote:
You can restrict the privileges after all the temp tables are created. In your case, all temp tables got created. In other scenarios an initial test deployment can be run by a user with create privilege which will create all temp tables.

I'm gonna disagree there. In some circumstances dealing with (nested?) replicants, DD will still need to create and delete temp tables with unique identifiers.

I thought for sure there was a way to disable automatic schema creation. Have you looked through the documentation?

cmejiasr

Yes.. I checked the documentation, I found nothing about schema creation... Im using TeamSite 7.1.0.0.1, I checked the documentation for this version and also some documentacion for older versions, but I found nothing, maybe Im missing something but not sure!

Rick Poulin

Yeah I just checked myself.

Assuming the goal is for the deployment to fail if the target table does not exist (rather than creating it), then you might be able to use the sql override to force the CREATE TABLE to fail, by replacing it with something that doesn't do anything, e.g. <sql action="create">SELECT 1 FROM DUAL</sql> (as a child of your <database> element).

cmejiasr

This sounds good, I was looking for a config setting, but seems like there is nothing to enable/disable that, this hack could works.. Im gonna test it..

praveen t n

thank you rpoulin for the feedback, appreciate it!

Did you mean the base/delta tables? I got the situation where dd needs to delete & create these temp tables. Though I couldn't come up with a scenario where dd will delete the IWDelTracker table, which I guess is not the case.

thanks & regards,

Praveen

Rick Poulin

No, the "ID map" and deltracker probably won't get deleted ever.