Multiple versions of a database

rbennet8

I find that it requires manual changes to the SQL packages built in SQL Packager to build an executable that will apply to all versions of a database. If there were a default SQL option that would allow for a if exists drop statement to be included when a create statement is required or an if exists statement when a drop statement is required, it would make packager more flexible. Currently it appears that you only get a create, drop, or alter statement and the only way to easily add an if exists is to overwrite the print statement before building the executable.

Brian Donahue

Hello,

Thanks for the comments. Packager always tries to alter schema rather than atomically removing it and replacing it.