Extended properties not supported on Azure Sql? Is there a plan to support? #178

Activity

1. shueybubbles commented on Oct 31, 2024

   

   David Shiflet (shueybubbles)

   on Oct 31, 2024

   Contributor

   More actions

   Double check how you set your scripting options. I enable "Script extended properties" in SSMS in "Tools/Options/SQL Server Object Explorer/Scripting" and when I "Script Table As Create" in OE it includes EP scripts

   I can cross script from SQL Server to Azure SQL Database too, and it includes EPs

   
2. ScottyTarvan commented on Nov 4, 2024

   

   ScottyTarvan

   on Nov 4, 2024

   Author

   More actions

   Im using the SMO objects in code only, not in SSMS or Azure Data Studio. There is an inconsistent deployment of extended properties for different objects. For tables it will create the extended properties but for other objects like views, stored procedures, indexes it does not create them. Ill investigate the options you mention above and see if that makes a difference.
3. ScottyTarvan commented on Nov 4, 2024

   

   ScottyTarvan

   on Nov 4, 2024

   Author

   More actions

   I have managed to get this to work by executing the SMO extended property after I create the object. This is different behaviour from tables that create the extended properties at the same time as table creation.

   Eg.

   //create SMO procedure in code not shown
   
   var smoProperty = new SMOProperty(smoProcedure, "InstanceId", asset.InstanceId.ToString());
   smoProcedure.ExtendedProperties.Add(smoProperty);
   
   //does not create EP
   smoProcedure.Create();
   
   //have to run this to create EP
   smoProperty.Create();
   
   
4. shueybubbles commented on Nov 4, 2024

   

   David Shiflet (shueybubbles)

   on Nov 4, 2024

   Contributor

   More actions

   I see. I misread the original issue to mean you were trying to generate scripts from an existing database.
   It's a weird difference in behavior. At this point, though, it's probably more risky to fix it than to leave it as-is. There are probably other apps that directly or indirectly depend on the current behavior.