Using .Net and SMO on multiple SQL versions
-
Is there a way to create a single .Net application that uses SMO and have it work correctly on a box with SQL 2008 R2 as well as on a box with SQL 2012? The two solutions I've found so far are: 1) Create a version of the application for each version of SMO. 2) Create a version of the application with the latest SMO. Install the latest SMO on all client boxes. I'm not really thrilled with either option. Any thoughts or help is greatly appreciated
"Coming soon"
-
Is there a way to create a single .Net application that uses SMO and have it work correctly on a box with SQL 2008 R2 as well as on a box with SQL 2012? The two solutions I've found so far are: 1) Create a version of the application for each version of SMO. 2) Create a version of the application with the latest SMO. Install the latest SMO on all client boxes. I'm not really thrilled with either option. Any thoughts or help is greatly appreciated
"Coming soon"
EricCiz wrote:
I'm not really thrilled with either option.
I don't know any others besides these, do you? The second option "sounds" like a simple one; just program against the latest interface and update all the components on the client-computers. The first option "is" the simple one; create a version-agnostic wrapper, and two version-specific implementations (as small as possible).
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]