Filegroup Reference And Partitioning Scheme Is Not Supported In This Version Of Sql Server

Hello everybody,

I want to share how to fight with error:

Filegroup reference and partitioning scheme' is not supported in this version of SQL Server.

Today I wanted to move Acumatica to SQL Azure and faced that error message. After research I found that I have to remove the two "ON [PRIMARY]" parts of the create statement and it will work. I mean creating of db

Encountering SQL Server errors like the one discussed in this article can be a roadblock in your Acumatica development journey. But don’t let technical challenges slow you down! If you’re facing unique customization needs or require tailored solutions for your Acumatica environment, we’re here to help. Leave a customization request today, and let’s work together to optimize your Acumatica experience. Your success is our priority—let’s build something amazing!