Compare without extendedproperty

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings

Compare without extendedproperty

Postby aspillert » Wed Jun 13, 2012 2:33 pm

Is it possible to exclude between sp_addextendedproperty differences between views in two databases? The Extended Property filter rule doesn't seem to do anything.

Also - can a COMPARE be done without considering the format or whitespace in the view code? I use SQL Prompt to format on our test and production systems, but the developers use "Design", so format is always different.

Thank you for any assistance
AlanCHB
aspillert
 
Posts: 6
Joined: Thu Sep 25, 2008 8:32 pm
Location: Boston, Massachusetts, USA

Postby james.billings » Wed Jun 27, 2012 4:00 pm

Hi,

You probably want to be looking at the "Options" tab on your project configuration as opposed to filters.
There's tickboxes in there to ignore differences in whitespace, and differences that only exist in the extended properties.

Hope that helps,

James
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Re: Compare without extendedproperty

Postby mmoore » Tue Nov 20, 2012 3:11 pm

aspillert wrote:Is it possible to exclude between sp_addextendedproperty differences between views in two databases? The Extended Property filter rule doesn't seem to do anything.

Also - can a COMPARE be done without considering the format or whitespace in the view code? I use SQL Prompt to format on our test and production systems, but the developers use "Design", so format is always different.

Thank you for any assistance


I have this same issue. I really don't want the REDGATE extended properties added via SQL Source Control to be in my migration scripts. SQL Compare, no matter what you have set in the OPTIONS for "IGNORE" Extended Properties, still adds it at the end of the script. This is really frustrating.
Mark Moore
Software Engineer
NTS Data Services, LLC
mmoore
 
Posts: 14
Joined: Wed Jul 30, 2008 6:20 pm

Re: Compare without extendedproperty

Postby mmoore » Tue Nov 20, 2012 3:43 pm

mmoore wrote:
aspillert wrote:Is it possible to exclude between sp_addextendedproperty differences between views in two databases? The Extended Property filter rule doesn't seem to do anything.

Also - can a COMPARE be done without considering the format or whitespace in the view code? I use SQL Prompt to format on our test and production systems, but the developers use "Design", so format is always different.

Thank you for any assistance


I have this same issue. I really don't want the REDGATE extended properties added via SQL Source Control to be in my migration scripts. SQL Compare, no matter what you have set in the OPTIONS for "IGNORE" Extended Properties, still adds it at the end of the script. This is really frustrating.


After looking further into this, I noticed that this only applies to the Extended Properties that are added by SQL Source Control. They are always added, which in my case is pointless on my customer's Sql Server.
Mark Moore
Software Engineer
NTS Data Services, LLC
mmoore
 
Posts: 14
Joined: Wed Jul 30, 2008 6:20 pm

Re: Compare without extendedproperty

Postby CraigEddy » Wed Dec 12, 2012 6:42 pm

mmoore wrote:After looking further into this, I noticed that this only applies to the Extended Properties that are added by SQL Source Control. They are always added, which in my case is pointless on my customer's Sql Server.


I don't think that's the case. I check-boxed this option in the "Ignore" section and still had the SQL Source Control version number update appear in the deployment script.

I would LOVE LOVE LOVE to not have to manually edit my script every time I deploy to an environment that's not under SQL Source Control, especially since those environments aren't always updated to the LATEST in our repository (we selectively deploy objects to the target environment).
CraigEddy
 
Posts: 20
Joined: Fri Sep 28, 2012 2:59 pm

Postby David Atkinson » Wed Dec 12, 2012 10:08 pm

Can you try selecting Edit Project/Options/Behavior/Ignore Migration Scripts for databases.

Does this help?

David Atkinson
Red Gate
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Re:

Postby cQjm » Thu Dec 13, 2012 3:03 pm

Is it possible to enable this option using the command line?

David Atkinson wrote:Can you try selecting Edit Project/Options/Behavior/Ignore Migration Scripts for databases.

Does this help?

David Atkinson
Red Gate
cQjm
 
Posts: 1
Joined: Thu Dec 13, 2012 1:54 pm

Postby eddie davis » Thu Dec 13, 2012 5:28 pm

Hi,

The command line for this option is one of the following:
Code: Select all
/Options:DisableSOCForLiveDBs

Or using the alias
Code: Select all
/Options:dafld


Full list of the Command Line Options can be found HERE.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Re:

Postby CraigEddy » Wed Dec 19, 2012 5:31 pm

eddie davis wrote:Hi,

The command line for this option is one of the following:
Code: Select all
/Options:DisableSOCForLiveDBs

Or using the alias
Code: Select all
/Options:dafld


Full list of the Command Line Options can be found HERE.

Many Thanks
Eddie


That option works great! Thanks!
CraigEddy
 
Posts: 20
Joined: Fri Sep 28, 2012 2:59 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests