Overview of SQL Bundle

1
Overview of SQL Bundle
2
SQL Bundle

• Three products
• SQL Compare compare and synch schemas
• SQL Data Compare compare and synch data
• DTS Package Compare compare standard and custom
  DTS packages
• Tools show where two databases differ and
  generate a script for making them the same.

3
SQL Compare overview

• Looks at the structure of two SQL Server
  databases
• Identifies the differences between the two
  databases
• Automatically generates the script to make those
  databases the same
• Runs the script to synchronize the database
  structures

4
SQL Data CompareTM overview

• Looks at and compares the contents of two SQL
  databases
• Gives users the option of which data to synch
• Automatically generates a script to synch the
  contents as per the users requirements
• Runs the script to synchronize the data

5
DTS Package CompareTM overview
DTS Package Compare looks at DTS packages on two
SQL Servers

• Compares
• Meta Data Services DTS Packages
• Local DTS Package
• Custom and standard packages
• Work in Background function for fast, focused
  comparisons

DTS Compare identifies the differences between
the packages
DTS Package Compare displays the comparison
results. Drill down to see specific differences.
6
Red Gate Software

• Founded in 1999, based in Cambridge (UK)
• Focused on simple tools for Microsoft
  technologies
• Leading SQL Server tool vendor by number of users
• Leading product (ANTS) for load testing, code and
  memory profiling .NET applications
• 30,000 customers
• Including 50 of Fortune 500 and most major
  governments
• 150,000 users

7
Quick Facts

• Prices
• From 490 for a single user license
• Support
• Available for around 25 of purchase price
• Upgrades and assistance included with the
  products
• Design
• Simple to understand and simple to use
• Purchases
• Online using a credit card, or with a purchase
  order

8
Why Red Gate?

• Market leader more test cases, more stability,
  extremely robust
• Most accurate scripting, all via transactions
  (never left in intermediate state)
• Lowest total cost of ownership
• Awesome testimonials can be found
  athttp//www.red-gate.com/products/all_testimonia
  ls.htm