Error While Updating .mdf Database

Following errors occurred while updating an .mdf database, it was working fine but before editing the Column Names of few tables. (I am using Server Explorer of Visual Studio 2013.

Solution 1:

1. To make these changes, either perform them manually using SQL Server Management Studio or use Visual Studio Professional (or above) to perform a Schema Compare and select the option to ignore the possibility of data loss.

2. The TSD01234 error is also caused by having the "Verify Deployment" setting checked in your project's .sqlDeployment file (it is the last one under "advanced options").

3. Explicitly name the columns in the view. Deployment doesn't like wildcards.

Solution 2:

Try this:

Go to Tools menu -> Options -> Database Tools -> Table and Database Designers ( -> Table and Diagram Options) -> Untick/UnselectPrevent saving changes that require table re-creation.

This is as of VS2010, but it should not be much different in VS2013.