CODEWITHSUNDEEP
c#sql-servervisual-studiodatabase-project
prestomanifesto
prestomanifesto

Reputation: 12796

Database Project Deployment Process

I am trying to understand how database projects work in Visual Studio. Here is what I have done so far:

  1. Created an SQL Express 2008 database in SQL Management Studio. (I can see the database and the tables in Server Explorer in Visual Studio)
  2. Created a database project in Visual Studio and imported the objects from the database I previously created.

Now I'm stuck, when I try to deploy changes I made in Visual Studio I get an error:

The file 'blah blah.mdf' cannot be overwritten. It is being used by database 'blah'

My end goal is to have the database in Visual Studio so I can add it under version control and deploy changes anyone in the team makes to the local database.

Upvotes: 2

Views: 734

Answers (1)

prestomanifesto
prestomanifesto

Reputation: 12796

Deleting the files under Schema Objects\Database Level Objects\Storage\Files fixed the error.

Upvotes: 3

Related Questions