search

wise-coders / dbschema

DbSchema Database Designer
https://dbschema.com
67 stars 3 forks source link

SQL Server Filtered Indexes Not Picked Up Properly #104

Closed NeilN1 closed 1 year ago

NeilN1 commented 1 year ago

Latest version of DbSchema.

Database has: CREATE UNIQUE NONCLUSTERED INDEX [IX_Contact_MemberId] ON [dbo].[Contact] ( [MemberId] ASC ) WHERE ([MemberId] IS NOT NULL)

Model has: CREATE UNIQUE INDEX IX_Contact_MemberId ON MOBILECRM.dbo.Contact ( MemberId );

The WHERE clause is not picked up.

wise-coders commented 1 year ago

Hello, We will have a beta version ready right tomorrow morning, with the fix: https://dbschema.com/beta.php Please let me know if this works fine.

NeilN1 commented 1 year ago

@wise-coders Build 230522.

I refreshed the table and it said the schemas were identical. Dropped index, refreshed, created index, refreshed, and I still get:

CREATE UNIQUE INDEX IX_Contact_MemberId ON MOBILECRM.dbo.Contact ( MemberId ); GO

wise-coders commented 1 year ago

Do you get the same if you start a fresh model by reverse engineering the schema from the database?