1

I am trying to get our company's database objects stored in source control. We are going to be stuck using Aldon LM for our source control program. What is the best way to deploy scripts that we create to our SQL Server environments automatically from source control?

For our .Net web applications, we have configured Aldon to push our code to the web server and run MSBuild.

Improve this question
1
  • I won't lie Ant Hill Pro will cost some money, but it is really cool as far as doing multiple step deployments. We cut the amount of time it took us to deploy code across all tiers in all of our environments to minutes. Commented Feb 20, 2009 at 3:24

3 Answers 3

Reset to default
1

We have programs (ant hill pro for one) which go through the source control system, and retrieve all the necessary sql scripts and compile them into one file. We have a branch for each release, so only the ones for that branch get get pulled. I think cruise control can do the same thing, but I don't know how that is done.

We then can execute all the updates and once and don't have to worry about missing one.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thanks Kevin. I'll do some research into Ant Hill Pro and look into what Cruise Control can do.
0

Open a Database project in your solution to manage all SQL code such as stored procedures. This has a few advantages:

  • Your SQL can be under version control just as the rest of your conde
  • You can do easy find/replace file operations on multiple procedures
  • You can keep your SQL in a meaningful and systematic folder hierarchy
Improve this answer

Comments

0

Install VS Team System Database Edition, now included (available to add to) Developer Edition.

This has tools to work out which scripts to apply to a database to update it to match the reference database and will (providing your SCM integrates with VS) also handle tracking all those scripts and there status within the project.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.