This software package helps build and update databases.
ApexSQL Build helps you to create brand new or update already existing databases. It will help you create deployment SQL scripts, C# packages or .NET executable. You should be able to create deployment scripts, packages and executable. This can be built from SQL scripts, script folders, snapshots or source control. It will help consolidate multiple scripts into a single SQL script, C# package or .NET executable. This ApexSQL Build package could be used to execute scripts against multiple databases. You will be able to specify database objects to be created or to be updated. All the custom SQL script created can be packaged and executed post-deployment. This will detect all the interdependencies between objects and rearrange scrip to take care of those. The tool helps support encrypted objects. The program helps ensure changes are propagated without errors. The built in algorithms helps ensure dependencies are not violated.
SQL database building supports multiple deployment types. You would be able to deploy databases directly from version control. Simultaneous upgrades are possible. Database maintenance can be streamlined by enabling multiple upgrades simultaneously. Change propagation is simple, changes from development to test and to production is facilitated by this tool. Selective deployment is possible. You can set deployment criteria such that partial, most of changes and all of the changes could be deployed. This tool natively supports the popular source code control products. That includes Visual Source Safe, Subversion, Team foundation Server and SourceGear Vault. This is a very good product. If you are looking for a similar solution, you should try it in your exact workflow.