PowerShell for SQL Change Management

Quest Change Director for SQL TechEd logoQuest Software has just released another PowerShell-enabled product (don’t you see a trend here? 😉 – this time the company has added PowerShell command-line to SQL Change Management product – Quest Change Director for SQL.

Change Director basically allows SQL administrators and developers to perform all the operation related to changes: automatically move changes from dev to test to production database environments, perform impact analysis without actually making changes, rolling back changes (including schema changes), version control, detailed change audits, and much more.

In earlier releases of the product it was UI and UI alone. Customers wanted more automation and scripting options. The development team responded with adding PowerShell to the project.

Now you can for example output database comparison into an Excel file with this command:

$a=get-cddatabase myServ base1
$b=get-cddatabase servMain base2
compare-cdobject $a $b | export-cdexcel 'c:\test.xls'

Or export a database snapshot to a file with that:

$a = Get-CDDatabase hostname base1
Get-CDSnapshot $a | Export-CDSnapshot 'c:\cdsnapshot.cds'

You can watch Change Director flash demo, read documentation or download a trial version at the site page. There’s also online community for Change Director with a wealth of videos, tutorials, documentation, team’s blog and discussion forums.


Tags: , ,


0 Responses to “PowerShell for SQL Change Management”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

My Recent Tweets


The posts on this blog are provided “as is” with no warranties and confer no rights. The opinions expressed on this site are mine and mine alone, and do not necessarily represent those of my employer - WSO2 or anyone else for that matter. All trademarks acknowledged.

© 2007-2014 Dmitry Sotnikov

September 2007
« Aug   Oct »

%d bloggers like this: