System and Installation Requirements for Apex SQL Tools

Support Forum

The fastest and most effective way to get answers to your questions quickly.

FAQs

Quick answers to common questions.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools.

Online Documentation

All of our help files for download or convenient viewing online.

Videos

Watch product demos, training videos, or tutorials of our products' main features.

Step-by-step

The Step-by-step articles will show you how to use the various features of ApexSQL Tools.

SUCCESS STORIES

"Thanks for the quick (and honest) reply. I am impressed. Your company sounds like its truly different from the rest ..."

Paul Barbin
DBA
Lewis, Inc.

"SQL Diff paid for itself in the first hour of using it. I synced 12 different databases to a common rev and man am I happy"

Casey Kirt
Bell Mortgage
Project Manager

"Hey thanks for the quick response. This tool is awesome."

Curtis Potts
Chief Technical Officer
Focus Systems Inc

System Requirements

ApexSQL Audit

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005 or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1 Microsoft Windows Script 5.5 or greater
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	10 MB Free Disk Space (20 MB Preferred)

ApexSQL Clean

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005 or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	35 MB Free Disk Space (70 MB Preferred)

ApexSQL Code

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005, or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1 Microsoft Windows Script 5.5 or greater
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	10 MB Free Disk Space (20 MB Preferred)

ApexSQL Data Diff

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005, or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1 Microsoft Windows Script 5.5 or greater
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 Mhz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	40 MB Free Disk Space (100 MB Preferred)

ApexSQL Debug

Software Pre-requisites:	Microsoft SQL Server 2005 or Microsoft SQL Server 2008 with Client tools (SQL Server Management Studio)
Note:	Microsoft SQL Server Express edition is not supported
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	25 MB Free Disk Space (50 MB Preferred)

ApexSQL Diff

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005 or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1 Microsoft Windows Script 5.5 or greater
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	40 MB Free Disk Space (100 MB Preferred)

ApexSQL Diff API

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005, or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1 Microsoft Windows Script 5.5 or greater
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	40 MB Free Disk Space (100 MB Preferred)

ApexSQL Doc

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005, or 2008*
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1
Compatible Operating Systems:	Windows NT 4.0 SP3+ Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	10 MB Free Disk Space (100 MB Preferred)

*To document SQL Server Integration Services packages, Integration Services must be installed. Integration Services is a component that can be installed using the SQL Server 2005/2008 installer.

ApexSQL Edit

Software Pre-requisites:	Microsoft SQL Server versions 2000, 2005 or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1 NUnit (Optional for Unit testing) - http://www.nunit.org SQL Server Management Objects
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	768 MB RAM (512 MB minimum)
Disk Space for Install:	100 MB Free Disk Space (200 MB Preferred)

ApexSQL Enforce

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005 or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SQL Server Management Objects
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	100 MB Free Disk Space Preferred

ApexSQL Log

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005, or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions (the exceptions are IA64 version of SQL server or any SQL Server version running on Itanium hardware).
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	100 MB Free Disk Space Preferred

ApexSQL Log API

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005, or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions (including experimental support for SQL Server for Itanium).
Processor:	Personal Computer with an Intel Pentium 600 MHz or faster processor (Pentium III recommended)
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	100 MB Free Disk Space Preferred

ApexSQL Recover

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005, or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions (the exceptions are IA64 version of SQL server or any SQL Server version running on Itanium hardware).
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	100 MB Free Disk Space Preferred

ApexSQL Refactor

Software Pre-requisites:	Microsoft SQL Server 2005 or Microsoft SQL Server 2008 with Client tools (SQL Server Management Studio)
Note:	Microsoft SQL Server Express edition is not supported
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	25 MB Free Disk Space (50 MB Preferred)

ApexSQL Report

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005 or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1 Microsoft Internet Information Server 5.0 or higher
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista (32-bit) Windows 2008 (32-bit), Windows 2008 R2 Windows 7
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	15 MB Free Disk Space

ApexSQL Script

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005, or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1 Microsoft Windows Script 5.5 or greater SQL-DMO installer
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	40 MB Free Disk Space (100 MB Preferred)

ApexSQL Snapshot

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005, or 2008
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1 Microsoft Windows Script 5.5 or greater
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008, Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	40 MB Free Disk Space (100 MB Preferred)

ApexSQL Source Control

Software Pre-requisites:	ApexSQL Edit, ApexSQL Diff, or ApexSQL Script
Compatible Source Control:	Subversion 1.4 and below
Systems:	Microsoft Visual SourceSafe 6 or Microsoft Visual SourceSafe 2005 SourceGear Vault 3.5, 4.0, 4.1 or 5.0 Microsoft Team Foundation Server 2008 (SP1) Microsoft Team Foundation Server 2005

ApexSQL SSIS Compare

Software Pre-requisites:	Microsoft SQL Server versions 7.0, 2000, 2005 or 2008*
Required Components not included with Installation:	Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1 SQL Server Management Objects
Compatible Operating Systems:	Windows 2000 Windows XP Windows 2003 Windows Vista Windows 2008 (32-bit), Windows 2008 R2 Windows 7 Compatible with 64-bit OS versions.
Processor:	Pentium Class Processor 600 MHz or higher
RAM:	512 MB RAM (256 MB minimum)
Disk Space for Install:	10 MB Free Disk Space (100 MB Preferred)

*To compare SQL Server Integration Services packages, Integration Services must be installed. Integration Services is a component that can be installed using the SQL Server 2008 installer.

Links for Pre-requisites

Click Here to download ADO 2.8.
Click Here to download .NET 2.0 Runtime.
Click Here to download .NET 2.0 SP1 Runtime.
Click Here to download Microsoft Windows Script 5.5.
Click Here to download SQL-DMO installer.