2

I've created a database project and several databases projects that reference that project. I would like to use VS2008 Schema Compare to compare the schema of one of the databases to my development database.

So far, so good. But when I check the result, it says it will skip all references!?

Screen shot schema compare

Question: How can I include the referenced database into my compare?

Ps. Comparing the "base" database first and then the other database won't work either, because it will result in drops.

Kees C. Bakker
  • 32,294
  • 27
  • 115
  • 203

2 Answers2

1

Each project must be compared individually. More info about pros and cons here. Hopefully it will be better in the future...

Kees C. Bakker
  • 32,294
  • 27
  • 115
  • 203
0

According to the MSDN page on "Compare and Synchronize Database Schemas" the meaning of Skip Referenced is

The object exists in a referenced database and does not need to be dropped or created

That basically means that those objects already exist in the database and won't be created or deleted, they're unchanged.

Karel Frajták
  • 4,389
  • 1
  • 23
  • 34
  • This is not true. In my example there is a referenced stored procedure missing and this procedure needs to be created. Yet... this procedure isn't even mentioned. But what I want to do is compare both databases. – Kees C. Bakker Sep 20 '11 at 08:52
  • 1
    Can you remove the answer? It being no answer at all? – Kees C. Bakker Sep 20 '11 at 09:38
  • For better understanding please send screenshots the structure of your databases. Which stored procedure is it? – Karel Frajták Sep 20 '11 at 09:46