Comments
Sort by recent activity
David,
We all understand this might not be part of the purpose of the tool itself, but I think you should reconsider it as we the uses might expand the usage of the tool outside the initial scope of the intended way ...
Filippo / comments
David,
We all understand this might not be part of the purpose of the tool itself, but I think you should reconsider it as we the uses might expand the usage of the tool outside the initial scope o...
I fix the issue by delete the schema and recreating it using something like
CREATE SCHEMA [MSDW]
AUTHORIZATION [dbo]
GO
Now SQLCompare works perfectly.
Thanks,
Filippo / comments
I fix the issue by delete the schema and recreating it using something like
CREATE SCHEMA [MSDW]
AUTHORIZATION [dbo]
GO
Now SQLCompare works perfectly.
Thanks,
Filippo
Jonathan,
Unforntunately I cannot send you the DB schema (for obvious reasons).
The user is SA, and the only thing that comes to mind is that we have 2 schemas on the DB (dbo & MSDW). The views are running under the schema MSDW and they refer to some dbo tables.
Other than that, I don't know.
When I remove the view, it works.
If I change the view to "select * from table1" it also fails, so that's why I think the issue could be that it runs under a different SCHEMA.
Let me know,
filippo / comments
Jonathan,
Unforntunately I cannot send you the DB schema (for obvious reasons).
The user is SA, and the only thing that comes to mind is that we have 2 schemas on the DB (dbo & MSDW). The views are...
Sorry,
I forgot to state the error message.
>>> "Specified cast is not valid." / comments
Sorry,
I forgot to state the error message.
>>> "Specified cast is not valid."