Saving entire database in Source Control

mar1jxm · October 10, 2012 3:51PM

Hi!

Is there any way to save an entire database in Source Control?

Thank you for your help

Jacob

David Atkinson · October 10, 2012 5:51PM

Including the data? Why would you want to do this? You can specify small static data tables to source control, but you wouldn't ordinarily source control transactional data.

mar1jxm · October 10, 2012 5:58PM

Thank you for your reply - I need just Code - procs, views, functions.etc

David Atkinson · October 10, 2012 6:03PM

The answer is yes. Are you having problems getting this working?

mar1jxm · October 10, 2012 6:27PM

David,

I just do not know how to do it. Could you please point me to the right direction?

Thanks,

Jacob

David Atkinson · October 10, 2012 6:42PM

All objects will be source controlled by default. You don't have to specify them.

Create an empty folder in your source control repository, and link your database to this repository. Visit the 'Commit' tab, type in a comment and click 'Commit'.

That's all there is to it!

David

mar1jxm · October 10, 2012 6:52PM

Yes, I did that, but history did not show anything.
I guess I will see it only if I make a modification? right?

David Atkinson · October 10, 2012 6:56PM

You should see it in the history after you did the first commit. At the very least you should see a folder structure which has a subfolder for each object type that exists (Tables, Stored Procedures, Views etc).

Are you sure you're looking at the right place in the source control client? How are you viewing the history? Does the history in SQL Source Control show you anything? (right click in the Object Explorer and select Show History)

David

Saving entire database in Source Control

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk