Script generation in Visual Studio 2012 for a Database Project

Question

0.00/5 (No votes)

See more:

VS2012

Hi,
I m working in VS2012 for a Database project and i am generating deployment scripts for the same.
After generating scripts when i m executing those scripts in SQL Server then it is showing Below error :

ALTER TABLE [dbo].[ARC] DROP CONSTRAINT [DF__ARC__created_dt__2BC97F7C];
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.ARC" because it does not exist or you do not have permissions.

And when i m using below code it is working fine:
IF EXISTS (SELECT * FROM sysobjects WHERE name =[DF__ARC__created_dt__2BC97F7C];)
BEGIN
ALTER TABLE [dbo].[ARC] DROP CONSTRAINT [DF__ARC__created_dt__2BC97F7C];
END;

I want to generate scripts with "IF EXISTS" option automatically.
Is there any option to generate these scripts with above option automatically.
Please Suggest on the same.

Posted 5-Dec-13 23:19pm

rizziansari786

Updated 5-Dec-13 23:41pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2013-12-06T00:07:00

Solution 1

Check this

IF NOT EXISTS ( SELECT ‘thisPost’ ) CREATE POST thisPost AS[^]

Posted 6-Dec-13 0:07am

thatraja

Comments

rizziansari786 6-Dec-13 7:12am

Hi,
Thanks for your time. But I m not getting this.
Could you please provide this in detail.
In my Generated script there are large number of SQL statements like this.
I am searching for any option in VS2012, from where directly i could be able to apply "IF EXIST" statement with every SQL statement in entire script.

thatraja 6-Dec-13 7:30am

Did you read that page fully?
Check this line
/* In SSMS, go to Tools > Options > SQL Server Object Explorer > Scripting and look for the setting “Check for Object Existence” or “Include IF NOT EXISTS clause,” */

rizziansari786 6-Dec-13 8:10am

Hi,
I did as per your steps but still it is not working.
Throwing same error.

Is there any such option available in Visual studio 2012 while publishing scripts,like u told for SSMS.

thatraja 6-Dec-13 8:22am

please share more details, 'not working' won't help us. What's the error?