[MOVED] Have your application automatically deploy schema changes to your backend SQL Server with SSW SQL Deploy

How many times have you deployed an initial version of your SQL Server or SQL Server Express 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?

SSW 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 SQL Server Management Studio as scripts and this utility enables automatic version upgrades. SSW SQL Deploy uses SQL Server or SQL Server Express and is designed for Winforms, Webforms, VB, ASP and Access applications (and more), SSW SQL Deploy means you never have to worry about your client's data when deploying applications again!

When you distribute a new version of your application to your clients using SSW 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. SSW 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.

SSW 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 SSW SQL Deploy for the backend.

SSW SQL Deploy means you never have to worry about your Clients' data when deploying applications again!

Have a look at SQL Deploy in action:

Video: SSW SQL Deploy in action

[MOVED] Key Features and Benefits

SSW SQL Deploy is so easy to use that it should be a part of every application developer's software deployment strategy. The main features of SSW SQL Deploy are:

  • No new dev tools ?keep using SQL Management Studio
  • Completely automate deployment of SQL Server changes
  • Easily integrate into your own application
  • Run as a standalone application
  • Extremely Fast! 440% faster than osql
  • Designed for SQL Server 2005 & SQL Server 2008

SSW SQL Deploy is FAST! On a single 600K script file, these are the results you would typically see over the built in osql.exe tool. It is normally around 5 times faster, as you can see below. You will save even more time running larger scripts, especially those scripts that include data as well.

SSW SQL Deploy Microsoft SQL Server OSQL.EXE Utility
40 seconds 2 minutes 58 seconds

It runs in three modes:

Mode 1 - Directory

Apply multiple SQL script files on the Database.

SQL Deploy-Add multiple script files to DB
Figure: SSW SQL Deploy automatically performs Database updates as a part of your application deployment

Mode 2 - Compare Scripts

Related Software

While SSW SQL Deploy manages a SQL Server Database, use SSW Data PRO! to manage an Access Database.

The compare scripts mode allows you to check that the saved SQL scripts contain all of the changes to your Database.

In this mode SSW SQL Deploy creates a temporary Database then compares the temporary Database structure to your existing Database. Any differences in the SQL scripts are then displayed.

Mode 3 - Single SQL script

Runs a single SQL script against the Database.

More screen shots in the User Guide.

SSW SQL Deploy Options New!

How did this product eventuate?
We developed a custom rich client product for Tennis Australia which was installed in many locations around Australia. Every time a new version was deployed (which was too often :-) we had to manually dial in to run some SQL scripts - SQL Deploy was developed and completely removed this deployment problem.

SSW SQL Deploy now boasts an Options form that can easily be integrated into your application. This options form will let you select a database for the application (either create or select an existing one). Once selected, the database can be upgraded depending on the scripts that you have placed in the scripts folder. The statistics of the database are shown for your convenience, and the compare function is implemented to ensure your database structure is up to date with the scripts. Instructions on how to use this control can be

Deploy Database Control
Figure: Connecting to your SQL database with SSW SQL Deploy is quick and easy

[MOVED] System Requirements

PS: It is always recommended you can get all green ticks with SSW Diagnostics - the free utility to check you have all software patches

[MOVED] What does the unregistered version give me?

In respect to the unregistered version we know you want to see it working before you buy it. We aim for that.
Note: we also give free version targeted to the little guys
More details see http://www.ssw.com.au/ssw/KB/KB.aspx?KBID=Q658302

SSW provides free phone and email support to answer queries on registered products.

Getting Support

If you can't find it in the product documentation then check our knowledge base for further information and tips about SSW SQL Deploy.

Please send us bug reports and feedback so that we can evolve our software into a product that matches your requirements. We guarantee a response.

Links

[MOVED] I'm Sold... What's next?

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.