data migration Archives

Tech Optimizer

July 1, 2025

Fluent Commerce’s approach to near-zero downtime Amazon Aurora PostgreSQL upgrade at 32 TB scale using snapshots and AWS DMS ongoing replication

Fluent Commerce utilizes Amazon Aurora PostgreSQL-Compatible Edition as its OLTP database engine to manage complex customer search queries. The company migrated to AWS Graviton instances to enhance performance and cost-efficiency, requiring a major version upgrade from Aurora PostgreSQL-Compatible 10.14 to 12.4 or higher. The migration involved upgrading over 350 production databases, some as large as 32 TB, using AWS Database Migration Service (AWS DMS) and various upgrade strategies to minimize downtime. The migration process included configuring replication slots, creating snapshots, and validating data between source and target databases. AWS DMS was chosen for its cost-effectiveness, seamless integration with AWS services, and capabilities for ongoing data replication with minimal downtime. The cutover process involved updating application configurations, managing sequence numbers, and ensuring optimal performance through vacuuming and analyzing tables.

Winsage

June 20, 2025

How Uniphore achieved 30% cost savings by modernizing Windows servers on AWS

Uniphore is an AI innovation company that faced challenges with its legacy Windows Server infrastructure, which was costly and raised security concerns due to its end-of-support status. To modernize, Uniphore utilized Amazon Web Services (AWS) for containerization and cloud-native solutions, achieving a 30% reduction in costs and improved operational capabilities. The migration involved transitioning from 50 bare-metal Windows Server 2008 R2 instances to a Linux environment on AWS, optimizing call-center analytics workloads and enabling better training of large language models. The modernization strategy included three key areas: application modernization through refactoring and containerization, a custom data migration solution using Type 2 hypervisor technology, and a cloud infrastructure setup with Amazon EC2, Amazon EKS, Amazon EFS, and Amazon S3. The migration was executed in three phases: deploying the hypervisor and DataSync agent, secure data migration and validation, and production cutover with application deployment. Best practices adopted during the process included Infrastructure as Code (IaC) with Terraform, CI/CD pipelines using GitLab, comprehensive monitoring with DATADOG and CloudWatch, and enforcement of AWS Backup policies. The modernization resulted in benefits such as improved scalability and performance, flexibility and portability of applications, enhanced security and compliance, efficient data management, reduced operational overhead, and significant cost savings.

Winsage

June 18, 2025

Windows 11 user has 30 years of ‘irreplaceable photos and work’ locked away in OneDrive – and Microsoft’s silence is deafening

A Reddit user experienced account suspension on OneDrive while transferring data from old drives, resulting in loss of access to their files. The account was locked without warning or explanation, and attempts to contact Microsoft support yielded only automated responses. The user criticized the lack of accountability and transparency from Microsoft regarding the suspension. This incident highlights the importance of maintaining multiple copies of data across different locations to prevent loss and raises concerns about Microsoft's handling of account suspensions and communication with users.

Winsage

June 17, 2025

Microsoft Confirms Windows Upgrade Choice—100 Day Deadline Nears

A flaw in Windows 11 related to update KB5063060 is causing installation failures for many users, particularly in the gaming community, with error codes such as 0x800f0922, 0x80070002, 0x80070306, and 0x800f0991. Microsoft has announced an additional upgrade option for at least 240 million users still on Windows 10, as support will be withdrawn in just over 100 days. A new PC-to-PC migration experience is being rolled out to help users transfer files and settings during setup, and a Windows Migration feature integrated within the Windows Backup tool is being tested to assist those unable to upgrade due to hardware limitations. This feature is currently hidden in the latest release preview build but can be activated with a specific feature ID.

Tech Optimizer

June 2, 2025

Streamline code conversion and testing from Microsoft SQL Server and Oracle to PostgreSQL with Amazon Bedrock

Organizations are transitioning from legacy database systems like Microsoft SQL Server and Oracle to open-source alternatives such as PostgreSQL to reduce costs and enhance scalability. This migration process involves several steps, including schema conversion, business logic transformation, data migration, application changes, and performance tuning. Amazon Bedrock aids this process by automating schema and code conversion, data transformation, identifying code compatibility issues, and generating test cases for validation. The migration challenges include adapting database objects to PostgreSQL's syntax, converting stored procedures and functions, executing ETL processes for data accuracy, modifying application code, and optimizing performance. Amazon Bedrock utilizes generative AI to simplify these tasks, significantly reducing manual effort and errors. An example of code conversion from Microsoft SQL Server to PostgreSQL is provided, illustrating how to convert a stored procedure into a PostgreSQL function while generating corresponding test cases. The process involves using the Amazon Bedrock chat interface to submit prompts for conversion and validation. To support the migration, table creation scripts for the Employees and SalaryUpdateLog tables are included, along with test data that covers various employee scenarios. This data allows for comprehensive testing of the converted function, ensuring it correctly applies salary updates based on specified criteria.

