How can we help you today? How can we help you today?
alex_sefrin
Activity overview Badges (0) Posts (3) Comments (6)

Comments

Sort by recent activity
Thanks, that will solve my problems! / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Orderd Data Compare?
Thanks, that will solve my problems!
0 votes
Hi Matthew, my tables have some delete triggers and they fire if I try to delete them in the wrong order. Kind regards, Alex / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Orderd Data Compare?
Hi Matthew, my tables have some delete triggers and they fire if I try to delete them in the wrong order. Kind regards, Alex
0 votes
Putting the old version of System.threading.dll in the GAC solved the Problem. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. SQLDataCompare.Engine needs System.Threading.dll
Putting the old version of System.threading.dll in the GAC solved the Problem.
0 votes
Hi Eddie, the problem is, that the RedGate.SQLDataCompare.Engine needs the old version of System.Threading.Dll (1.0.2856.102) in the same directory, on a machine with .Net Framework 4.0. I'm not sure if .Net Framework 3.5 had this old dll. For my local tests I found a workaround. I create an app.config <?xml version="1.0" encoding="utf-8" ?> <configuration> <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIdentity name="System.Threading" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-1.0.2856.102" newVersion="4.0.30319.34209" /> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="System.Threading.Tasks" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-1.0.2856.102" newVersion="4.0.30319.34209" /> </dependentAssembly> </assemblyBinding> </runtime> </configuration> For the tests which are started by a nightly build, this solution didn't work because the app.config is disregarded by the build. Best regard, Alex / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. SQLDataCompare.Engine needs System.Threading.dll
Hi Eddie, the problem is, that the RedGate.SQLDataCompare.Engine needs the old version of System.Threading.Dll (1.0.2856.102) in the same directory, on a machine with .Net Framework 4.0. I'm not su...
0 votes
Collation is Latin1_General_CI_AS for both databases. Another problem is that in some statements the square brakets are missing now. new CREATE TRIGGER [dbo].[Adressen_Delete] ON dbo.Adressen FOR DELETE AS old CREATE TRIGGER [dbo].[Adressen_Delete] ON [dbo].[Adressen] FOR DELETE AS Re missing N: The N isn't missing on all ext. prop. I can't find a rule when it is missing. -- Extended Properties EXEC sp_addextendedproperty N'MS_Description', '0 = nicht speichern', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'AdressHistorieJN' GO EXEC sp_addextendedproperty N'MS_Description', N'Datum, an dem diese Adresse erstmals erfasst wurde', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'AnlageDatum' GO EXEC sp_addextendedproperty N'MS_Description', N'Ist diese Adresse eine Filiale?', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Filiale' GO EXEC sp_addextendedproperty N'MS_Description', 'weitere Gruppenzugehörigkeit (frei)', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Gruppe1' GO EXEC sp_addextendedproperty N'MS_Description', 'weitere Gruppenzugehörigkeit (frei)', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Gruppe2' GO EXEC sp_addextendedproperty N'MS_Description', 'weitere Gruppenzugehörigkeit (frei)', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Gruppe3' GO EXEC sp_addextendedproperty N'MS_Description', 'weitere Gruppenzugehörigkeit (frei)', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Gruppe4' GO EXEC sp_addextendedproperty N'MS_Description', 'weitere Gruppenzugehörigkeit (frei)', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Gruppe5' GO EXEC sp_addextendedproperty N'MS_Description', 'EDI: Internationale Nummer, die die Adresse eindeutig identifiziert. Format: Basis|RestNr und Prüfziffer', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'ILN' GO EXEC sp_addextendedproperty N'MS_Description', N'0=aktiv, 1=inaktiv, Adresse wird nicht mehr angezeigt bzw. benutzt für Exporte', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'InaktivJN' GO EXEC sp_addextendedproperty N'MS_Description', N'Ist diese Adresse ein Interessent?', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Interessent' GO EXEC sp_addextendedproperty N'MS_Description', N'URL der Website der Adresse', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Internet' GO I will create to dbs an try to reproduce the errors. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Extended Properties
Collation is Latin1_General_CI_AS for both databases. Another problem is that in some statements the square brakets are missing now. new CREATE TRIGGER [dbo].[Adressen_Delete] ON db...
0 votes
you'll get them in a few minutes... / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Extended Properties
you'll get them in a few minutes...
0 votes
Total activity
12
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3