Professional SQL Server 7.0 Development Using SQL-DMO, SQL-DMO and DTS (Programmer to Programmer) Book

Despite its acronym-laden title, Professional SQL Server SQL-DMO, SQL-NS and DTS is actually a very readable and approachable guide to programming administrative modules for SQL Server 7. Aimed at the Visual Basic or C++ programmer, this book delivers a fine guide to the objects, API, and programmer strategies you'll need to do more with Microsoft databases.The goal of this text is let you perform a variety of database tasks programmatically, whether designing new databases, tables, and indexes, to backing-up, replicating, and copying data, using the SQL Distributed Management Framework (DMF). After reading this book, you should be able to write programs that automate common database administration tasks.This title begins with the objects that Enterprise Manager uses to do its work--the SQL Distributed Management Objects (SQL-DMO). The authors walk through the object model here and show off common tasks such as configuring SQL Server, creating indexes and doing backups programmatically. There's also good coverage of role-based security through objects, and a later section explores your options for managing replication in your own programs. While SQL-DMO exposes much of the underlying functionality of Enterprise Manager, the SQL Namespace (SQL-NS) object let you borrow the actual dialogue boxes and wizard screens in custom applications.A final group of objects, the Data Transformation Services (DTS), lets you copy and transform data between one data source and another. The authors look at the both the wizard-based DTS tools and the underlying objects for use within your own code.Besides a tutorial on some of the tasks that can be automated using SQL-DMF, this volume doubles as reference (with over 60 objects and 1,000 methods listed). This surprisingly useful and accessible title can get you started thinking on how to simplify database administration in custom programs using these powerful SQL Server APIs, both in standalone applications and in ASP-based Web pages. --Richard Dragan, amazon.comTopics covered: Introduction to SQL Server administration with SQL Distributed Management Framework (SQL-DMF), overview of Windows Distributed interNet Architecture (DNA), SQL Distributed Management Objects (SQL-DMO), starting, stopping and configuring servers; querying database and table information, building indexes, role-based security and user management, backup and restore with SQL-DMO, scheduling jobs with the SQL Agent, SQL Namespace (SQL-NS) objects for accessing Enterprise Manager dialogs and wizards, deploying SQL-DMF applications, replication management, Data Transformation Services (DTS): wizards, tools and programmatic access; installing and using the Microsoft Data Engine (MSDE), tutorial for using SQL-DMO with Visual C++, complete SQL-DMF object and method reference.Read More