Winsage

May 23, 2025

Windows 10 Support Is Ending: Flipkart says it’s time to upgrade to a Windows 11 PC

Microsoft will end support for Windows 10 on October 14, 2025, meaning users will no longer receive updates, security patches, or new features. Flipkart is offering exclusive exchange discounts for customers trading in old Windows 10 laptops for select Windows 11 models. Windows 11 provides faster performance, longer battery life, and enhanced security features compared to Windows 10. Copilot+ PCs, which run Windows 11, include integrated AI features and improved battery life, catering to designers, students, and professionals.

Winsage

May 17, 2025

Best Windows apps this week

In this week's roundup of applications for Windows 10 and 11, it is noted that consumer support for Windows 10 will end in October 2025, but users can purchase a year of extended support and receive three years of security updates for Microsoft 365 apps. New applications highlighted include: - DiskCopy: Free disk and partition cloning software for backing up partitions or entire disks, facilitating data migration. - IrfanView: An image viewer that now includes batch file multithreading and new hotkeys in its latest version. - Registry Finder: A freeware tool for managing the Windows Registry, with improved search capabilities and usability.

Tech Optimizer

May 14, 2025

Databricks adds Postgres database with $1B Neon acquisition

Databricks announced its intention to acquire Neon, a developer of a cloud-based dataset platform built on PostgreSQL, to enhance capabilities for developers and autonomous AI agents. The acquisition's estimated value is approximately billion, although financial specifics remain undisclosed. Neon, based in Menlo Park, California, raised .6 million prior to the acquisition. This move will expand Databricks' portfolio with open-source database functionalities, aiding in the development of data and AI applications. Databricks has made several acquisitions to support generative AI development, including MosaicML, Arcion, Einblick, Lilac AI, BladeBridge, and Tabular, with some valued at over billion. Neon's platform allows users to create PostgreSQL instances quickly and features a disaggregated compute and storage architecture for automatic scaling. The Neon team will join Databricks following the acquisition's completion.

AppWizard

May 5, 2025

Microsoft shuts down Skype — messenger worked for over 20 years

The Skype app officially ceased operations on May 5. Microsoft announced that all Skype accounts and users' chat histories will be transitioned to the Microsoft Teams app. Skype users can upgrade to the complimentary version of Microsoft Teams, which retains most of Skype's features and introduces new functionalities. Users can sign in to Microsoft Teams Free using their existing Skype credentials, with contacts and chat histories automatically transferred. A notification will guide users through the migration process. Users who do not adopt Microsoft Teams Free can save their Skype data. Skype was launched in 2003 by Niklas Zennström and Janus Friis and was acquired by Microsoft in 2011 for .5 billion. Microsoft introduced Teams in 2017 as a collaboration platform based on Skype.

Tech Optimizer

April 21, 2025

Best practices to handle AWS DMS tasks during PostgreSQL upgrades

The AWS Database Migration Service (AWS DMS) provides a managed solution for migrating and replicating databases to AWS, supporting both homogeneous and heterogeneous migrations. It allows seamless data migration from PostgreSQL databases to any supported target and vice versa. Open-source PostgreSQL regularly releases new versions, and Amazon RDS aims to support these within five months. Upgrading PostgreSQL instances is essential for security and compliance. Minor version upgrades focus on security and bug fixes without adding new functionalities, while major upgrades can change system tables and data formats. AWS DMS tasks require careful management during PostgreSQL upgrades. For minor upgrades, ongoing DMS tasks should be stopped and then resumed post-upgrade. For major upgrades, replication slots must be dropped before the upgrade, which will invalidate ongoing DMS tasks. After the upgrade, a new CDC-only task should be created to resume data migration. Minor version upgrades of the target PostgreSQL database do not affect AWS DMS CDC tasks, but major upgrades require stopping the DMS task, performing the upgrade, and ensuring compatibility with the replication instance before resuming the task.