Problems with SQL Compare

Comments

• Options

  Brian Donahue Posts: 6,590 Bronze 1

  April 15, 2004 9:30AM

  Hi Scott,
  
  The patch is on the way!
  
  Brian Donahue
  Red Gate Technical Support
  
  "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
  news:$f0leBnIEHA.1616@server53...
  > Brian, I think we are having the same problem. After installing 3.1.5.191
  > SQL Compare, we are receiving the "The parameter is incorrect" message
  box.
  > I had to get some compares done, so I uninstalled Red-Gate and installed
  the
  > previous version to finish my tasks. This morning I re-installed the
  > 3.1.5.191 update, and now the process just hangs without receiving any
  > error. ?? I was trying to reproduce the error before I submitted the
  > problem. It seems that it (3.1.5.191) works on a small percent of our
  > databases, but not all like before. It does seem like the unicode/ansi
  > problem has been resolved in 3.1.5.191.
  >
  > Scott Tucholka
  > AQS
  >
  >
  > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
  > news:#TXgMkiIEHA.1848@server53...
  > > Hi Ruvan,
  > >
  > > I think this is the same problem as one we've run into last week. I
  > will
  > > email a patch to you that should fix the problem.
  > >
  > > Regards,
  > >
  > > Brian Donahue
  > > Red Gate Technical Support
  > >
  > >
  > > "Ruvan Fernando" <rufe@[REMOVE-THIS]NETPEOPLE.DK> wrote in message
  > > news:dW2pqofIEHA.3080@server53...
  > > > Hi Redgate
  > > >
  > > > As I mentioned in a previous post I am developing a deploy tool.
  > > > Using some databases works fine, but now I have started to use the
  > ToolKit
  > > > on production databases and suddenly the comparison operation can't
  > > > complete.
  > > >
  > > > I tried to do it using the SQL Compare GUI tool (version 3.1.5.191)
  and
  > > the
  > > > error also occurs. BUT! What's really strange is that the SQL Compare
  > tool
  > > > works on the problematic databases from another machine - but not my
  > > Deploy
  > > > application, that still gets the same error as shown below.
  > > >
  > > >

  ---

  > > >
  > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
  category,
  > > > EventLogEntryType type, String[] strings, Byte[] rawData)
  > > > at System.Diagnostics.EventLog.WriteEntry(String message,
  > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
  > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
  > > message,
  > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
  > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
  > > message,
  > > > EventLogEntryType type, Int32 eventID, Int16 category)
  > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
  > > message,
  > > > EventLogEntryType type, Int32 eventID)
  > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
  > > message,
  > > > EventLogEntryType type)
  > > > at RedGate.SQLCompare.Engine.Database.GetDependencies(String sql,
  > > Boolean
  > > > quotedIdentifiers, Boolean throwExceptions)
  > > > at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
  > > > connectionProperties, Options options)
  > > > at Deployer.DatabaseCompare.CompareDatabases() in
  > > > c:videployerdbcompare.cs:line 52
  > > > at Deployer.DeployProject.CompareDataBases() in
  > > > c:videployerdeployproject.cs:line 135
  > > > at Deployer.Form1.StartCompare_Click(Object sender, EventArgs e) in
  > > > c:videployerform1.cs:line 603
  > > >
  > > > The error both the GUI displays and the ToolKit returns is: "The
  > parameter
  > > > is incorrect" right after examining "comments" objects.
  > > >
  > > > I have attached a screenshot also.
  > > >
  > > >

  ---

  > > >
  > > > Both machines that run SQL Compare and my Deploy tool runs on Windows
  > > Server
  > > > 2003 (the one that works is however a Standard, mine is a Enterprise).
  > > > Databases are SQL Server 2000 running on Windows 2000 machines.
  > > >
  > > >
  > > > Any ideas?
  > > >
  > > > Best regards,
  > > >
  > > > Ruvan Fernando
  > > > System Developer
  > > > NetPeople A/S
  > > > Denmark
  > > >
  > > >
  > > >
  > >
  > >
  >
  >

  0 · Share on Twitter
