Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

SQL Server database table partition

0

We are migrating the on-premises SQL server databases to AWS RDS SQL server. The source database have table partition. I am assuming RDS SQL Server 2019/2022 standard edition supports the table partition. I am unable to find any AWS links for same. can you please confirm about table partition.

Thanks, Sanjeev Koppella

Topics
Migration & ModernizationDatabase
Tags
Microsoft SQL ServerAmazon RDS for SQL ServerGeneral Database MigrationsDatabase
Language
English
asked 2 years ago687 views
1 Answer
2
Accepted Answer

Hi Sanjeev,

The following table confirms that table partitiion is supported for Standard Edition: https://docs.aws.amazon.com/prescriptive-guidance/latest/evaluate-downgrading-sql-server-edition/compare.html

Table and index partitioning

Enterprise Edition: Yes

Standard Edition: Yes (SQL Server 2016 SP1 and later)

Best,

Didier

EXPERT
answered 2 years ago
EXPERT
reviewed 2 years ago
EXPERT
reviewed 2 years ago
EXPERT
reviewed 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content