Red Gate forums :: View topic - DDL Triggers not showing as different
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

DDL Triggers not showing as different

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
muaddba



Joined: 10 Feb 2012
Posts: 12

PostPosted: Fri Jan 18, 2013 10:25 pm    Post subject: DDL Triggers not showing as different Reply with quote

I have 2 databases with the same schema, except 1 has DDL triggers and one does not. I have no "Ignore trigger" options checked but SQLCompare is not showing me (that I can see) the DDL triggers differences.

Please advise?
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 76

PostPosted: Mon Jan 21, 2013 5:52 pm    Post subject: Reply with quote

Hi muaddba,

Thanks for your post. We have created a support ticket and will be contacting you shortly.

Best Regards,
Steve Tanori
_________________
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
Back to top
View user's profile Send private message
kdrazan



Joined: 30 Nov 2005
Posts: 2

PostPosted: Mon Feb 04, 2013 4:28 pm    Post subject: Re: Reply with quote

stanori wrote:
Hi muaddba,

Thanks for your post. We have created a support ticket and will be contacting you shortly.

Best Regards,
Steve Tanori


Hi Steve,

since few days I am experiencing the same problem.
Could you help me with this?

Regrads.
Back to top
View user's profile Send private message
Newfave



Joined: 20 Aug 2012
Posts: 5

PostPosted: Mon Feb 04, 2013 5:30 pm    Post subject: API Changed with new version: 10.3.1.140 Reply with quote

I'd expect there to be an announcement for the new version 10.3.1.140.

My team deployed the new version on Thursday 1/28/2013 - and now my automation for detecting changes between source control and production databases does not work.

I suspect that there were significant changes made to the API - that is affecting my set-up.

In order to make working with the command line easier, I create a template version of the SQL Compare .scp file - so I can handle all the settings there. Then I adjust it to point to a specific database - and run the comparison.

I actually run comparison on several hundred databases daily.

Anyhow - the problem I now get sounds like the complaints in this thread - where I no longer get comparison output that I expect.

I get an error message: "Error: The selected objects are identical or no objects have been selected in the comparison"

The comparison output is now:
"Registering data sources
Creating mappings
Comparing
Summarizing Project Selections
Retrieving migration scripts
Checking for identical databases"

So, it looks like the issue is in that step of "checking for identical databases"

Previously, the comparison output would include difference summary information:

"
Registering data sources
Creating mappings
Comparing
Summarizing Project Selections
Retrieving migration scripts

Summary Information
==============================================================================="

Also, shouldn't there be an announcement of the new version deployment?!!!
Back to top
View user's profile Send private message
Newfave



Joined: 20 Aug 2012
Posts: 5

PostPosted: Mon Feb 04, 2013 5:49 pm    Post subject: Where the new problem is Reply with quote

Above I suggested that the problem is probably a change in the API. That's probably not true.

It looks to be in the new "Checking for identical databases" operation.

I say that judging from what the comparison output looks like now versus what it looked like before the new version of SQL Compare got deployed to our servers.
Back to top
View user's profile Send private message
kdrazan



Joined: 30 Nov 2005
Posts: 2

PostPosted: Mon Feb 04, 2013 6:44 pm    Post subject: Re: Where the new problem is Reply with quote

Newfave wrote:
Above I suggested that the problem is probably a change in the API. That's probably not true.

It looks to be in the new "Checking for identical databases" operation.

I say that judging from what the comparison output looks like now versus what it looked like before the new version of SQL Compare got deployed to our servers.


Well it is crazy, but it looks like the problem was in the Project options Sad
Back to top
View user's profile Send private message
Newfave



Joined: 20 Aug 2012
Posts: 5

PostPosted: Wed Feb 06, 2013 10:49 pm    Post subject: Project Options Reply with quote

Does anyone know how to get around the project options issues - other than switching to straight command line?
Back to top
View user's profile Send private message
Darren Ferris



Joined: 22 Feb 2013
Posts: 1

PostPosted: Fri Feb 22, 2013 3:25 pm    Post subject: Reply with quote

I seem to have a similar problem when comparing tables and stored procedures.
When I use a project through the gui differences are detected. When I use the same project through the command line I don't get any differences but I do get this: -

Registering data sources
Creating mappings
Comparing
Summarizing Project Selections
Retrieving migration scripts
Checking for identical databases
Error: The selected objects are identical or no objects have been selected in the comparison.

Regards,

Darren
Back to top
View user's profile Send private message
Newfave



Joined: 20 Aug 2012
Posts: 5

PostPosted: Fri Feb 22, 2013 3:32 pm    Post subject: API Changed with new version: 10.3.1.140 Reply with quote

Per redgate, a bug has been identified and noted with number SC-6208.

The bug appears to affect the use of the Project file in the command line interface.

I find the Project file to be the easiest way to handle all the options of a comparison - rather than trying to handle it through command line switches.

One can first prepare a Project file using the GUI and get the use of the GUI to make settings changes - and then use it.

So, I hope this bug receives attention - because I think the Project file approach is the best approach.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group