ApexSQL Script lets you script SQL objects and data into scripts and deployment packages.You can also script objects directly to Source Control and integrate with popular source control systems. For the purpose of database migration, ApexSQL Script can be used to create a single script from multiple sources.
v2014.0 [Oct 5, 2014]
Enhancements:
- The application now fully supports SQL Server Express Edition.
- The application now fully supports Windows Azure SQL Database.
- The application now fully supports SourceGear Vault up to version 6.1
Fixes:
- Missing information that the "/o" and "/include" switches cannot be used together.
- The "Not found. Sorry, but we couldn't find the page you were looking for" error is encountered when the F1 button is pressed.
- The "The path is not of a legal form" error is encountered when the "Scripting wizard" is started for Windows Azure SQL Database.
- The value for a file name is inputted on cursor position in the "Output file" options.
- The "Save scripts to file(s)” location is reset when changing the "Output action" options.
- The IDENTITY feature in table columns is ignored when scripting table with "xxx.yyy" SCHEMA format.
- The server used in the last session is not remembered in the "New project" window.
- Only the first page is shown in the "Print preview" option.
- The "Script header" form can be multiple divided.
- The "New project" window is not resizable.
- All tables that are checked become unchecked when the "Edit SQL WHERE clause" option is used.
- The created script cannot be opened when SQL Server 2014 Management Studio is selected as an editor in the "Script wizard".
- The "Parse error: Internal parser error." error is encountered when the CANCEL button is clicked, while including dependent database objects.
- The main grid is not auto filled with columns to cover the white space in the "Data" and in the "Structure" views.
- The "OK" button in the "Edit max value" dialog does not work.
- The "OK" button in the "Edit object alias" dialog does not work.
- The "Uncheck fields" option causes incorrect checking/unchecking objects from the "Data" view.
- Missing the "Select Visual studio version" option in the "Output file options" when creating C# project.
- The "Parse error: incorrect syntax near 'next' at position [x,y] in query [xxyy]" error is encountered when scripting specific stored procedure.
- Data types datetime2 and datetimeoffset are scripted incorrectly as data types binary(8) and binary(10).
- The "Parse error: Error : [Incorrect syntax near 'DBCC']" error is encountered when scripting a DBCC statement.
- The "Red X" error is encountered when loading objects from a database which contains more then 5,000 objects.
- The application is non-responsive when scrolling through a large number of objects in the main grid.
- The application is unresponsive when more than 100,000 objects are selected for scripting.
Changes:
- The application has been split into three versions - Community, Developer and Professional.
Known issues:
- Local server result panel says that "No servers detected" although local instance exists when the application is used on 64bit operating system with 64bit SQL Server.
Feature-rich relational database known for its high performance and excellent concurrency
