SSMS 2012 - Data Only Script Generation With If Not Exists

Asked Feb 17 '15 at 11:07

Active Sep 22 '20 at 17:06

Viewed 657 times

I would like to generate a data only insert script within SSMS 2012 which contain the if not exists statements to make the scripts idempotent.

Right clicking the database I wish to generate the script for and selecting Tasks -> Generate Scripts the advanced scripting options within this wizard have been set as follows:

Setup of advanced options

When this wizard generates the SQL there are no IF NOT EXISTS checks:

INSERT [dbo].[Table] ([Column1], [Column2]) VALUES (N'Data1', N'Data2')

Am I missing something in the scripting options or is this not possible?

edited Sep 22 '20 at 17:06

ssilas777

9,672
4
45
68

asked Feb 17 '15 at 11:07

Jpin

1,527
5
18
27

have you found a solution yet? I am facing a similar issue. – nozzleman Feb 26 '15 at 06:07
@nozzleman I posted an answer to this problem. – AnotherDeveloper Jul 21 '15 at 22:01
@AnotherDeveloper I do not see your answer. Can you please share once again? – 439 Aug 29 '17 at 03:45

SSMS 2012 - Data Only Script Generation With If Not Exists

0 Answers0