• Options

  Brian Donahue Posts: 6,590 Bronze 1

  April 16, 2004 11:06AM edited September 16, 2004 9:00AM

  Hi Scott,
  
  It must be a problem in the dependency parsing code. I've had an email
  just today from someone with the same problem, where the application event
  logs fill up with 'couldn't parse' errors from SQL Compare.
  
  I am waiting for some information from the other customer, and when we
  find out what's wrong, I'll let you know.
  
  Regards,
  
  Brian Donahue
  Red Gate Technical Support
  
  "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
  news:14wY2avIEHA.1612@server53...
  > After I installed the patch (3.1.6.200), I retried a compare. I received a
  > message like "Log File is Full" (Cannot recreate to get the exact syntax).
  > Then I tried again, and it just locked up. I then rebooted my workstation
  > and retried and it locked up again on the 'Reading Comments' step (screen
  > shot). Please let me know if you need any additional information.
  >
  > Scott.
  >
  > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
  > news:Sdjk$2uIEHA.1236@server53...
  > > Hi Scott,
  > >
  > > The patch is on the way!
  > >
  > > Brian Donahue
  > > Red Gate Technical Support
  > >
  > > "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
  > > news:$f0leBnIEHA.1616@server53...
  > > > Brian, I think we are having the same problem. After installing
  > 3.1.5.191
  > > > SQL Compare, we are receiving the "The parameter is incorrect"
  message
  > > box.
  > > > I had to get some compares done, so I uninstalled Red-Gate and
  installed
  > > the
  > > > previous version to finish my tasks. This morning I re-installed the
  > > > 3.1.5.191 update, and now the process just hangs without receiving any
  > > > error. ?? I was trying to reproduce the error before I submitted the
  > > > problem. It seems that it (3.1.5.191) works on a small percent of our
  > > > databases, but not all like before. It does seem like the unicode/ansi
  > > > problem has been resolved in 3.1.5.191.
  > > >
  > > > Scott Tucholka
  > > > AQS
  > > >
  > > >
  > > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in
  message
  > > > news:#TXgMkiIEHA.1848@server53...
  > > > > Hi Ruvan,
  > > > >
  > > > > I think this is the same problem as one we've run into last
  week.
  > I
  > > > will
  > > > > email a patch to you that should fix the problem.
  > > > >
  > > > > Regards,
  > > > >
  > > > > Brian Donahue
  > > > > Red Gate Technical Support
  > > > >
  > > > >
  > > > > "Ruvan Fernando" <rufe@[REMOVE-THIS]NETPEOPLE.DK> wrote in message
  > > > > news:dW2pqofIEHA.3080@server53...
  > > > > > Hi Redgate
  > > > > >
  > > > > > As I mentioned in a previous post I am developing a deploy tool.
  > > > > > Using some databases works fine, but now I have started to use the
  > > > ToolKit
  > > > > > on production databases and suddenly the comparison operation
  can't
  > > > > > complete.
  > > > > >
  > > > > > I tried to do it using the SQL Compare GUI tool (version
  3.1.5.191)
  > > and
  > > > > the
  > > > > > error also occurs. BUT! What's really strange is that the SQL
  > Compare
  > > > tool
  > > > > > works on the problematic databases from another machine - but not
  my
  > > > > Deploy
  > > > > > application, that still gets the same error as shown below.
  > > > > >
  > > > > >

  ---

  > > > > >
  > > > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
  > > category,
  > > > > > EventLogEntryType type, String[] strings, Byte[] rawData)
  > > > > > at System.Diagnostics.EventLog.WriteEntry(String message,
  > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
  > rawData)
  > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
  > > > > message,
  > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
  > rawData)
  > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
  > > > > message,
  > > > > > EventLogEntryType type, Int32 eventID, Int16 category)
  > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
  > > > > message,
  > > > > > EventLogEntryType type, Int32 eventID)
  > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
  > > > > message,
  > > > > > EventLogEntryType type)
  > > > > > at RedGate.SQLCompare.Engine.Database.GetDependencies(String
  sql,
  > > > > Boolean
  > > > > > quotedIdentifiers, Boolean throwExceptions)
  > > > > > at
  > RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
  > > > > > connectionProperties, Options options)
  > > > > > at Deployer.DatabaseCompare.CompareDatabases() in
  > > > > > c:videployerdbcompare.cs:line 52
  > > > > > at Deployer.DeployProject.CompareDataBases() in
  > > > > > c:videployerdeployproject.cs:line 135
  > > > > > at Deployer.Form1.StartCompare_Click(Object sender, EventArgs
  e)
  > in
  > > > > > c:videployerform1.cs:line 603
  > > > > >
  > > > > > The error both the GUI displays and the ToolKit returns is: "The
  > > > parameter
  > > > > > is incorrect" right after examining "comments" objects.
  > > > > >
  > > > > > I have attached a screenshot also.
  > > > > >
  > > > > >

  ---

  > > > > >
  > > > > > Both machines that run SQL Compare and my Deploy tool runs on
  > Windows
  > > > > Server
  > > > > > 2003 (the one that works is however a Standard, mine is a
  > Enterprise).
  > > > > > Databases are SQL Server 2000 running on Windows 2000 machines.
  > > > > >
  > > > > >
  > > > > > Any ideas?
  > > > > >
  > > > > > Best regards,
  > > > > >
  > > > > > Ruvan Fernando
  > > > > > System Developer
  > > > > > NetPeople A/S
  > > > > > Denmark
  > > > > >
  > > > > >
  > > > > >
  > > > >
  > > > >
  > > >
  > > >
  > >
  > >
  >
  >
  >

  0 · Share on Twitter
