Errors when doing sync with "nested" Views

roedeske

Hello,

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

Brian Donahue

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.

roedeske

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]

roedeske

Hello Brian,

any other suggestion?

Regards,
Michael

Brian Donahue

Please see my 'how to enable parser debugging on my last post.

roedeske

Dear Brian,

now with version 5 the synchronisation works fine!

Thanks,
Michael

Brian Donahue

Hi Michael,

Good news there!