Move from newtonsoft to System.Text.Json

[SimonCropp]

any chance of this happening?

[shueybubbles]

There are 3 primary consumers of newtonsoft in SMO

1. The tests. That one is probably easy to change.
2. The Notebook script writer. That one is probably easy to change. I would also consider removing the Notebook DLL from the regular SMO nuget package into its own package.
3. The Assessment extensions DLL. That one is less easy to change because the newtonsoft dependency comes from the Assessment package upstream, which we don't own. I would consider removing the Assessment extensions DLL from the SMO package and put it in its own package.

That said, if your SMO application doesn't use the notebook writer or the assessment extensions, you can probably not bother installing newtonsoft with it.

[SimonCropp]

the problem is that Microsoft.SqlServer.SqlManagementObjects has a dependency on NewtonSoft.Json. so all apps that consume Microsoft.SqlServer.SqlManagementObjects are forced to have NewtonSoft.Json.