title: Using VS2012's SQL Server Data Tools without VIEW DEFINITIONS permission
body: <p>I am trying to compare two databases using Visual Studio 2012. However, the SQL instance where my database is being hosted is extremely locked down and my user does not have access to the VIEW DEFINITIONS permission.</p>
  
  <p>I'm getting these errors in Visual Studio:</p>
  
  <p><code>The target database schema could not be retrieved. The reverse engineering operation cannot continue because you do not have View Any Definition permission on the server '(URL here)'.</code></p>
  
  <p><code>Comparing the master database requires VIEW ANY DEFINITION permission.</code></p>
  
  <p>But yet, I can use tools like Red-Gate SQL Compare and XSQL to compare the databases. I don't want to purchase this software and I rather use Visual Studio 2012 because I already have a license... How can I overcome this problem? Is there any way I can use SQL Server Data Tools without VIEW ANY DEFINITION permission?</p>