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

Activity overview

Latest activity by nsams

I put in a support ticket but they think that the issue is with SQL Compare v11 versus the SDK is at 10.7. However, I'm using an automated build tool that references the 10.7 assemblies and then I'm installing the 10.7 assemblies on the client machine and then I have a database conversion program that also references the 10.7 assemblies to convert the databases. So that should all work seamlessly together right? / comments
  1. Community
  2. SQL Compare 11
  3. SQLCompare freezes during compare phase
I put in a support ticket but they think that the issue is with SQL Compare v11 versus the SDK is at 10.7. However, I'm using an automated build tool that references the 10.7 assemblies and then I...
0 votes
My code look a lot like your sample with a few tweaks so I'm not sure why it doesn't work in my program but works fine in SQL Compare... I define a set of options: m_Options = New Options m_Options = Options.IgnoreBindings _ .Plus(Options.IgnoreChecks) _ .Plus(Options.IgnoreCollations) _ .Plus(Options.IgnoreConstraintNames) _ .Plus(Options.IgnoreFileGroups) _ .Plus(Options.IgnoreFillFactor) _ .Plus(Options.IgnoreFullTextIndexing) _ .Plus(Options.IgnorePermissions) _ .Plus(Options.IgnoreQuotedIdentifiersAndAnsiNullSettings) _ .Plus(Options.IgnoreWhiteSpace) _ .Plus(Options.IncludeDependencies) _ .Plus(Options.IgnoreExtendedProperties) Then I compare the database to a snapshot file and then grab the differences. 'Set up the appropriate master database snap shot file m_sStatusObj = "m_oMasterDB" m_oMasterDB.LoadFromDisk(g_sAppPath & "" & sSnapshotFile) If g_oConvApp.CancelConversion Then MsgBox("The conversion has been cancelled.", CType(MsgBoxStyle.OkOnly + MsgBoxStyle.Information, Microsoft.VisualBasic.MsgBoxStyle), InfoCaption) GoTo EndFunction End If 'Script the database being converted lblText.Text = "Scripting database" lblSecMsg.Text = "Scripting database" ClearProgress() System.Windows.Forms.Application.DoEvents() oConnProps = New ConnectionProperties oConnProps.ServerName = g_oUser.Server oConnProps.DatabaseName = sDB oConnProps.IntegratedSecurity = False oConnProps.Password = g_oUser.Password oConnProps.UserName = g_oUser.UserID m_sStatusObj = "m_oDB" m_oDB.Register(oConnProps, m_Options) 'Compare the database being converted to the corresponding master lblText.Text = "Comparing databases" lblSecMsg.Text = "Comparing databases" ClearProgress() System.Windows.Forms.Application.DoEvents() oDiffs = m_oDB.CompareWith(m_oMasterDB, m_Options) 'Exclude all database objects that we don't care about from the 'synchronization For Each oDiff As Difference In oDiffs If oDiff.DatabaseObjectType <> RedGate.SQLCompare.Engine.ObjectType.Table And _ oDiff.DatabaseObjectType <> RedGate.SQLCompare.Engine.ObjectType.View And _ oDiff.DatabaseObjectType <> RedGate.SQLCompare.Engine.ObjectType.StoredProcedure And _ oDiff.DatabaseObjectType <> RedGate.SQLCompare.Engine.ObjectType.Function Then oDiff.Selected = False Else oDiff.Selected = True End If Next oDiff It gets stuck at the oDiffs = m_oDB.CompareWith(m_oMasterDB, m_Options) line. / comments
  1. Community
  2. SQL Compare 11
  3. SQLCompare freezes during compare phase
My code look a lot like your sample with a few tweaks so I'm not sure why it doesn't work in my program but works fine in SQL Compare... I define a set of options: m_Options = New Options m...
0 votes
I'm having the same issue. It runs fine when using SQL Compare 11 but it freezes when I'm using the dlls in my software. I was on version 10.0 (with a 10.0.0.265 hotfix) before upgrading to 11.0. It worked before the upgrade on the same machine, same server, same database...the only thing that has changed is the version of SQL compare. What can I do to get you logging information since it works fine through the program? thanks, / comments
  1. Community
  2. SQL Compare 11
  3. SQLCompare freezes during compare phase
I'm having the same issue. It runs fine when using SQL Compare 11 but it freezes when I'm using the dlls in my software. I was on version 10.0 (with a 10.0.0.265 hotfix) before upgrading to 11.0....
0 votes
Yes. If you left the Create screen open after it was done and did not clear the fields until it was closed by the user, then that would work fine for me. It would not be that bad to only have to enter that information once. Thanks for considering the suggestion. And I will check out that Snapper tool! / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Enhancement Request for making snapshots
Yes. If you left the Create screen open after it was done and did not clear the fields until it was closed by the user, then that would work fine for me. It would not be that bad to only have to ...
0 votes
Enhancement Request for making snapshots
  1. Community
  2. SQL Compare Previous Versions
I have a very simple yet important enhancement request. File | Create Snapshot: fill in all the information and click "Create Snapshot". Result: All the information you just entered (with the exce...
3 followers 3 comments 0 votes
This is now happening on another database of ours with a different table and constraint. Are you sure that there is no solution for this? I can't believe that our only solution would be to wait for someone to get this error, then have to go in manually and delete the constraint and then ask them to re-convert their database. It is very hard to fix this programmically. SQL Server does not let you directly delete records out of the default constraints table (sys.default_constraints). You have to do a ALTER statement on the table. The problem with that is that we don't know what table it is under until the error happens. I have been able to write a query that looks up the table name: Select sys.objects.name from sys.default_constraints inner join sys.objects ON sys.default_constraints.parent_object_id = sys.objects.object_id where sys.default_constraints.name = 'DF__tblPOBEEm__Benef__5D0B3BC8' And then I have to see how hard it would be to put that into a drop statement and have that run before the structural comparison. Even if this all works...someone else can call in the next day with a new constraint that's giving them issues and I would have to write a new query with drop for the new constraint name. There must be a better way! / comments
  1. Community
  2. SQL Compare Previous Versions
  3. getting an error about a constraint that doesn't exist?
This is now happening on another database of ours with a different table and constraint. Are you sure that there is no solution for this? I can't believe that our only solution would be to wait f...
0 votes
I am running a database conversion tool of ours that uses SQL Compare and I keep getting the error: Adding constraints to [dbo].[tblMAMSRBHeader] There is already an object named 'DF__tblMAMSRB__Concu__60FC61CA' in the database. Could not create constraint. See previous errors. I look at tblMAMSRBHeader and it does not have a constraint with that name. However, I did find it under a different table with a similar name tblMAMSRBContributions. Is there a way to tell SQL Compare to just give it a different name if it finds one of the same name already there? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. getting an error about a constraint that doesn't exist?
I am running a database conversion tool of ours that uses SQL Compare and I keep getting the error: Adding constraints to [dbo].[tblMAMSRBHeader] There is already an object named 'DF__tblMAMSRB__Co...
0 votes
Total activity
10
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3