Wednesday, February 26, 2014

Microsoft.SqlServer.Management.SMO

Hi All,

I’ve been using SMO heavily in my OSR data migration piece of work, and I’d like to share that with you.  To put SMO into context, I consider it as a programmatic way to interact with SSMS.
For CRUD actions, SqlClient is still very good. Very flexible compared to entity framework.
However, when we need extra flexibility, e.g., create/backup database, create/alter tables, especially running SQL with GO statement, SMO is the way to go.   

I’ve attached a Util class that demonstrates how it can be wrapped, and the dynamic SQL that gets generated by my program and executed via the Util class.

If you would like to know more, plenty of articles on MSND:
SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server


48 comments:

Unknown said...

ASP.NET training for website designing and development explore your better future and discover your creativity.
Live project training in Jaipur

Unknown said...

This is some useful information. Thank you for providing it.

apartments at Nungambakkam

Unknown said...

In your Microsoft SQL server information was really awesome and i can easily understand all provided information.I really appreciate the kind words .
selenium

Unknown said...


Really very nice blog information for this one and more technical skills are improve,i like that kind of post.

SAP training in Chennai

Priscilla said...

Really i enjoyed very much. And this may helpful for lot of peoples. So you are provided such a nice and great article within this.

SAP Training in Chennai

Unknown said...

Given information was very excellent & Great tips, and awesome way to get exert tips from everyone,not only i like that post all peoples like that post,because of all given information was wonderful and it's very helpful for me... SAP Training in Chennai

Unknown said...



This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.


SAP training in Chennai

Maani kamili said...

I am not sure the place you are getting your information, however good topic. I needs to spend some time studying more or understanding more. Thank you for wonderful information I was in search of this info for my mission.

Digital marketing company in Chennai

navya said...

Great Article
C# Training in Chennai | C# Online Training | ASP.NET Training in Chennai

C# Training in Chennai | Dot Net Training in Chennai | Dot Net Training in Chennai

Rajesh Sharma said...

Dear candidates if you want to get SEO training in Jaipur then click on SEO Institute

Brave Technologies said...

The information you shared is very interesting. cloud erp in chennai | enterprise resource planning in chennai

Jai Technomind said...

very useful and interesting info

Mobile Apps Training in Chennai | Android Training in Chennai |ios Training in Chennai

Anonymous said...

The people who are searching for the SEO Training Institute in Jaipur they can make contact with our marketing expert on WhatIsSEO.in and get more information about the SEO.

smarther3 said...
This comment has been removed by the author.
smarther3 said...


This blog explains the details about changing the ways of doing that business. That is understand well and doing some different process. Provides he best output of others. Thanks for this blog.

iOS App Development Company

Priya B said...

The information you shared is very interesting. Java Training in Chennai

Unknown said...

good scope infotech

Unknown said...

really super coaching center in IT sector reall time consultant is teaching for this institute in chennai bigdata hadoop in chennai

Unknown said...

hai
This is excellent information OCA Certification in chennai

sheikh said...
This comment has been removed by the author.
Unknown said...

Yeah I too love C#.Net looking for better postion in DotNet Industry, thanks very much for sharing the wondeful article here...
Best Online Software Training Institute | C#.Net Training

blackkutty said...

The data you shared is exceptionally fascinating
Article Submission sites | Latest Updates

Kamal said...

Extremely exceptionally pleasant blog data for this one and more specialized abilities are improve,i like that sort of post.
Education | Article Submission sites | Opencu | Technology

Unknown said...

myTectra Placement Portal is a Web based portal brings Potentials Employers and myTectra Candidates on a common platform for placement assistance

DeepikaOrange said...

Great Article...Thanks for sharing the best information.It was so good to read and useful to improve my knowledge as updated one.

QlikView Training in Chennai
QlikView Training

login hotmail said...

Great post. The tips and the ideas given in the post seems to be very much informative and useful

anirudh said...


I like your post very much. It is very much useful for my research. I hope you to share more info about this. Keep posting!!
Best DevOps Training Institute

nikitha josh said...

Such an excellent and interesting blog, do post like this more with more information, This was very useful, Thank you.
aviation training in Chennai
cabin crew course in Chennai
diploma in airline and airport management in Chennai
airport ground staff training in Chennai
Aviation Academy in Chennai
air hostess training in Chennai
airport management courses in Chennai
ground staff training in Chennai

kishore said...

Thanks for sharing an article like this. This information very helpful to me and I have also shared some useful information.
Corporate Training in Chennai
Corporate Training Companies in Chennai
Soft Skills Training in Chennai
JMeter Training in Chennai
Pega Training in Chennai
Appium Training in Chennai
Advanced Excel Training in Chennai
Oracle Training in Chennai
Social Media Marketing Courses in Chennai
Tableau Training in Chennai
Power BI Training in Chennai

rohit verma said...

With Sanjay Baghela, your business Website is in safe hands. He and his team are the best SEO Expert in India the leading digital marketing field. They work with the most trusted & advanced SEO strategies and tools to deliver the results, which you are expecting from the team. The Freelance Seo Expert In India of Sanjay Badhela is serving their SEO solutions and best known as the best SEO Consultant across the globe. You can Hire Seo consultant anytime from the team of best Freelance Seo Expert and can discuss the things to get better for your online business promotion.
Best SEO Expert In India and BEST SEO Company in India

for ict 99 said...

The effectiveness of IEEE Project Domains depends very much on the situation in which they are applied. In order to further improve IEEE Final Year Project Domains practices we need to explicitly describe and utilise our knowledge about software domains of software engineering Final Year Project Domains for CSE technologies. This paper suggests a modelling formalism for supporting systematic reuse of software engineering technologies during planning of software projects and improvement programmes in Final Year Project Centers in Chennai.

