SMO allows you to backup databases very easily. When you want to drop a database, just call the Drop() method of the Database object. More about properties can be found on MSDN. SMO allows you to set the Growth of a database and other properties. LogFile.GrowthType = FileGrowthType.Percent LogFile logFile = new LogFile(database, " E:\Data\MyNewDatabase\MyNewDatabase.ldf") " PriValue", E:\Data\MyNewDatabase\MyNewDatabase.mdf") ĭtPrimary.GrowthType = FileGrowthType.KB ĭ(dtPrimary)
When the references are added, you must add two using statements for these namespaces:ĭatabase database = new Database(srv, " MyNewDatabase") ĭ( new FileGroup(database, " PRIMARY")) ĭataFile dtPrimary = new DataFile(database.FileGroups, To get started with SMO, first you must add references in Visual Studio. When you want to connect to SQL Server 2005 (or later version), you can user SQL Server SMO. SMO can't be used for SQL Servers with compatibility level 60 or 65.
This allows developers to create applications for various SQL Server versions. SMO is compatible with SQL Server 2000 and SQL Server 7.0. SMO is easier to use than SQL-DMO and adds functionality to support the new features in SQL Server 2005. SMO is a descendent of SQL Server Distributed Management Objects (SQL-DMO). All functions available in SQL Server Management Studio are available in SMO, but SMO includes several more features than Management Studio.
SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server. (People who are familiar with SMO can jump to the next section.) Background
STORED PROCEDURE TUTORIAL ADVENTUREWORKS DATABASE HOW TO
Now I want to share my knowledge with others.īefore I will show examples of how to use SMO for various problems, I think it is appropriate to describe what Server Management Objects are. I picked up a lot of knowledge and it really made me so excited. When I passed the exam, I decided to continue my investigation of SMO. When I was preparing for exam 70-433, I found that one objective was about Server Management Objects. Enumerating databases, filegroups, and files.
0 kommentar(er)
