add If not exists to data compare
Any way of adding If not exists to the data script output when comparing data.
I too would love to see this. Right now, I take the script and split it in three parts:
a) Heading ALTERS
c) Trailing ALTERS
Then I execute a) and c) as block and split b) into lines, to be able to execute them ignoring errors,
Not nice but working ;-(
For such a simple request, it's mind-boggling that this has not been implemented, and is causing us to consider not buying your product.
without this feature automation seems a pain. Any progress on this?
Steve Haley commented
Would like this feature, Right now I'm having to go in to every INSERT INTO, and add a IF NOT EXISTS before each line. Use case: occasionally we distribute table entries "early" to select databases, but still want to include in main release scripts.
Also would be nice to have the "else" statement: if exists UPDATE the row with the values described in the INSERT
Tim Friesen commented
Would love to see this added. I manually have to add this to all deployment scripts I deploy.
Valthor Druzin commented
Any progress on this issue ?
Len Kalman commented
Just Checking Status on this request SDC-828.