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

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, chengvoon.tong

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
    /Exclude:Assembly:sersolsharedcode
    /Exclude:Assembly AND /Exclude:Assembly:sersolsharedcode

However SQL Compare Pro keeps failing with the error message:
Code: Select all
Error: Synchronization of 'DBMSSQL2.Devqa.sersol.il.pqe\\COREDB3.LibraryDB' and '87P7WK1.Devqa.sersol.il.pqe,1433.LibraryDB' failed: Assembly 'sersolsharedcode,
version=1.0.0.0, 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
sqlcompare
/server1:DBMSSQL2.Devqa.sersol.il.pqe\\COREDB3 /DB1:LibraryDB
/server2:87P7WK1.Devqa.sersol.il.pqe,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


Thanks,
Rick
MrSuaveh
 
Posts: 1
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.
Admin
Site Admin
 
Posts: 9
Joined: Sun Aug 15, 2004 10:44 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests