Comments
6 comments
-
Hello Michael,
It sounds possibly like the view is schemabound to another view. Have you got the 'include dependencies' option on? Possibly it's just a matter of getting SQL Compare to automatically script the dependent objects first. -
Dear Brian,
yes both mentioned views are schemabound. The setting "dependencies" was checked as true. I didnt find a way to upload a screenshot. For workaround I deleted all views in the target so all were newly generated, but a real compare would be nicer.
Regards,
Michael[/img] -
Hello Brian,
any other suggestion?
Regards,
Michael -
Please see my 'how to enable parser debugging on my last post.
-
Dear Brian,
now with version 5 the synchronisation works fine!
Thanks,
Michael -
Hi Michael,
Good news there!
Add comment
Please sign in to leave a comment.
I get the following error when trying to da a db sync:
Die folgende Fehlermeldung wurde vom SQL Server zurückgegeben:[3729] Cannot ALTER 'dbo.V_Rechte' because it is being referenced by object 'V_Ben2LE_D'.
Der folgende SQL-Befehl verursachte den Fehler:
ALTER VIEW dbo.V_Rechte AS
SELECT
Name_de,
Name_en,
OrgEbene_D,
KoStEbene_D,
MA_Ebene_D,
GB_UB_Ebene_Welt,
GeschaeftsfeldEbene_Welt,
KonzernSicht_D,
BereichsSicht_D,
KonzernSicht_Welt,
BereichsSicht_Welt,
AdHocAnfrageRecht,
ReportingRecht,
RepFreigabeRecht,
IntRepGenehmigungRecht,
NatRepGenehmigungRecht,
b2g.BenutzerID AS BenutzerID
FROM dbo.Sys_Benutzer2Gruppe b2g
INNER JOIN dbo.Sys_Gruppen g ON b2g.GruppenID = g.GruppenID
I have marked to include referenced objects, still the same errormessage. Any suggestions?
I'am using version 4.10.0.0
Michael