Activity overview
Latest activity by Toni Feltman
Good Morning Eddie, I still don't think you understand. See #1 in my last reply. The WHERE clause on the Index IS in the script AND on the DB Table. How can I send the files to you? / comments
Good Morning Eddie, I still don't think you understand. See #1 in my last reply. The WHERE clause on the Index IS in the script AND on the DB Table. How can I send the files to you?
To simplify: 1. Our scripts folder is the source. It does contain the filter on the indexes. 2. The SQL Server DB is the destination. The table in the DB contains the filter on the indexes too. 3. When I run SQL Compare, it says that the source file does not contain the filter. 4. I thought maybe it was a visual thing and that SQL Compare didn't really think there was a difference, so I deployed. When I did, the filter was removed in the DB. I will send you a .zip file with the file from our scripts folder AND the DDL from SSMS. Where can I send it. Also, if you want to hop on a Teams call, I can show you. Thanks! / comments
To simplify:1. Our scripts folder is the source. It does contain the filter on the indexes. 2. The SQL Server DB is the destination. The table in the DB contains the filter on the indexes too.3. Wh...
Filtered Indexes are not compared properly
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 ...