Software management seeks for decision support to identify technologies like JavaScript that meet best the goals and characteristics of a software project or improvement programme. JavaScript Training in Chennai Accessible experiences and repositories that effectively guide that technology selection are still lacking.

Aim of technology domain analysis is to describe the class of context situations (e.g., kinds of JavaScript software projects) in which a software engineering technology JavaScript Training in Chennai can be applied successfully

sangeeth said...

Interesting blog. Got a lotb of information about this technology.
pearson vue
German Language Course in Chennai
IELTS Coaching in Chennai
Japanese Classes in Chennai
Spoken English Classes in Chennai
TOEFL Coaching in Chennai
Informatica Training in Chennai
spanish classes in chennai
content writing course in chennai

The India said...

Popular Fashion Blogs in Surat
Fashion Blogger in Surat
Surat Blogger
Indian Fashion Blogger

Alwin Co Daan said...

Great Article. Thank you for sharing! Really an awesome post for every one.
Project Centers in Chennai

JavaScript Training in Chennai

Final Year Project Domains for IT

JavaScript Training in Chennai

priya said...

I have been reading for the past two days about your blogs and topics, still on fetching! Wondering about your words on each line was massively effective.
php online training in chennai
php programming center in chennai
php class in chennnai
php certification course
php developer training institution chennai
php training in chennnai
php mysql course in chennai
php institute in chennnai
php course in chennnai
php training with placement in chennnai
php developer course

priya said...

Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work.
appium online training
appium training centres in chennai
best appium training institute in chennnai
apppium course
mobile appium in chennnai
mobile training in chennnai
appium training institute in chennnai

TechMatrite said...

But as users, we are always keen to know about method where we can get some app or service for free. office professional plus 2019

w3webschool said...

Thanks for sharing such a most informative blog.... Waiting for the new updates...

Digital Marketing Course In Kolkata
Web Design Course In Kolkata
SEO Course In Kolkata

Gerardoavery cristian said...

But if you are considering top-grading your existing staff by putting them through a certification program, you'll want to look at the time involved as well as the cost and pass rates of the major risk management certifications. BVOP Business Management Certifications

telkahost said...

شرکت تلکا هاست پیشرو در میزبانی انواع وب سایت و هم چنین دارای انواع هاست فوق ارزان با کنترل پنل سی پنل میباشد.حتما از سایت ما دیدن کنید و از قیمت های مناسب برای انواع سرویس های وب و ثبت انواع دامنه شگفت زده شوید.

Anonymous said...

Кожаные сумки актуальны во все времена года, а также при грамотном использовании сочетаются практически с любой одеждой. Кожаная сумка отличается долгим временем ношения и прекраснымстильным внешним видом. При хорошем уходе сумочка из натурального природного вещества проработает гораздо дольше, нежели из искусственного, а также со временем она, как хорошее вино, становится прекраснее, раскрывая свою природную красоту. Отобрать кожаную сумку необходимо воспользовавшись современным недорогие сумки, где собрано достаточно вариантов сумок. На нашем сайте вы обнаружите отзывы клиентов, которые помогут и сделать хороший выбор сумочки.

divya said...

The blog which you have shared is more creative... Waiting for your upcoming data... nice blog
Ai & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai

Anonymous said...

Дамская сумочка это настоящий предмет люксовости. Дизайнеры не устают экспериментировать с текстурой, а также материалом, производя невероятные сумки из лучших веществ. Ну и наряду с такими необычными остаются неизменно привычнми классические силуэты из кожи, стильные и подкупающие своей элегантностью и высоким стилем. Качественная натуральная кожа, отборная фурнитура, большой опыт и влияние последних веяний европейской моды вдохновляют дизайнеро фирмы сумок на создание самых крутых коллекций. Новых откровением стала квадратная кожаная сумка. Украшенная стильными кругами из золотистых деталей, - она станет крутым элменетом вашего имиджа! Выбирайте бирюзовую, чтобы бысть стильной и заслужитьмужские взгляды.

Anonymous said...

Очень познавательныеда еще поразительно точнейшие онлайн гадания для познания вашего будущего - это исключительно то, что вы увидите на страницах нашего сайта. Будем ли мы вместе гадание онлайн является самым быстрым и простым вариантом для извлечения нужных информаций из энерегетического поля земли.

Deepa said...

Gone through this wonderful coures called Salesforce Certification Training in Dallas who are offering fully practical course, who parent is Salesforce Training in USA and they have students at Salesforce Training classes in Canada institutes.

Anonymous said...

Потрясающе интересныеи к тому же удивительно правдивые онлайн гадания для предсказания своего дня грядущего: это именно то, что вы увидите на сайте гаданий. Гадания на любовь и отношения, на картах является самым приятным и действенным способом для извлечения жизненных информаций из ментального поля Земли.

Anonymous said...

Невероятное число развлечений на компьютер выпускается ежемесячно. Самым простым вариантом приобрести востребованную игрушку является скачать игры через торрент на русском. Разбираться в стилях популярных игрушек не особо просто в результате нереального их многообразия. Скачивая игры с интернета вы получаете больший уровень кибербезопасности. "Пираты" найдут способ использовать простоту клиентов и распространять рекламные модули. Скачка Torrent считается легкой процедурой, удовлетворительной как минимум для начинающих пользователей.

Anonymous said...

Thank you for the helpful article. I recommend paying attention to my site, https://youtube-to-mp3-converter.com/. Youtube to mp3 service allows you to download music to your iPhone for free in less than a minute.