Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue while creating ONLINE indexes for localhost. #578

Open
AnuradhaKhade2018 opened this issue Aug 20, 2024 Discussed in #576 · 1 comment
Open

Issue while creating ONLINE indexes for localhost. #578

AnuradhaKhade2018 opened this issue Aug 20, 2024 Discussed in #576 · 1 comment

Comments

@AnuradhaKhade2018
Copy link

Discussed in #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
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants