Home » Buyers Guides » SQL Server 2008 3PP

SQL Server Partner Products

With 25 years expertise in software licensing and product knowledge, Grey Matter can help you understand what third party products you can utilise to improve your SQL server databases.

Microsoft works closely with a number of specialist publishers that have the expertise to extend the functionality of the Microsoft developer tools and server products. These third party publishers typically provide components that can be dropped into your applications to reduce development time and minimise risk. Some also provide products that are tightly integrated with the Microsoft platform to provide additional functionality and performance benefits.

The following product sections are based on loosely on the database development lifecycle and integration with SQL Server; Design, Connectivity, Adminstration, Reporting and Data Extraction, and Various Tools and Utilities.

Microsoft SQL Server 2008 provides a scalable enterprise data integration platform with exceptional ETL and integration capabilities, enabling organizations to more easily manage data from a wide array of data sources. Go beyond simple ETL solutions by using the power of the Microsoft .NET platform and SQL Server 2008. But administration is everything so if you need more try some of our great third party products.

CA ERwin Modeling Suite Bundle
DBGhost Automated Toolkit
DBGhost Builder
DBGhost Data Compare
DBGhost Packager
DBGhost Packager Plus
DBGhost Schema Compare
DBGhost Scripter
Embarcadero DBArtisan
Embarcadero DBArtisan Professional
Embarcadero DBArtisan Workbench
Embarcadero Rapid SQL
Embarcadero Solution Pack
EZ Manage SQL
Red Gate SQL Data Compare
Red Gate SQL Multi Script
Red Gate SQL Toolkit
SQL Toolbelt
Embarcadero Change Manager

The interface between your application and the data-tier is an important (and often overlooked) aspect of system design. This is where performance and security can be compromised. A number of third party publishers specialise in data adaptors and drivers for use in applications that demand the highest levels of performance in terms of connectivity.

ComServer
DataDirect connect64 for ODBC
DataDirect connect64 for SSIS
DataDirect connect for ADO.NET
DataDirect connect for JDBC
DataDirect connect for ODBC
JNET Direct Jdata Connect
Vanatec Open Access
IBM DB2 Connect

Performance and the ability to extend or scale in the future are key factors in database design. There are a number of third party tools that address database design and optimisation with these factors in mind. There are also tools that allow you to reduce development time by translating business process models into database code. Documentation is important and is also catered for by some third party products.

CA ERwin Data Model Validator [r7.1]
CA ERwin Data Model [r7.1]
CA ERwin Model Manager [r7.1]
CA ERwin Model Navigator [r7.1]
CA ERwin Modeling Suite Bundle [r7.1]
Embarcadero ER/Studio [7.x]
Embarcadero Solution Pack
Red Gate SQL Compare
Red Gate SQL Comparison Bundle
Red Gate SQL Dependency Tracker
Red Gate SQL Toolkit
SQL Toolbelt
Total SQL Analyzer

Third party tools to extract and analyse data play an important part in allowing businesses to gain maximum benefit from their data assets. There is a growing need for business users to have access to these tools so some are designed with ease of use and dynamic presentation capabilities in mind.

Automated-SQL-Builder
Chart FX for Reporting Services
Contour OLAPBrowser – done
Crystal Enterprise
Crystal Reports 2008
cView Report Viewer
DataDirect XML Converters
Dundas Calendar for Reporting Services
Dundas Chart for .NET
Dundas Chart for Reporting Services
Dundas Chart for SharePoint
Dundas Dashboard Bundle for SharePoint
Dundas Gauge for ASP.NET
Dundas Gauge for Reporting Services
Dundas Gauge for SharePointDundas Gauge for Windows Forms
Dundas Map for ASP.NET
Dundas Reporting Services Dasboard Bundle (Chart, Gauge, Calendar & Map)
MonarchTrendAnalyzer
Unify Report Builder

A variety of tools exist that deal with issues such as performance tuning, data cleansing and migration. Others are designed to assist with the building of applications, in some cases using simple programming languages to speed up delivery and reduce costs. Understanding the structure of an existing, complex database can be a challenge and tools exit to analyse and produce documentation. Such tools are invaluable for maintaining or migrating a database.

Altova DatabaseSpy 2008
Automated-SQL-Builder
CleanseData Toolkit
DBGhost Automated Toolkit
DBGhost Builder
DBGhost Data Compare
DBGhost Packager
DBGhost Packager Plus
DBGhost Schema Compare
DBGhost Scripter
DbMAP ASJ
Embarcadero Change Manager
Embarcadero Rapid SQL
Match
Red Gate SQL Data Compare
Red Gate SQL Dependency Tracker
Red Gate SQL Doc
Red Gate SQL Packager
Red Gate SQL Prompt
Red Gate SQL Prompt Bundle
Red Gate SQL Refactor
Red Gate SQL Toolkit
Sentry-go Quick SQL Server Monitor
SQL Toolbelt
SQL Tools
TOAD

Home » Buyers Guides » SQL Server 2008 3PP