Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Visual Studio DB project: model already has an element that has the same name

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?

like image 929
Esteban P. Avatar asked Sep 06 '25 22:09

Esteban P.


1 Answers

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

like image 193
Esteban P. Avatar answered Sep 09 '25 10:09

Esteban P.