![]() All functions available in SQL Server Management Studio are available in SMO but SMO includes several more features than Management Studio. SMO allows you to programmatically manipulate SQL Server (2008, 2005, 2000 and 7.0). ![]() Server Management Objects (SMO) is a collection of classes that represent the core SQL Server Database Engine objects. In this article, I will shortly describe what SMO is and how to use it for database backup and restore. ![]() In some cases, you need to backup databases programmatically and this could be done via Server Management objects. But what if Management Studio is not installed? In this case, you can use sqlcmd utility. This is not a problem when you have SQL Server Management Studio installed. Sometimes, developers need to backup and restore databases.
0 Comments
Leave a Reply. |