Deploy schema changes to your backend SQL Server with SSW SQL Deploy
BSEditor: How many times have you deployed an initial version of your SQL Server or MSDE Database application to your clients or departments, then wondered how you are going to make updates to the Database schema in the future without hassle?
SQL Deploy solves this problem by automatically performing Database updates as a part of your application deployment. Bundle SSW SQL Deploy when you distribute a new version of your application to clients and all your database changes will happen automatically.
Simply save database changes from Enterprise Manager, SQL Query Analyzer or Visual Studio .NET as scripts and this utility enables automatic version upgrades. SSW SQL Deploy uses SQL Server or MSDE and is designed for Winforms, Webforms, VB, ASP and Access applications (and more), SSW SQL Deploy means you never have to worry about your clients data when deploying applications again!
When you distribute a new version of your application to your clients using SQL Deploy, it automatically applies any pending SQL scripts and Database updates.
It is common practice to save Database schema changes as SQL script files to apply at a later stage. SQL Deploy works with this practice by applying all of the scripts in a directory and adding versioning information to the Database after it applies the SQL scripts.
SQL Deploy can be used directly via its user interface or called from your application.
You can use trickle down deployment for front end, now you can use SQL Deploy for the backend.
SQL Deploy means you never have to worry about your Clients data when deploying applications again!
Key Features and BenefitsSSW SQL Deploy is so easy to use that it should be a part of every application developers software deployment strategy. The main features of SQL Deploy are:
FASTER SQL Script processing than OSQL
Versioning of application databases and updating
Interfaces include GUI, console and dll libraries
Supports background database checks and upgrades you can free download SQL Deploy 12.18 now.