• Options

  Brian Donahue Posts: 6,590 Bronze 1

  April 19, 2004 7:36AM edited September 16, 2004 9:01AM

  Hi Scott,
  
  It doesn't seem to be the numbering on its' own that causes a problem,
  because I can create any number of SPs using numbering and SQl Compare works
  okay with them...
  
  Is it possible for you to email your stored procedures to
  support@red-gate.com?
  
  Thanks!
  
  Regards,
  
  Brian Donahue
  Red Gate Technical Support
  
  "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
  news:tFIcxR%23IEHA.1240@server53...
  > Hi Brian,
  >
  > I cleaned out the application event log and retried the compare and I
  think
  > I found the problem. We have a couple of large stored procedures that use
  > the ; number feature. Example: CREATE PROC [ EDURE ] [ owner. ]
  > procedure_name [ ; number ] <<. We get an error for each one that we
  have.
  > Before I ran the compare again, I increased my application event log to
  > handle 1024 instead of 512 and I think that allowed the compare to finish.
  > There is also a problem when scripting the number feature that it should
  > drop the procedure before it creates all the joined procedures.
  > Couldn't parse the following [first 16k follows]. Please contact
  > support@red-gate.com.
  >
  >
  /*==========================================================================
  > =======================
  >
  > ** NAME: dbo.AQSsp_OOS_Create_Reapply;1
  >
  >
  >
  > Hopes this helps in debugging,
  > Scott.
  >
  >
  > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
  > news:7DhCHR8IEHA.1240@server53...
  > > Hi Scott,
  > >
  > > It must be a problem in the dependency parsing code. I've had an
  email
  > > just today from someone with the same problem, where the application
  event
  > > logs fill up with 'couldn't parse' errors from SQL Compare.
  > >
  > > I am waiting for some information from the other customer, and when
  we
  > > find out what's wrong, I'll let you know.
  > >
  > > Regards,
  > >
  > > Brian Donahue
  > > Red Gate Technical Support
  > >
  > > "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
  > > news:14wY2avIEHA.1612@server53...
  > > > After I installed the patch (3.1.6.200), I retried a compare. I
  received
  > a
  > > > message like "Log File is Full" (Cannot recreate to get the exact
  > syntax).
  > > > Then I tried again, and it just locked up. I then rebooted my
  > workstation
  > > > and retried and it locked up again on the 'Reading Comments' step
  > (screen
  > > > shot). Please let me know if you need any additional information.
  > > >
  > > > Scott.
  > > >
  > > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in
  message
  > > > news:Sdjk$2uIEHA.1236@server53...
  > > > > Hi Scott,
  > > > >
  > > > > The patch is on the way!
  > > > >
  > > > > Brian Donahue
  > > > > Red Gate Technical Support
  > > > >
  > > > > "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
  > > > > news:$f0leBnIEHA.1616@server53...
  > > > > > Brian, I think we are having the same problem. After installing
  > > > 3.1.5.191
  > > > > > SQL Compare, we are receiving the "The parameter is incorrect"
  > > message
  > > > > box.
  > > > > > I had to get some compares done, so I uninstalled Red-Gate and
  > > installed
  > > > > the
  > > > > > previous version to finish my tasks. This morning I re-installed
  the
  > > > > > 3.1.5.191 update, and now the process just hangs without receiving
  > any
  > > > > > error. ?? I was trying to reproduce the error before I submitted
  the
  > > > > > problem. It seems that it (3.1.5.191) works on a small percent of
  > our
  > > > > > databases, but not all like before. It does seem like the
  > unicode/ansi
  > > > > > problem has been resolved in 3.1.5.191.
  > > > > >
  > > > > > Scott Tucholka
  > > > > > AQS
  > > > > >
  > > > > >
  > > > > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in
  > > message
  > > > > > news:#TXgMkiIEHA.1848@server53...
  > > > > > > Hi Ruvan,
  > > > > > >
  > > > > > > I think this is the same problem as one we've run into last
  > > week.
  > > > I
  > > > > > will
  > > > > > > email a patch to you that should fix the problem.
  > > > > > >
  > > > > > > Regards,
  > > > > > >
  > > > > > > Brian Donahue
  > > > > > > Red Gate Technical Support
  > > > > > >
  > > > > > >
  > > > > > > "Ruvan Fernando" <rufe@[REMOVE-THIS]NETPEOPLE.DK> wrote in
  message
  > > > > > > news:dW2pqofIEHA.3080@server53...
  > > > > > > > Hi Redgate
  > > > > > > >
  > > > > > > > As I mentioned in a previous post I am developing a deploy
  tool.
  > > > > > > > Using some databases works fine, but now I have started to use
  > the
  > > > > > ToolKit
  > > > > > > > on production databases and suddenly the comparison operation
  > > can't
  > > > > > > > complete.
  > > > > > > >
  > > > > > > > I tried to do it using the SQL Compare GUI tool (version
  > > 3.1.5.191)
  > > > > and
  > > > > > > the
  > > > > > > > error also occurs. BUT! What's really strange is that the SQL
  > > > Compare
  > > > > > tool
  > > > > > > > works on the problematic databases from another machine - but
  > not
  > > my
  > > > > > > Deploy
  > > > > > > > application, that still gets the same error as shown below.
  > > > > > > >
  > > > > > > >

  ---

  > > > > > > >
  > > > > > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
  > > > > category,
  > > > > > > > EventLogEntryType type, String[] strings, Byte[] rawData)
  > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String message,
  > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
  > > > rawData)
  > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
  > String
  > > > > > > message,
  > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
  > > > rawData)
  > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
  > String
  > > > > > > message,
  > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category)
  > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
  > String
  > > > > > > message,
  > > > > > > > EventLogEntryType type, Int32 eventID)
  > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
  > String
  > > > > > > message,
  > > > > > > > EventLogEntryType type)
  > > > > > > > at
  RedGate.SQLCompare.Engine.Database.GetDependencies(String
  > > sql,
  > > > > > > Boolean
  > > > > > > > quotedIdentifiers, Boolean throwExceptions)
  > > > > > > > at
  > > > RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
  > > > > > > > connectionProperties, Options options)
  > > > > > > > at Deployer.DatabaseCompare.CompareDatabases() in
  > > > > > > > c:videployerdbcompare.cs:line 52
  > > > > > > > at Deployer.DeployProject.CompareDataBases() in
  > > > > > > > c:videployerdeployproject.cs:line 135
  > > > > > > > at Deployer.Form1.StartCompare_Click(Object sender,
  EventArgs
  > > e)
  > > > in
  > > > > > > > c:videployerform1.cs:line 603
  > > > > > > >
  > > > > > > > The error both the GUI displays and the ToolKit returns is:
  "The
  > > > > > parameter
  > > > > > > > is incorrect" right after examining "comments" objects.
  > > > > > > >
  > > > > > > > I have attached a screenshot also.
  > > > > > > >
  > > > > > > >

  ---

  > > > > > > >
  > > > > > > > Both machines that run SQL Compare and my Deploy tool runs on
  > > > Windows
  > > > > > > Server
  > > > > > > > 2003 (the one that works is however a Standard, mine is a
  > > > Enterprise).
  > > > > > > > Databases are SQL Server 2000 running on Windows 2000
  machines.
  > > > > > > >
  > > > > > > >
  > > > > > > > Any ideas?
  > > > > > > >
  > > > > > > > Best regards,
  > > > > > > >
  > > > > > > > Ruvan Fernando
  > > > > > > > System Developer
  > > > > > > > NetPeople A/S
  > > > > > > > Denmark
  > > > > > > >
  > > > > > > >
  > > > > > > >
  > > > > > >
  > > > > > >
  > > > > >
  > > > > >
  > > > >
  > > > >
  > > >
  > > >
  > > >
  > >
  > >
  >
  >

  0 · Share on Twitter
• Options

  Brian Donahue Posts: 6,590 Bronze 1

  April 20, 2004 6:05AM

  Hi Scott,
  
  Have you tried re-installing SQL Compare 1.51 without the patch that I
  sent you? This had cleared the problem for another customer. We think this
  might have something to do with one of Microsoft's security updates,
  although we haven't had the problem here.
  
  Regards,
  
  Brian Donahue
  Red Gate Technical Support
  
  "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
  news:tFIcxR%23IEHA.1240@server53...
  > Hi Brian,
  >
  > I cleaned out the application event log and retried the compare and I
  think
  > I found the problem. We have a couple of large stored procedures that use
  > the ; number feature. Example: CREATE PROC [ EDURE ] [ owner. ]
  > procedure_name [ ; number ] <<. We get an error for each one that we
  have.
  > Before I ran the compare again, I increased my application event log to
  > handle 1024 instead of 512 and I think that allowed the compare to finish.
  > There is also a problem when scripting the number feature that it should
  > drop the procedure before it creates all the joined procedures.
  > Couldn't parse the following [first 16k follows]. Please contact
  > support@red-gate.com.
  >
  >
  /*==========================================================================
  > =======================
  >
  > ** NAME: dbo.AQSsp_OOS_Create_Reapply;1
  >
  >
  >
  > Hopes this helps in debugging,
  > Scott.
  >
  >
  > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
  > news:7DhCHR8IEHA.1240@server53...
  > > Hi Scott,
  > >
  > > It must be a problem in the dependency parsing code. I've had an
  email
  > > just today from someone with the same problem, where the application
  event
  > > logs fill up with 'couldn't parse' errors from SQL Compare.
  > >
  > > I am waiting for some information from the other customer, and when
  we
  > > find out what's wrong, I'll let you know.
  > >
  > > Regards,
  > >
  > > Brian Donahue
  > > Red Gate Technical Support
  > >
  > > "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
  > > news:14wY2avIEHA.1612@server53...
  > > > After I installed the patch (3.1.6.200), I retried a compare. I
  received
  > a
  > > > message like "Log File is Full" (Cannot recreate to get the exact
  > syntax).
  > > > Then I tried again, and it just locked up. I then rebooted my
  > workstation
  > > > and retried and it locked up again on the 'Reading Comments' step
  > (screen
  > > > shot). Please let me know if you need any additional information.
  > > >
  > > > Scott.
  > > >
  > > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in
  message
  > > > news:Sdjk$2uIEHA.1236@server53...
  > > > > Hi Scott,
  > > > >
  > > > > The patch is on the way!
  > > > >
  > > > > Brian Donahue
  > > > > Red Gate Technical Support
  > > > >
  > > > > "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
  > > > > news:$f0leBnIEHA.1616@server53...
  > > > > > Brian, I think we are having the same problem. After installing
  > > > 3.1.5.191
  > > > > > SQL Compare, we are receiving the "The parameter is incorrect"
  > > message
  > > > > box.
  > > > > > I had to get some compares done, so I uninstalled Red-Gate and
  > > installed
  > > > > the
  > > > > > previous version to finish my tasks. This morning I re-installed
  the
  > > > > > 3.1.5.191 update, and now the process just hangs without receiving
  > any
  > > > > > error. ?? I was trying to reproduce the error before I submitted
  the
  > > > > > problem. It seems that it (3.1.5.191) works on a small percent of
  > our
  > > > > > databases, but not all like before. It does seem like the
  > unicode/ansi
  > > > > > problem has been resolved in 3.1.5.191.
  > > > > >
  > > > > > Scott Tucholka
  > > > > > AQS
  > > > > >
  > > > > >
  > > > > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in
  > > message
  > > > > > news:#TXgMkiIEHA.1848@server53...
  > > > > > > Hi Ruvan,
  > > > > > >
  > > > > > > I think this is the same problem as one we've run into last
  > > week.
  > > > I
  > > > > > will
  > > > > > > email a patch to you that should fix the problem.
  > > > > > >
  > > > > > > Regards,
  > > > > > >
  > > > > > > Brian Donahue
  > > > > > > Red Gate Technical Support
  > > > > > >
  > > > > > >
  > > > > > > "Ruvan Fernando" <rufe@[REMOVE-THIS]NETPEOPLE.DK> wrote in
  message
  > > > > > > news:dW2pqofIEHA.3080@server53...
  > > > > > > > Hi Redgate
  > > > > > > >
  > > > > > > > As I mentioned in a previous post I am developing a deploy
  tool.
  > > > > > > > Using some databases works fine, but now I have started to use
  > the
  > > > > > ToolKit
  > > > > > > > on production databases and suddenly the comparison operation
  > > can't
  > > > > > > > complete.
  > > > > > > >
  > > > > > > > I tried to do it using the SQL Compare GUI tool (version
  > > 3.1.5.191)
  > > > > and
  > > > > > > the
  > > > > > > > error also occurs. BUT! What's really strange is that the SQL
  > > > Compare
  > > > > > tool
  > > > > > > > works on the problematic databases from another machine - but
  > not
  > > my
  > > > > > > Deploy
  > > > > > > > application, that still gets the same error as shown below.
  > > > > > > >
  > > > > > > >

  ---

  > > > > > > >
  > > > > > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
  > > > > category,
  > > > > > > > EventLogEntryType type, String[] strings, Byte[] rawData)
  > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String message,
  > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
  > > > rawData)
  > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
  > String
  > > > > > > message,
  > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
  > > > rawData)
  > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
  > String
  > > > > > > message,
  > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category)
  > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
  > String
  > > > > > > message,
  > > > > > > > EventLogEntryType type, Int32 eventID)
  > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
  > String
  > > > > > > message,
  > > > > > > > EventLogEntryType type)
  > > > > > > > at
  RedGate.SQLCompare.Engine.Database.GetDependencies(String
  > > sql,
  > > > > > > Boolean
  > > > > > > > quotedIdentifiers, Boolean throwExceptions)
  > > > > > > > at
  > > > RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
  > > > > > > > connectionProperties, Options options)
  > > > > > > > at Deployer.DatabaseCompare.CompareDatabases() in
  > > > > > > > c:videployerdbcompare.cs:line 52
  > > > > > > > at Deployer.DeployProject.CompareDataBases() in
  > > > > > > > c:videployerdeployproject.cs:line 135
  > > > > > > > at Deployer.Form1.StartCompare_Click(Object sender,
  EventArgs
  > > e)
  > > > in
  > > > > > > > c:videployerform1.cs:line 603
  > > > > > > >
  > > > > > > > The error both the GUI displays and the ToolKit returns is:
  "The
  > > > > > parameter
  > > > > > > > is incorrect" right after examining "comments" objects.
  > > > > > > >
  > > > > > > > I have attached a screenshot also.
  > > > > > > >
  > > > > > > >

  ---

  > > > > > > >
  > > > > > > > Both machines that run SQL Compare and my Deploy tool runs on
  > > > Windows
  > > > > > > Server
  > > > > > > > 2003 (the one that works is however a Standard, mine is a
  > > > Enterprise).
  > > > > > > > Databases are SQL Server 2000 running on Windows 2000
  machines.
  > > > > > > >
  > > > > > > >
  > > > > > > > Any ideas?
  > > > > > > >
  > > > > > > > Best regards,
  > > > > > > >
  > > > > > > > Ruvan Fernando
  > > > > > > > System Developer
  > > > > > > > NetPeople A/S
  > > > > > > > Denmark
  > > > > > > >
  > > > > > > >
  > > > > > > >
  > > > > > >
  > > > > > >
  > > > > >
  > > > > >
  > > > >
  > > > >
  > > >
  > > >
  > > >
  > >
  > >
  >
  >

  0 · Share on Twitter