I have been working with SQL Server for a couple of years. I have heard about SMO but I don’t know anything about it. What are the benefits of using it? Should I learn and start using SMO in my SQL Server projects (mainly data warehouse development)? Why?
Advertisement
Answer
It depends on what you’re trying to do. SMO is SQL Server Management Objects. It is a set of libraries for managing SQL Server programmatically. For example if you’re trying to build a clone of SQL Maangement Studio then SMO is something you probably want to look into. OR if you’re trying to manpulate the structure of your database programmatically then that’s the place to look.
Otherwise, I wouldn’t bother.