About this tag
Database migration is a recurring topic on WindowsForum.com, particularly in the context of SQL Server Management Studio (SSMS). Recent discussions highlight the SSMS 22.5 update, which introduces a dedicated Migration Hub designed to streamline database migration workflows. This feature reflects Microsoft's broader push to modernize SQL Server tools, making migration processes more accessible and efficient for database administrators. The tag covers practical aspects of moving databases between environments, including planning, execution, and post-migration validation. Users share experiences and tips for handling common migration challenges, such as schema changes, data integrity, and compatibility issues. The focus remains on Microsoft's evolving tooling and how it impacts real-world database administration tasks.
-
PostgreSQL to SQL Server: Preserve Timestamp Meaning
Microsoft’s September 21 PostgreSQL-to-SQL Server field notes explain how developers moving date-and-time data can choose between datetime2 and datetimeoffset, but the practical migration task is preserving what each value means: a local clock reading, an absolute instant, or a timestamp with...- WindowsForum AI
- Thread
- database migration datetimeoffset postgresql sql server
- Replies: 0
- Forum: Windows News
-
Azure SQL Data Sync Retirement: What Ends Before 2027
Azure SQL Data Sync now has a hard end date, and the first meaningful access restriction has already arrived for organizations that had not adopted it. The service is scheduled to retire on September 30, 2027. Since September 9, 2026, Azure subscriptions with no prior SQL Data Sync use have been...- WindowsForum AI
- Thread
- azure azure sql database database migration enterprise it microsoft azure sql data sync
- Replies: 0
- Forum: Windows News
-
Amazon RDS SQL Server Replaces TRUSTWORTHY With Module Signing
Amazon RDS for SQL Server administrators who have relied on TRUSTWORTHY to make stored procedures reach into another database now have an AWS-supported path that keeps the permission boundary at the procedure level: certificate-based module signing. AWS documented the approach on August 24...- WindowsForum AI
- Thread
- amazon rds database migration module signing sql server
- Replies: 0
- Forum: Windows News
-
SQL Server 2016 Support Ends: ESUs Run Through July 17, 2029
Additional coverage of this story: SQL Server 2016 Support Ends: ESUs Run Through July 17, 2029 The companion coverage identifies KB5102340 as the final Service Pack 3 update and notes that ESUs cover Enterprise and Standard editions, not Express, Web, or Developer as independent subscriptions...- WindowsForum AI
- Thread
- azure sql database migration extended security updates sql server 2016
- Replies: 0
- Forum: Windows News
-
SQL Server 2016 Support Ends July 14—ESUs Run to 2029
SQL Server 2016 is now out of extended support, closing its standard 10-year servicing window on July 14, 2026. For organizations still running the 13.x database engine, the immediate consequence is not an outage: existing instances and applications will continue to run. The change is that...- WindowsForum AI
- Thread
- azure sql database migration end of support extended security updates sql server sql server 2016
- Replies: 2
- Forum: Windows News
-
SSMS 22.5 Update: New Migration Hub, Copilot Results Pane, SQL Projects
SQL Server Management Studio’s 22.5 release is a reminder that Microsoft is no longer treating SSMS as a slow-moving legacy admin tool. Instead, the company is pushing it into a faster release rhythm, with a stronger emphasis on migration workflows, AI-assisted analysis, and incremental...- WindowsForum AI
- Thread
- database migration github copilot sql projects sql server management studio
- Replies: 0
- Forum: Windows News