User profile for urs.meili

it's ok for me. I discovered that the behaviour on the ALTER statements was very "weird", some of them will be considered, and some others won't. We will change our script sources to be consistent with V8. / comments

it's ok for me. I discovered that the behaviour on the ALTER statements was very "weird", some of them will be considered, and some others won't. We will change our script sources to be consiste...

0 votes

> as we do not deal with ALTER TABLE etc commands at all. this is also not true. We have lots of ALTER TABLE ... ADD CONSTRAINT commands in our scripts, and they work perfectly with SQL Compare 7.1. It is an absolute *must* that this type of commands still work with V8.0 / comments

> as we do not deal with ALTER TABLE etc commands at all. this is also not true. We have lots of ALTER TABLE ... ADD CONSTRAINT commands in our scripts, and they work perfectly with SQL Compare 7.1...

0 votes

Yes, indeed I would prefer 7.1 behaviour. The new behaviour means that our scripts suddenly don't work with SQL Compare anymore, as they used to do. Thus it means that 8.0 is not compatible with 7.1. This is a real "show-stopper" for us. / comments

Yes, indeed I would prefer 7.1 behaviour. The new behaviour means that our scripts suddenly don't work with SQL Compare anymore, as they used to do. Thus it means that 8.0 is not compatible with 7....

0 votes

The error is: "non-schema statement was ignored" on line 46. line 46 reads "ALTER VIEW..." the file in question is: /******************************************************************* <comment version="1.0"> <author>bi/sma</author> <date>21.06.2006</date> <summary> Fuer Adressetiketten. Liefert Name / Vorname des Lernenden, sowie die Institutionszeile1, Adresszeile1 und PLZ / Ort des Lehrbetriebs </summary> <remarks> FÃ¼r Bemerkungen ........ </remarks> <product> <std flag=""/> <fh flag=""/> <ms flag=""/> <bs flag="x"/> <ps flag=""/> </product> <multilanguage flag=""/> <encryption flag="x"/> <param name="Name 1...">Kommentar ...</param> <param name="Name 2...">Kommentar ...</param> <param name="Name 3...">Kommentar ...</param> <returns></returns> <performancehistory> <detail date="dd.mm.yyyy" Author="xxx">Beschreibung ...</detail>  </performancehistory> <changehistory> <detail date="04.07.2006" Author="sma">Institutionszeile1 und Adresszeile2 von Lehrbetrieb einfÃ¼gen</detail> <detail date="dd.mm.yyyy" Author="xxx">Beschreibung ...</detail>  </changehistory> </comment> *******************************************************************/ --CREATE VIEW dbo.qryBrn_Rpt_AdressetikettenLernendeMitLehrbetrieb AS ALTER VIEW dbo.qryBrn_Rpt_AdressetikettenLernendeMitLehrbetrieb WITH ENCRYPTION AS SELECT stu.idperson AS IDLernender, ISNULL(stu.PersonNachname,'') + ' ' + ISNULL(stu.PersonVorname, '') AS LernenderName, CASE WHEN ausbildner.PersonFirma2 IS NULL THEN ISNULL(ausbildner.PersonFirma1,'') ELSE ISNULL(ausbildner.PersonFirma1,'') + ' ' + ausbildner.PersonFirma2 END AS Institutionszeilen, ISNULL(ausbildner.PersonAdresse1,'') AS InstitutionAdresszeile1, ISNULL(ausbildner.PersonAdresse2, '') AS InstitutionsAdresszeile2, ISNULL(ausbildner.PersonPLZ,'') + ' ' + ISNULL(ausbildner.PersonOrt, '') AS AusbildnerPLZOrt FROM Person AS stu LEFT JOIN personengruppierung pg ON stu.idperson = pg.PGMitgliedIDPerson AND pg.IDPGTyp = 'AusbVerantw' LEFT JOIN person AS ausbildner ON pg.PGChefIDPerson = ausbildner.idperson / comments

The error is: "non-schema statement was ignored" on line 46. line 46 reads "ALTER VIEW..." the file in question is: /******************************************************************* <comment ve...

0 votes

this is not true. With SQL Compare 7.1, I have scripts which consist of ALTER VIEW statements. These will be included in the comparison with V7.1, but they are not in V8 / comments

this is not true. With SQL Compare 7.1, I have scripts which consist of ALTER VIEW statements. These will be included in the comparison with V7.1, but they are not in V8

0 votes

How can we help you today?

urs.meili

Comments