Wednesday, March 07, 2012 11:17 AM
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,
- Edited by Javier Cacho Wednesday, March 07, 2012 2:17 PM Correction
Friday, March 09, 2012 9:45 AMModerator
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:
Vicky Song [MSFT]
MSDN Community Support | Feedback to us
Friday, March 09, 2012 12:47 PM
Doing the comparison with schemas database works perfectly for me.
Thanks your much for your help and regards,