Lesson Learned #502: Comparing and Transferring Azure SQL Databases Table Structures Using SMO
This last week, I worked on a service request that we need to compare the existing tables of a database placed on a Azure SQL Server with another hand. If the table doesn't exist in the target database the intention is to have a script of the table and recreate the table in the target. Following, I would like to share my lessons learned here.Lesson Learned #464: Utilizing SMO's Scripting Option in Azure SQL Database.
Today, I encountered a unique service request from a customer inquiring about alternative methods to script out a table and all its dependencies in Azure SQL Database. Traditionally, several approaches are employed, such as utilizing stored procedures like sp_help , sp_depends , or functions like object_definition or SSMS GUI. These methods, while useful, but, I would like to share other options using SQL Server Management Objects (SMO).
