I'm seeing an error where SQL Compare can't compare a database with a partition function with a null boundary.
It's pretty easy to reliably reproduce:
1)run this against a database
create partition function test_pf (date) as range LEFT for values(cast(NULL as date))
2) try to compare with another database
You get the error:
Value cannot be null.
Parameter name: value
It's pretty easy to reliably reproduce:
1)run this against a database
create partition function test_pf (date) as range LEFT for values(cast(NULL as date))
2) try to compare with another database
You get the error:
Value cannot be null.
Parameter name: value