How can we help you today? How can we help you today?
johnfnz

Activity overview

Latest activity by johnfnz

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
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
SQLCompare Deployment Order
Can anyone confirm how SQLCompare decides what order to deploy objects in? I have a case (fairly common in our organisation) where the scripts generated by SQLCompare refer to objects before they e...
2 followers 2 comments 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
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
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
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
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
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