Use where with variables

• 
  The WHERE clause in SQL Data Compare can call functions, which can execute arbitrary SQL. In your situation, perhaps you could extract part of the WHERE clause into a function, which can be defined differently on each database:

  CREATE FUNCTION dbo.ShouldIncludeRow(@id INT) RETURNS BIT AS
  BEGIN
  DECLARE @Code INT = 1
  ...
  END
  

  SQL Data Compare could then be configured to include rows WHERE dbo.ShouldIncludeRow(id) = 1
  
  Would this work for you?

  sam.blackburn February 27, 2017 06:09

  - 0 +
• 
  Sorry for being a bit amateur yet, where do I enter this function?

  glaucomorandini February 27, 2017 06:37

  - 0 +
• 
  You'd need to create the function in both databases, i.e. run that SQL in SSMS. I don't really understand enough about your setup to know whether that's something you'd want to do, though!

  sam.blackburn February 27, 2017 07:56

  - 0 +
• 
  Thanks a lot, man, it worked.

  glaucomorandini February 27, 2017 08:37

  - 0 +

Add comment

Please sign in to leave a comment.