Using SMO for DDL with SQL Server

<P class=MsoNormal style=”MARGIN: 0in 0in 0pt”><FONT face=Calibri size=3>My </FONT><FONT face=Calibri size=3>June 2007 Data Points column</FONT><FONT face=Calibri size=3> has been posted to the </FONT><FONT face=Calibri size=3>MSDN Magazine web site</FONT><FONT face=Calibri size=3>. This edition is titled “SQL Server Management Objects”</FONT><FONT face=Calibri size=3>.</FONT></P> <P class=MsoNormal style=”MARGIN: 0in 0in 0pt” mce_keep=”true”> </P> <P class=MsoNormal style=”MARGIN: 0in 0in 0pt”><FONT face=Calibri size=3></FONT></P> <P class=MsoNormal style=”MARGIN: 0in 0in 0pt”><FONT face=Calibri size=3></FONT></P> <P class=MsoNormal style=”MARGIN: 0in 0in 0pt”></P> <P class=MsoNormal style=”MARGIN: 0in 0in 0pt”><FONT face=Calibri size=3> <IMG style=”WIDTH: 263px; HEIGHT: 345px” height=345 src=”http://msdn.microsoft.com/msdnmag/images/covers/June07Coverlg.gif”; width=263 border=0 mce_src=”http://msdn.microsoft.com/msdnmag/images/covers/June07Coverlg.gif”>;</FONT></P> <P class=MsoNormal style=”MARGIN: 0in 0in 0pt”><FONT face=Calibri size=3></FONT> </P> <P class=MsoNormal style=”MARGIN: 0in 0in 0pt”><FONT face=Calibri size=3>Here is an excerpt from the article:</FONT></P> <BLOCKQUOTE> <P class=clsDropCap xmlid=”PARAJUNE2007DATAPOINTS001” font=”franklingothiccondensed”>”Not only must database developers query and manipulate data, but they must also perform administrative tasks on a regular basis. SQL Server™ Management Objects (SMO) offer developers a robust toolset for operations such as backing up and restoring databases, and issuing Data Definition Language (DDL) commands. Using SQL SMO you can also connect to SQL Server, iterate through a collection of database objects and perform a variety of tasks against them.</P> <P xmlid="PARAJUNE2007DATAPOINTS002" font="minionmmroman">In this column, I discuss how SMO can be used to examine a database’s objects and to perform a variety of administrative tasks. Specifically, I cover topics such as how to design your project to use SMO and how to connect to a server. I also walk through a sample application that issues DDL or Data Manipulation Language (DML) commands against the database. Finally, I demonstrate how to use SMO to perform database backups, restores, and backup verification.”</P></BLOCKQUOTE>

Tweet Post Share Update RSS

Hi, I'm John Papa. I author this blog, create courses for Pluralsight and am a Google Developer Expert and Microsoft Regional Director. I travel speaking at events and train technology thought leaders

Tags:
All