InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumMon, 08 Jun 2026 23:05:14 GMT20http://forum.strataframe.net/FindPost28764.aspxHi,<br/><br/><div>I would like to know whether the DDT is able to generate an SQL Script instead of a package with all the database changes?<br/><br/><div>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?<br/><br/><div>Thanks in anticipation,<br/>MelvinMon, 25 Oct 2010 17:47:33 GMTMelvin Xuerebhttp://forum.strataframe.net/FindPost28827.aspxCheers.Mon, 25 Oct 2010 17:47:33 GMTIvan George Borgeshttp://forum.strataframe.net/FindPost28808.aspxThanks mateMon, 25 Oct 2010 02:55:34 GMTMelvin Xuerebhttp://forum.strataframe.net/FindPost28784.aspxOK, 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.Thu, 21 Oct 2010 10:48:40 GMTIvan George Borgeshttp://forum.strataframe.net/FindPost28769.aspxHi Melvin.<br/><br/>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".<br/><br/>About rolling back on error, I am researching on that and will get back to you later.Thu, 21 Oct 2010 06:30:35 GMTIvan George Borges