search

erikbra / grate

grate - the SQL scripts migration runner
MIT License
187 stars 36 forks source link

Issue while creating ONLINE indexes for localhost. #578

Open AnuradhaKhade2018 opened 3 weeks ago

AnuradhaKhade2018 commented 3 weeks ago

Discussed in https://github.com/erikbra/grate/discussions/576

Originally posted by **anuksap** August 20, 2024 Hello Team, I was trying to migrate from rh to grate. So I executed grate command locally to see changes on localhost . But it got failed for online indexes. When I did ONLINE = OFF it works. But rh works totally fine for Online = ON. Could you please assist if anything I am missing. Below are the snippets from logs Online index operations can only be performed in Enterprise edition of SQL Server or Azure SQL Edge.
PagesplitPeter commented 3 weeks ago

That is by design of SQL Server and not something Grate can change.

Doing a index create or rebuild with Index ONLINE = ON is an enterprise feature

Microsoft has publish the difference between the editions on Editions and supported features of SQL Server 2022

I think it will work in developer edition also.