Activity overview
Latest activity by pandiani
TFS Configuration - how to install
For those that need to install the RedGate Source Control using a TFS server, you might find very helpful the following link.http://www.red-gate.com/supportcenter/C ... .0/toc.htm
Regards.
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...
Drop tables command on the script
Is there a way to request to DROP a Table or a StoredProc in case it exists as the MSSQL scripting engine does??
F
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
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."
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...
Comparing VIEWS returns error "Specified Cast is not valid"
The Compare STOPS and returns an error when it reads my only View.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [MSDW].[Branch_GetList]
AS
SELECT 1 as One FROM dbo.Branches
WHERE ...