add If not exists to data compare
Any way of adding If not exists to the data script output when comparing data.
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.