How to Exclude Assembly in SQL Compare Pro Command-Line?

Forum for users of SQL Compare schema synchronization utility

How to Exclude Assembly in SQL Compare Pro Command-Line?

Postby MrSuaveh » Mon Jul 07, 2014 7:52 pm

I am using SQL Compare Pro 10.4.8 and have tried using
    /Exclude:Assembly AND /Exclude:Assembly:sersolsharedcode

However SQL Compare Pro keeps failing with the error message:
Code: Select all
Error: Synchronization of '\\COREDB3.LibraryDB' and ',1433.LibraryDB' failed: Assembly 'sersolsharedcode,
version=, culture=neutral, publickeytoken=221f68f4f5ae01e4.' was not found in the SQL catalog.

How can I prevent SQL Compare Pro from attempting to synchronize CLR spocs? I can do it interactively but not through the command line.

This is the SQL Compare Pro command I am using:
Code: Select all
/\\COREDB3 /DB1:LibraryDB
/,1433 /DB2:LibraryDB 
/Synchronize /Force
/Report:"F:\\My Documents\\DEV\\CCM\\databases\\SandBox\\RickJones\\SQLCompare\\SQLCompareReports\\DBMSSSQL2_87P7WK1_Synch_LibraryDB.html"
/reportType:Simple /logLevel:Verbose
/Exclude:Certificate /Exclude:Assembly /Exclude:Assembly:sersolsharedcode
/Exclude:Identical /Exclude:view:viewCoreLibraryDatabaseWithCodes
/Exclude:storedprocedure:prcUlrichsWebFeedRefresh2 /Exclude:view:viewCounterOutJournal

Posts: 3
Joined: Mon Jul 07, 2014 7:36 pm

Postby Admin » Thu Jul 10, 2014 2:48 pm

Hi Rick,

If I understand correctly, this error is probably happening because the assembly has been excluded. Then you would get this error if an object that depends on that assembly (such as a stored procedure or user-defined function) was being applied to the database without the underlying assembly.
Site Admin
Posts: 9
Joined: Sun Aug 15, 2004 10:44 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests