VS2010 failed to deploy SQLCLR on SQL Server 2012

I was experimenting SQL Server 2012 CLR with VS2010 I recently got. However, I ran into this version not supported issue:


Issue continued after I changed framework version.

After some research, I came across this link:

http://msdn.microsoft.com/en-us/data/hh297027

Once installation was completed, I restarted VS 2010. As soon as I open SqlServerProject1, there is a conversion screen poped up:


Of course I chose ‘Yes’ and conversion was done in seconds.

Interestingly, the ‘Deploy’ option doesn’t exist any more and there is a ‘Publish’ instead:


I had to setup database connection again here. Publish started after clicking ‘Publish’ button:


And the test ran successfully:


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s