ApexScript

June 13, 2008

We have been a big fan of the apexsql family of tools for sql server.  They are one of the core tools we get management to buy when we are doing a sql server project.  ApexScript is a tool that can script a database schema and or data out to several formats.  It has been very useful for us when we have the configuration of a vendor application that is configured through a ui and stored in a database.  In general the vendors do not supply a practical way to move this configuration from one environment to another.    With apexscript we have been able to create some sql scripts to apply changes a developer had made to their local instance of the vendor application.  We were then able to put these scripts through our build process to promote through test, stage and production environments.  Apex script can also be very useful to create sql scripts for test data.

It is available from the link below

http://www.apexsql.com/sql_tools_script.asp

Comments

Got something to say?