Product Description

This book moves on from Professional SQL Server 7 and covers the latest developments in SQL Server 7 in depth - DMO, DTS and NS provide powerful tools within the Data Management Framework (DMF). DMO and NS are introduced and detailed with a practical case study that is built through most of the book. DTS objects are introduced via several stand-alone utilty applications. This book also shows how to integrate your DMF applications into Windows DNA (Distributed interNet Achitecture) applications and how to deploy a DMF application.

Product Details

• Amazon Sales Rank: #2443573 in Books
• Published on: 1999-12-01
• Original language: English
• Number of items: 1
• Binding: Paperback
• 743 pages

Amazon.co.uk Review
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.com

Topics 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.

Customer Reviews

Thorough coverage for important topics
This book may be a little advanced for anyone beginning SQL Server 7, so it would be wise to ensure you start off with a good knowledge base of SQL Server first.

Good coverage on the important stuff, it covers SQL-DMO, SQL-NS, DTS, MTS, and even has a section on MSDE. One thing I would have liked to have had with this book is a CDROM with the worked code examples.