title: Unable to Publish SQL Server 2014 database using Web Deploy in VS 2013
body: <p>Its been quite sometime that I am trying to publish the data base for my website using webdeploy in VS 2013 but I keep getting the following error:</p>
  
  <blockquote>
    <p>Web deployment task failed. (Could not generate deployment script.<br>
    Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.Sql120DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid database platform service.</p>
  </blockquote>
  
  <p>I have tried installing the new updates. I am making sure that the local server is running during deployment. I have made sure that I enter the full server name rather than a dot. I have literally done everything that I could think of but to no avail. </p>
  
  <p>Can anyone help me, please?</p>