add If not exists to data compare
Any way of adding If not exists to the data script output when comparing data.
This would be very useful for us. We deploy DB changes as Hotfixes and Service Packs. A Service Pack rolls up changes of all Hotfixes since the last Service Pack, so we manually have to add existance checks - almost defeats the main use-case for SQL Data Compare for us.
Please add existance checks.
I am in shock this does not exist. Freeware tools to script data changes can check if not exists.
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.