Red Gate forums :: View topic - Saving entire database in Source Control
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Saving entire database in Source Control

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mar1jxm



Joined: 10 Oct 2012
Posts: 4

PostPosted: Wed Oct 10, 2012 8:51 pm    Post subject: Saving entire database in Source Control Reply with quote

Hi!

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

Thank you for your help

Jacob
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Wed Oct 10, 2012 10:51 pm    Post subject: Reply with quote

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



Joined: 10 Oct 2012
Posts: 4

PostPosted: Wed Oct 10, 2012 10:58 pm    Post subject: Reply with quote

Thank you for your reply - I need just Code - procs, views, functions.etc
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Wed Oct 10, 2012 11:03 pm    Post subject: Reply with quote

The answer is yes. Are you having problems getting this working?
Back to top
View user's profile Send private message Send e-mail
mar1jxm



Joined: 10 Oct 2012
Posts: 4

PostPosted: Wed Oct 10, 2012 11:27 pm    Post subject: Reply with quote

David,

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

Thanks,

Jacob
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Wed Oct 10, 2012 11:42 pm    Post subject: Reply with quote

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



Joined: 10 Oct 2012
Posts: 4

PostPosted: Wed Oct 10, 2012 11:52 pm    Post subject: Reply with quote

Yes, I did that, but history did not show anything.
I guess I will see it only if I make a modification? right?
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Wed Oct 10, 2012 11:56 pm    Post subject: Reply with quote

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