To Azure SQL Database from SQL Server 2008
summary
Migrates SQL Server 2008 workloads into Azure SQL Database by listing concrete fixes: replaces GETDATE() with a long local-time expression to avoid UTC problems, removes linked servers by creating 13 external tables plus eight views and four stored procedures, swaps SQL Agent jobs for PowerShell runbooks or elastic jobs, and replaces sp_send_dbmail with an external mail program. Provides a converted toolkit called sp_Blitz for Azure SQL DB (scripted search-and-replace) and notes bugs found and workarounds used.
AI-written summary · about
chapters (7)
related talks
50mSQL Modernization Journey with Tools, Assets & Migration Best Practices
51mAzure SQL Database - Where is my SQL Agent?
50mMigrating data solutions to the cloud - a checklist.
46mSQL Migrations to Azure Made Easy
56mMigrate Databases to the Cloud - Why, How and Best Practices
01h 02mLearn Live: Migrate SQL workloads to Azure Managed Instances
44mAccelerate your Oracle & Mainframe Modernization journey to Azure SQL
49mIt keeps getting easier to move Oracle and Open Source workloads to Azure