Cannot Write Updates when comparing Database Schemas

Question

Hello:

Whenever I try to compare the schemas of two databases, I obtain the message:

The version of the source and the target schema do not match. You can compare these schemas, but you cannot write updates to the target schema.

One of the databases, say A, is hosted in SQL Server 2005 and the other denoted by B, is hosted in  SQL Server 2008 R2.

B as originally a copy of A for development purposes using Script database as>CREATE TO from within SQL Server. The schema comparison from A to B works well, and the Write Updates is enabled and functional.

However, when I try to update the schemas from development, doing B to A comparison I obtain the error refered above.

What could be the problem and how can I solve it?

Thanks in advance and regards,

Javier Cacho

Answer 1

Hello Javier,

Just as the error message discribed above, you can't write updates after schema compare due to version dis-match. And one solution I can think out is that instead of directly compare two databases, you can create one database projects for it and then do schema compare between one database project and  a target database in the SQL Server.

Please also take a look at this case which may be helpful to you:

http://social.msdn.microsoft.com/Forums/eu/vstsdb/thread/15b2635f-432d-457a-a164-cdb4b11bcfe0

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Doing the comparison with schemas database works perfectly for me.

Thanks your much for your help and regards,

---

Javier Cacho