What are the challenges you face when working across database platforms? Take the survey

Does an option exist to include an "If Not Exists" prior to inserting data?

We are using SQL Data Compare in an automated environment. We have updates that get released every 2 weeks, and a major upgrade every 3 months. We have meta data that we push every two weeks and we want to be able to push the release without having trouble with Insert statements. So far we have had the developers script out their additions to the meta data and we are trying to get away from that. 

Is there a way to prefix insert statements with an IF NOT EXISTS clause to prevent errors on upgrading our production databases?
Sign In or Register to comment.