Apex SQL Script 2008.01

Apex SQL Script 2008.01 incredible tools for SQL Server that converts databases to scripts, .net exes and deployment packages.

Apex SQL Script creates insert scripts from any Microsoft SQL Server database that can be archived, emailed, checked into source control, run against another database etc.

Apex SQL Script handles Identity fields and Apex SQL Script can auto-sequence the scripting order of tables to avoid referential integrity violations even when re-loading an entire database.

Apex SQL Script integrates with a variety of source control systems including Visual Source Safe, Source Gear Vault and Microsoft Team System as well as others.

ApexSQL Script can check for object dependencies in order to determine the proper order for the creation of objects. ApexSQL Script supports several types of output editors including built in ApexSQL Editor, MSSQL Query Analyzer and SQL Server Management Studio.

Major Features:

1. Multiple databases scripting support: ApexSQL Script allows you to create and execute scripting plans for multiple databases simultaneously.
   
2. Make complex Script plans easy: The Script Wizard makes creating a complex script plan easy. It has many options that allow you to customize your script. A navigation control allows you to view all of the steps and skip to them directly.
   
3. Script to multiple output types: ApexSQL Script doesn't just create T-SQL scripts but a variety of other output formats as well.
   
   • T-SQL: Scripts are written to a .sql file that can be executed from SQL Servers' management or command line tools or another query editor such as ApexSQL Edit.
   • VB Script: Scripts are written to a .vbs file that can be executed without the SQL Server client utilities being installed. This output option also offers more sophisticated error handling and branching than plain T-SQL. Also VBScript scripts can be executed without SQL Server Client utilities installed.
   • .NET Executable: Scripts are packaged and compiled into a binary .NET Executable that can be run from any client desktop. SQL Server client utilities are not needed.
   • C# Project: Scripts are packaged into a .sln (C# solution file) project with complete source code. The source code can be reviewed, edited and compiled into a .NET Executable.
4. Script both Data (DML) and Structures (DDL): You can choose to script between the three modes:
   
   • Data mode only
   • Structure Mode only
   • Both Structure and Data mode, scripting the entire database
5. Create accurate and error-free scripts: ApexSQL Script uses a propriety dependency algorithm that is much more accurate than SQL Servers own native dependency tracking system table (sysdepends). This ensures that scripts are ordered correctly for error-free execution.
   
6. Customize file output: ApexSQL Script offers are variety of output features allowing you to script all objects to a single file or to custom-named, individual files.
   
7. Use the Script Editor of your choice: ApexSQL Script comes with a built-in commercial quality SQL Editor. Generated scripts can easily be sent to other editors as well:
   
   • Built in ApexSQL Editor.
   • MSSQL Query Analyzer: This choice loads scripts into Query Analyzer and is applicable only for SQL Server 2000.
   • SQL Server Management Studio: This choice loads scripts into SQL Server Management Studio and is applicable only for SQL Server 2005.
   • Other: This choice offers you to launch any external 3rd party script and load scripts into this editor.
8. Schedule and Run jobs unattended, overnight as part of an automated process: ApexSQL Script offers a powerful console application allowing the tool to be used in automated processes, to be run nightly, scheduled, unattended etc. All relevant GUI operations can be performed via command line interface. The Command Line Interface offers scores of option switches, support for XML argument files as well as standard switches like Test and Help.
   
9. Integrate with Source Control: ApexSQL Script supports source code control systems such as Visual Source Safe or any other SCC-compliant control system. Application allows users to check the newly created script directly into Source Control.

Enhancements:  major upgrade

Requirements:

• MDAC 2.8(ADO 2.8)
• MSSQL Server v7, 2000 or 2005, .NET 2.0 Run time,
• Windows script 5.5 or greater