All categories

ApexSQL Script download

Free Script SQL objects and data into scripts and deployment packages
2020.1 (latest)
Sep 22, 2020
apexsqlscript.exe
Jul 18, 2018
apexsqlscript.exe
Jul 2, 2018
Sep 5, 2014
Oct 5, 2014
apexsqlscript.exe
Jan 17, 2014

What's new







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.



Suggestions

MyODBC
MyODBC
Free

Connector/ODBC is a standardized database driver for Windows,

MySQL Router
MySQL Router
Free

Middleware for applications and backend MySQL Servers

PL/SQL Developer
PL/SQL Developer
Free

Develops stored program units for Oracle Databases

MySQL Installer
MySQL Installer
Free

It is a tool which will give you the freedom to manage all your MySQL apps

Firebird
Firebird
Free

Feature-rich relational database known for its high performance and excellent concurrency