Red Gate forums :: View topic - SQL Packager and SQL Source Control
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

SQL Packager and SQL Source Control

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
M.Lawrence



Joined: 20 Oct 2011
Posts: 2

PostPosted: Thu Oct 20, 2011 5:41 pm    Post subject: SQL Packager and SQL Source Control Reply with quote

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?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Oct 24, 2011 4:05 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
M.Lawrence



Joined: 20 Oct 2011
Posts: 2

PostPosted: Tue Nov 01, 2011 3:25 pm    Post subject: Reply Reply with quote

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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Tue Nov 01, 2011 8:06 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group