As organizations transition to cloud environments, they face significant challenges in migrating relational database management systems (RDBMS) to the cloud, primarily due to issues surrounding full SQL support, consistency, scalability, and geo-partitioning. Traditional RDBMS have struggled with cloud adaptations, leading to the rise of NoSQL databases like Apache Cassandra, which offer scalability and resilience at the cost of simpler query operations and consistency. These limitations necessitate complex data management logic at the application level, complicating migrations. To overcome these challenges, cloud-native solutions like CockroachDB have emerged, combining transactional integrity, scalability, and geo-partitioning while ensuring full SQL support and ACID compliance, making them well-suited for modern cloud-based applications.