Oracle8i and Microsoft SQL Server Integration (With CD-ROM) [Paperback]

Stephen Chelack (Author)

Book Description

ISBN-10: 0764546996 | ISBN-13: 978-0764546990 | Publication Date: January 15, 2001

This professional reference, written by a database guru with over 12 years of experience, gives the inside scoop on Oracle8i and Microsoft SQL Server 2000, the two hottest database products on the market. It provides information on moving from one product to the other, recommends which is better for certain applications and situations, and also explains how to work with both databases simultaneously.

Editorial Reviews

From the Back Cover

Master the Complexities of a Multi-Database Environment
Introducing the first-ever guide to Oracle-SQL Server integration -- an indispensable reference if you're migrating from one relational database management system to the other or if you need to make separate databases work together in harmony. Delving deep into the inner workings of each RDBMMS, veteran database architecture Stephen Chelack shows you in detail how to migrate database objects and codes, integrate through linked servers or UDA, harness XML for Internet integration, and much more.

Proven Solutions to Database Integration Challenges
* Get the lowdown on how MSDE and Oracle Instance work
* Understand data storage, optimization, and locking in each RDBMS
* Overcome typical hurdles in migrating database objects and code
* Master SQL Server DTS and Oracle Migration Workbench
* Put Universal Data Access, replication, and other integration options to work
* Use Oracle and Microsoft development tools to create integrated applications
* Orchestrate Internet database integration using XML
* Prepare for Microsoft BizTalk Server and other next-generation technologies
Microsoft SQL Server 2000 120-day Enterprise Evaluation Edition on CD-COM

About the Author

STEPHEN CHELACK, chief database architecture at Merak Projects, has more than 10 years of relational database experience. He has presented papers at both Microsoft and Oracle conferences.

Product Details

• Paperback: 547 pages
• Publisher: Wiley (January 15, 2001)
• Language: English
• ISBN-10: 0764546996
• ISBN-13: 978-0764546990
• Product Dimensions: 9 x 7.4 x 1.4 inches
• Shipping Weight: 2 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #4,081,058 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

12 of 12 people found the following review helpful:

4.0 out of 5 stars Combining Sql Server and Oracle together, March 7, 2001

By 

"apsrose" - See all my reviews

This review is from: Oracle8i and Microsoft SQL Server Integration (With CD-ROM) (Paperback)

This book examines the most recent verions of Oracle 8i and sql server and compares one with the other in a non-biased way. Features of both are examined and explained. Microsoft has engineered Sql server with a particular strategy in mind argues the author. This strategy is integration with all the other Microsoft products. Oracle in contrast has the strategy of integrating everything into its core database product. The most useful information in this book are the descriptions of the integration tools to move database schema info and data between the two environments. Sql server has something called DTS, while Oracle has the Oracle migration workbench. However, there are several other tools some of which use OLE DB and ODBC which all support movement of data and sometimes schema information. The author doesn't try to judge which database is better or more open. The information about connectivity between these databases is presented objectively. Anybody that operates in an environment of sql server and Oracle will benefit from this face off between the latest versions of these databases.