SQL Packager and SQL Source Control

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

SQL Packager and SQL Source Control

Postby M.Lawrence » Thu Oct 20, 2011 5:41 pm

Im investigating the options I have to create an automated Database upgrade for use with Team City when a user commits.

We have SQL Packager and SQl Source Control. Ideally what i would like is when someone commits a database script a UAT database will automatically absorb the change. I know i can use the command line options with the SQL Compare to compare the database with the source control folder but I'm looking to do the same with SQL Packager.

Is it possible? are there any alternatives using these two applications?
M.Lawrence
 
Posts: 2
Joined: Thu Oct 20, 2011 5:33 pm

Postby Chris Auckland » Mon Oct 24, 2011 4:05 pm

Thanks for your post.

What is it you need to do that means you need to use SQL Packager?

SQL Packager is essentially SQL Compare and SQL Data Compare under the hood, so SQL Compare is really the best tool for deploying update scripts from Source Control.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Reply

Postby M.Lawrence » Tue Nov 01, 2011 3:25 pm

Thanks for your reply.

The reason for needing to use SQL Packager is that we currently dont have a copy of SQL Compare.

If SQL Compare is under the hood of SQL Packager is there anyway to interact with the SQL Compare directly?

Using the API for SQL Compare I could update from source control. But I cannot see how to do it with the SQLPackager API is that correct?

Thanks

Mike
M.Lawrence
 
Posts: 2
Joined: Thu Oct 20, 2011 5:33 pm

Postby Chris Auckland » Tue Nov 01, 2011 8:06 pm

That's correct. The SQL Packager command line doesn't have the functionality to deploy directly from source control. It's not just that it's hidden, it's actually using an older SQL Compare engine that doesn't have that functionality.

If you have the API for SQL Packager, i.e. the SQL Comparison SDK, then you can also use the SQL Compare API, but I think you're referring to the command line interface to SQL Packager not the API.

If you want to automate the deployment of a schema directly from source control, you will need to use SQL Compare command line or the SQL Compare API.

I hope this helps clear things up.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests