4

I am currently working on a build of a Solution with several Database Projects (Staging, Core, Business) in Visual Studio 2013. Unfortunately I get into troubles, when i have the same object in different projects.

Error:  SQL71508: The model already has an element that has the same name DIM.

As there are build dependencies, the first project will be able to CREATE the schema DIM. The second one will fail. Therefore a lot of errors will be thrown.

How am i able to solve this issue?

Esteban P.
  • 2,789
  • 2
  • 27
  • 43

1 Answers1

5

It was very confusing, but what finally solved my issue was:

  1. saving & closing the solution
  2. removing all *.dbmdl files (each project had one)
  3. reopening the solution

Reopening took a while, but finally those errors were gone. Function of DBMDL files

Esteban P.
  • 2,789
  • 2
  • 27
  • 43