How To: representing a variable passed to a compiled .net method

Ok, so here is the story ..

My organization has a database that we sell to customers. Sometimes we have to make certain changes for the client.

I am developing an extension for Sql Server Management Studio (SSMS) 2008 R2 SP1.

This extension will generate DDL and collect schema information to go to a locally hosted web service. To create a DDL, I create scripted database objects inside SSMS through SMO. ( Example )

SSMS 2008 has a convenient feature to do this basically the same as me. (Well, why not use SSMS, because it has to be automated using my tool, thanks)

SSMS does it right; I can’t figure out how to do it right. They set the appropriate script parameters ( MS Refrence ). When creating DDL, you must do something in a specific order. (Database β†’ tables β†’ Keys β†’ Views β†’ -> etc.) MS does this order correctly using the correct script parameters.

My attempts to redefine the method failed, and my research did not provide the necessary information.

...

[LONG SHORT PAGE]

I need a way to override the "Script (ScriptingOptions scriptingOptions)" method. Method for viewing set script parameters - Maybe I’m even mistaken, and the manual is welcome. I would still like to know if I can and how, although

+4
source share

Source: https://habr.com/ru/post/1401894/


All Articles