Professional SQL Server 7.0 development using SQL-DMO, SQL-NA and DTS

For developers building custom administration tools and applications, this book will introduce and explain DMO, DTS and NS. Throughout the book, a sample application will be developed showing how to use these technologies in an n-tier solution. This application will provide all the core functionality needed to manage a SQL Server including running and scheduling backups and security. From information on programmatically calling DTS, replication and the MSDE engine, to DNA applications and COM +, this book will enable you to fully exploit these object models in your applications. While most of the examples are in VB, using DMO with C++ is also covered.

Who is this Book for?

• Developers who want to leverage their programming skills to develop custom SQL Server administration tools for the distributed environment.
  
• This book assumes basic knowledge of SQL Server.

Table of contents

Chapter 1: Introducing SQL-DMF
Chapter 2: Introduction to Windows DNA Applications
Chapter 3: Introduction to SQL-DMO
Chapter 4: Creating and Managing Databases
Chapter 5: SQL Server Administration and Management
Chapter 6: Using SQL-NS
Chapter 7: Deploying Your Application
Chapter 8: Replication Management
Chapter 9: Introduction to Data Transformation Services (DTS)
Chapter 10: Using DTS Components
Chapter 11: Scaling Down with MSDE
Chapter 12: Using SQL-DMO with Visual C++
Appendix A: The Surveys Unlimited Application
Appendix B: Installing and Configuring MTS
Appendix C: Looking Ahead - Windows 2000 as as Application Server
Appendix D: Microsoft SQL Distributed Management Objects Library Reference
Appendix E: Microsoft SQL Server Namespace Reference
Appendix F: Microsoft Data Transformation Services Package Object Library Reference
Appendix G: Microsoft Data Transformation Services DataPump Scripting Object Library Reference