Source and version control for sql server

Hi All,

What is the best method for source control in SQL Server. I am looking for free or near free options.
Basically for moving the changes from dev to QA to UAT to Prod for each Major or minor release.

Thanks for your time.
JyozealAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BitsqueezerCommented:
Hi,

as far as I know there is no free source control tool for SQL Server, I only know that Redgate has a complete source control integration which is made to work with any existing source control tool (from which there are existing of course also free ones).

You can of course save any script as text, i.e. with the project tool integrated in SQL Server Management Studio and then use a source control tool which works with the project folder. So it's a little bit manual work to do but possible.

Cheers,

Christian
0
Aaron TomoskySD-WAN SimplifiedCommented:
If you don't want to pay for restate, it is expensive, like said already you can script out anything manually. after you get the manual way working, look at a CD/CI tool like thoughtworks go to automate using sqlcmd.exe and batch files
0
DcpKingCommented:
The only real "free" one is human - have a production dba who is the only person allowed to have ALTER permission on objects in the Production databases. Of course, having someone like that also comes with a tag of, maybe, $100,000 p.a., so might not be considered all that "free" after all.

As you can see, "free" is open to some interpretation: compare the cost of getting TFS, say, with the cost of not getting it and having a number of problems because of lack of access controls to the Production database. You will likely discover that even doing nothing has an associated cost!

hth

Mike
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Vitor MontalvãoMSSQL Senior EngineerCommented:
How big is your database. CA Erwin is a professional tool and the free version is able to manage until 25 tables.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
And some alternatives.
0
JyozealAuthor Commented:
Thanks for all your comments. Right now my DB size is around 20 tables. Its not any enterprise or anything. may be 2-3 developers are working including me. However i still need to follow the process so nothing is messed up. Once i can afford i will buy one of the commercial ones. For C# i am using visualstudio online TFS so i was expecting if something like that is available for sql server.
0
BitsqueezerCommented:
Hi,

if you have TFS, maybe this can help you integrating it with SSMS:

http://www.techtree.co.uk/sql-server/management-studio-ssms/use-team-foundation-server-tfs-as-your-source-control-in-ssms/

Cheers,

Christian
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.