Search
Submit a request
Sign in
How can we help you today?
Categories
Submit a request
Submit a request
Sign in
tilleymf
Activity overview
Badges (0)
Posts (1)
Comments (1)
Comments
Sort by recent activity
Recent activity
Votes
Hi Michelle, Thanks for the response. I tried the variations of the /OPTIONS switches you suggested and did not have success. I am including the variations I tried to see if you have any ideas. Notes: db1:Ontrack_dev is a Development Source database db2:Ontrack_Synch is a copy of the database that will be used for testing that will be synched via a batch job calling SQLCompare Command Line. Dependencies: The UMS database is not present where the Ontrack Dev and Synch databases are located. This is intentional. This is also why we are attempting to run the SQLCompare Command Line WITHOUT dependencies included. Thanks for your help. (c: - Michael ************************************************************* First Variation ************************************************************* E:\RedGate\SQLCompare8>SQLCompare.exe /Options:DecryptPost2KEncryptedObjects,IgnoreFillFactor,IgnoreWhiteSpace,IgnoreFileGroups,IgnoreUserProperties,IgnoreWithElementOrder /db1:Ontrack_dev /db2:Ontrack_Synch /sync SQL Compare Command Line V8.1.0.360 ============================================================================== Copyright c Red Gate Software Ltd 1999-2009 Serial Number: 002-005-107214-XXXX Registering databases Creating mappings Comparing Applying Command Line Items Creating SQL Synchronizing databases (from DB1 to DB2) Error: Synchronization of '(local).Ontrack_dev' and '(local).Ontrack_Synch' failed: Invalid object name 'UMS.dbo.ALL_USERIDS'. ************************************************************* Second Variation ************************************************************* E:\RedGate\SQLCompare8>SQLCompare.exe /Options:none /db1:Ontrack_dev /db2:Ontrack_Synch /sync SQL Compare Command Line V8.1.0.360 ============================================================================== Copyright c Red Gate Software Ltd 1999-2009 Serial Number: 002-005-107214-XXXX Registering databases Creating mappings Comparing Applying Command Line Items Creating SQL Synchronizing databases (from DB1 to DB2) Error: Synchronization of '(local).Ontrack_dev' and '(local).Ontrack_Synch' failed: Invalid object name 'UMS.dbo.ALL_USERIDS'. E:\RedGate\SQLCompare8> / comments
Community
SQL Compare Previous Versions
SQL Compare 8 Command Line switch to EXCLUDE Dependencies
Hi Michelle, Thanks for the response. I tried the variations of the /OPTIONS switches you suggested and did not have success. I am including the variations I tried to see if you have any ideas. Not...
0 votes
Total activity
3
Last activity
February 06, 2025 13:39
Member since
February 06, 2025 13:39
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1
