StrataFrame Forum

Does DDT Generates SQL Script?

http://forum.strataframe.net/Topic28764.aspx

By Melvin Xuereb - 10/20/2010

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
By Ivan George Borges - 10/21/2010

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.
By Ivan George Borges - 10/21/2010

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.
By Melvin Xuereb - 10/24/2010

Thanks mate
By Ivan George Borges - 10/25/2010

Cheers.