I am using SQL Server 2022. I have my database changes in version control using a Scripts folder created by SQL Compare (15.4.17.28422).
One of my tables has two filtered indexes. When I view the .sql file for the table in my scripts folder, the WHERE clause is present. When I use SQL Compare to compare the folder to the database table, it detects a difference in the index. The left side of the compare (from the scripts folder) does not show the WHERE clause in the SQL Compare summary view but the right side (DB side) does.
If I deploy it, it removes the filter from the index.
Help!
I am using SQL Server 2022. I have my database changes in version control using a Scripts folder created by SQL Compare (15.4.17.28422).
One of my tables has two filtered indexes. When I view the .sql file for the table in my scripts folder, the WHERE clause is present. When I use SQL Compare to compare the folder to the database table, it detects a difference in the index. The left side of the compare (from the scripts folder) does not show the WHERE clause in the SQL Compare summary view but the right side (DB side) does.
If I deploy it, it removes the filter from the index.
Help!