New Data Types: all new datatypes and objects using them are fully supported and can be scripted without limitations

Date and Time – simplifying your work with date and time data, providing increased date range, fractional seconds precision, and time zone support. The application can track and synchronize differences in the datatypes scale where it's applicable, for example, time(5) against time(7)

• Date – defines a date within the accuracy of one day
• Time – defines a time of a day based on a 24-hour clock within the accuracy of 100 nanoseconds
• Datetimeoffset – defines a date that is combined with a time of a day that has time zone awareness and is based on a 24-hour clock within the accuracy of 100 nanoseconds
• Datetime2 – defines a date that is combined with a time of day that is based on 24-hour clock within the accuracy of 100 nanoseconds: can be considered as an extension of the existing datetime type

Hierarchy – allowing you to construct relationships among data elements within a table

• Hierarchyid – represents position in a hierarchy and sets the desired relationship between rows

Spatial – predefined CLR data types in SQL Server allowing you to represent information about the physical location and shape of geometric objects

• Geography – represents data in a round-earth coordinate system and stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates
• Geometry – represents data in a Euclidean (flat) coordinate system

Enhancements in indexes: all new properties of the indexes are fully scripted now without limitations as parts of their parent objects

• Spatial Indexes – allowing you to index a spatial column of geography or geometry data types
• Relational (filtered) Indexes – optimized non-clustered indexes specially developed to allow working with queries from a well-defined subset of data using a filter predicate

Enhancements in column properties: the application can script all new column attributes, all of them are fully supported

• Sparse columns - ordinary columns that have an optimized storage for null values
• XML COLUMN_SET - a column of this type is only materialized when selected, and will return you all the non-NULL sparse columns in a row as an XML BLOB
• FILESTREAM varbinary (max) – the new way of storing BLOB data allowing you to store the data in the file system. Unlike columns defined with FILESTREAM attribute the ordinary varbinary(max) columns store their data in the tables.

Data compression in tables, indexed views, indexes and constraints: data compression options now can be processed for any respective object without limitations

• Data (Row and Page) Compression – allows you to compress whole tables, indexed views, indexes, primary key and unique constraints; can be configured for a whole table, indexed view and non-clustered index and for each partition in case of partitioned indexes or tables. ROW compression means storing fixed length data in variable length storage format and PAGE compression means minimizing the data redundancy

Enhancements in procedure parameters and user-defined types: all the enhancements are fully supported and processed by the product

• User defined table type – allows you to define special types having table definition. Variables of such types can be used to store a result set for processing at a later time and passed as procedure parameters or used within the procedure bodies directly. The application detects differences in table definitions of these types, tracks dependencies on them to any object (for example, a procedure) and is able to synchronize such types and achieve their equality
• Readonly parameters – indicates that the parameter cannot be updated or modified within the body of the procedure. The application can detect and synchronize differences in READONLY attribute seamlessly to other differences detected in the parameters

Change Tracking and Change Data capture: both features are fully supported by the application

• Change Tracking – built-in server's ability that allows you to answer the following questions: "What rows have changed for a user table?" and "Has a row changed?" The table documentation template was redesigned to indicate if Change Tracking feature is enabled for a table; enabling or disabling of this feature shows up in the DDL section of your tables
• Change Data capture – this new SQL Server feature provides historical change information for a user table by capturing both the fact that DML changes were made and the actual data that was changed. Changes are captured by using an asynchronous process that reads the transaction log and has a low impact on the system. All system procedures of this feature can be documented along with SQL Server Agent jobs for capturing and cleaning up data in a database

ApexSQL Script allows you to create and execute scripting plans for multiple databases simultaneously.

ApexSQL Script 2008 allows you to create data scripts without <Use DB> statement. This is very convenient when you want to run a script on other databases with the same schema automatically.

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 each of the steps or skip to a specific step directly.

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 Server's 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.

You can choose to script between the three modes:

• Data mode only
• Structure Mode only
• Both Structure and Data mode, scripting the entire database

Data Mode:

Structure Mode:

ApexSQL Script offers are variety of output features allowing you to script all objects to a single file or to custom-named, individual files.

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 2005 Management Studio: This choice loads scripts into SQL Server Management Studio and is applicable only for SQL Server 2005.
• SQL Server 2008 Management Studio: This choice loads scripts into SQL Server Management Studio and is applicable only for SQL Server 2008.
• Other: This choice offers you to launch any external 3rd party script and load scripts into this editor.

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.

ApexSQL Script supports source code control systems such as Visual Source Safe or any other SCC-compliant control system. The application allows users to check the newly created script directly into Source Control.