Saving entire database in Source Control

• 
  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.

  David Atkinson October 10, 2012 17:51

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

  mar1jxm October 10, 2012 17:58

  - 0 +
• 
  The answer is yes. Are you having problems getting this working?

  David Atkinson October 10, 2012 18:03

  - 0 +
• 
  David,
  
  I just do not know how to do it. Could you please point me to the right direction?
  
  Thanks,
  
  Jacob

  mar1jxm October 10, 2012 18:27

  - 0 +
• 
  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

  David Atkinson October 10, 2012 18:42

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

  mar1jxm October 10, 2012 18:52

  - 0 +
• 
  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

  David Atkinson October 10, 2012 18:56

  - 0 +

Add comment

Please sign in to leave a comment.