How can we help you today? How can we help you today?
johnfnz
Activity overview Badges (0) Posts (2) Comments (9)

Comments

Sort by recent activity
The metadata has moved on since the problem occurred i.e. we have manually fixed. When we get a re-occurrence I'll collect the information required. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQLCompare Deployment Order
The metadata has moved on since the problem occurred i.e. we have manually fixed. When we get a re-occurrence I'll collect the information required.
0 votes
That doesn't help because: Error: The /assertidentical switch cannot be used in conjunction with the /synchronize switch. Please use SQLCompare.exe /? or SQLCompare.exe /verbose /? for more information. If I remove include:idential then I just get the Error: The selected objects are identical or no objects have been selected in the comparison. error. I'll try the filer. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Ignore Roles
That doesn't help because:Error: The /assertidentical switch cannot be used in conjunction with the /synchronize switch. Please use SQLCompare.exe /? or SQLCompare.exe /verbose /? for more informat...
0 votes
Have replicated this behaviour in 10.4. C:\Program Files (x86)\Red Gate\SQL Compare 10>sqlcompare.exe /s2:localhost /u2:sa /p2:<..password..> /scr1:<..path..> /db2:<..database..> /synchronise /include:Schema /include:Rule /include:Function /include:UserDefinedType /include:StoredProcedure /include:Synonym /include:Table /include:View /include:Identical /exclude:Role /exclude:User /Options:DecryptPost2KEncryptedObjects,IgnoreFillFactor,IgnoreWhiteSpace,IgnoreFileGroups,IgnoreUserProperties,IgnoreWithElementOrder,IgnoreDatabaseAndServerName,IgnoreUsersPermissionsAndRoleMemberships,IgnoreConstraintNames,IgnorePermissions,IgnoreExtendedProperties,IgnoreUsers SQL Compare: activated, edition: professional, serial number: <..valid serial..> Automation License: activated, edition: standard, serial number: <..valid serial..> SQL Compare Command Line V10.4.8.87 ================================================================================================================================== Copyright © Red Gate Software Ltd 1999-2013 Registering data sources Creating mappings Comparing Applying Command Line Items Retrieving migration scripts Checking for identical databases Creating SQL Deploying changes (from DB1 to DB2) Summary Information =================================================================================================================================== DB1 = <..database..> DB2 = localhost.<..database..> Object type Name DB1 DB2 ----------------------------------------------------------------------------------------------------------------------------------- <..snip..> Role db_accessadmin == == Role db_ddladmin == == Role db_datawriter == == Role db_backupoperator == == Role db_denydatareader == == Role db_datareader == == Role db_securityadmin == == Role db_owner == == Role db_denydatawriter == == Role public == == <..snip..> / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Ignore Roles
Have replicated this behaviour in 10.4.C:\Program Files (x86)\Red Gate\SQL Compare 10>sqlcompare.exe /s2:localhost /u2:sa /p2:<..password..> /scr1:<..path..> /db2:<..datab...
0 votes
Any update? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Ignore Roles
Any update?
0 votes
Sorry. Same behaviour. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Ignore Roles
Sorry. Same behaviour.
0 votes
Will our 10.2 licences be equally valid with that? This'll take time as I'll need to get approval to get new software installed. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Ignore Roles
Will our 10.2 licences be equally valid with that? This'll take time as I'll need to get approval to get new software installed.
0 votes
OK. Got a command from the command line that replicates this behaviour. I have slightly anonymised the output as this is a public forum but please be assured the bits <..like this..> contain valid values. See output below: C:\Program Files &#40;x86&#41;\Red Gate\SQL Compare 10&gt; sqlcompare.exe /s2:localhost /u2:sa /p2:&lt;..password..&gt; /scr1:"&lt;..path..&gt;" /db2:&lt;..Database..&gt; /synchronise /include:Schema:.* /include:Rule:.* /include:Function:.* /include:UserDefinedType:.* /include:StoredProcedure:.* /include:Synonym:.* /include:Table:.* /include:View:.* /include:Identical /exclude:Role:.* /exclude:User:.* /Options:DecryptPost2KEncryptedObjects,IgnoreFillFactor,IgnoreWhiteSpace,IgnoreFileGroups,IgnoreUserProperties,IgnoreWithElementOrder,IgnoreDatabaseAndServerName,IgnoreUsersPermissionsAndRoleMemberships,IgnoreConstraintNames,IgnorePermissions,IgnoreExtendedProperties,IgnoreUsers SQL Compare: activated, edition: professional, serial number: &lt;..Valid Licence..&gt; Automation License: activated, edition: standard, serial number: &lt;..Valid Licence..&gt; SQL Compare Command Line V10.2.0.1337 ================================================================================================================================== Copyright © Red Gate Software Ltd 1999-2012 Registering data sources Creating mappings Comparing Applying Command Line Items Retrieving migration scripts Creating SQL Deploying changes &#40;from DB1 to DB2&#41; Summary Information =================================================================================================================================== DB1 = &lt;..database..&gt; DB2 = localhost.&lt;..database..&gt; Object type Name DB1 DB2 ----------------------------------------------------------------------------------------------------------------------------------- &lt;..snip..&gt; Role db_owner == == Role db_accessadmin == == Role db_datareader == == Role db_datawriter == == Role db_ddladmin == == Role db_securityadmin == == Role db_backupoperator == == Role db_denydatareader == == Role db_denydatawriter == == &lt;..snip..&gt; / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Ignore Roles
OK. Got a command from the command line that replicates this behaviour. I have slightly anonymised the output as this is a public forum but please be assured the bits <..like this..> contain valid ...
0 votes
I spotted this. I did have Default as one of the options specified. So I removed it but still the same behaviour. The command is being built programmatically - I'll dig it out and post... / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Ignore Roles
I spotted this. I did have Default as one of the options specified. So I removed it but still the same behaviour. The command is being built programmatically - I'll dig it out and post...
0 votes
/Options=IgnoreDependencies doesn't seem to exist in my version. Am running 10.2 / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Ignore Roles
/Options=IgnoreDependencies doesn't seem to exist in my version. Am running 10.2
0 votes
Total activity
13
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2