Does DDT Generates SQL Script?

StrataFrame Forum

Back

Does DDT Generates SQL Script?

Author	Message
Melvin Xuereb	Melvin Xuereb posted 14 Years Ago Topic Details Share Topic
Group: Forum Members Posts: 29, Visits: 128	Hi, I would like to know whether the DDT is able to generate an SQL Script instead of a package with all the database changes? Also, Is there someway to control the package while deploying it? What happens if a package gives an error while deploying? Is it possible to have a rollback on error? Thanks in anticipation, Melvin
	Reply Like 0
Ivan George Borges	Ivan George Borges posted 14 Years Ago Post Details Share Post
Group: StrataFrame MVPs Posts: 1.9K, Visits: 21K	Hi Melvin. No, the DDT is not meant to produce SQL Scripts. But if your need would be to produce the script so you could change it and insert some code, you could insert your script inside the DDT, which has Pre and Post deployment scripts possibilities. Have a look at the help file under "Database Deployment Toolkit" / "Profile Scripts". About rolling back on error, I am researching on that and will get back to you later.
	Reply Like 0
Ivan George Borges	Ivan George Borges posted 14 Years Ago Post Details Share Post
Group: StrataFrame MVPs Posts: 1.9K, Visits: 21K	OK, I couldn't find a logical way to "snapshot" the structures prior to deployment. If you are concerned about it, as most people are prior to a deployment, your best bet would be to backup the database. This would be the only way.
	Reply Like 0
Melvin Xuereb	Melvin Xuereb posted 14 Years Ago Post Details Share Post
Group: Forum Members Posts: 29, Visits: 128	Thanks mate
	Reply Like 0
Ivan George Borges	Ivan George Borges posted 14 Years Ago Post Details Share Post
Group: StrataFrame MVPs Posts: 1.9K, Visits: 21K	Cheers.
	Reply Like 0