How can I version-control my SQL Server database files with Git?

Question

OK, I'm warming up to Git and DropBox for version control. I'm creating DNN sites and I'm in the process of using Git/DropBox.

I would also like to use Git on the SQL Server backing database.

Is there some sort of best practice that could be employed here? I'm currently getting an access denied error when I attempt to create a repository in the SQL Server DATA directory.

I wouldnt backup data directory since it is not version agnostic, and not a good idea for distributed development. — Asad Hasan
– Asad Hasan, Commented Jan 19, 2014 at 17:35

Adam Dymitruk · Accepted Answer · 2011-03-15 04:03:48Z

2

You probably don't have permissions to make a .git folder in there. I would use the sql server tools to create the backup files elsewhere. I would then back those up. You should have no problem putting those in a git repo.

Hope this helps.

answered Mar 15, 2011 at 4:03

Adam Dymitruk

131k28 gold badges149 silver badges143 bronze badges

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

Comments

anroots · Accepted Answer · 2011-11-16 23:51:17Z

0

I set my database file location to a custom directory, then stopped the database service and added read/full rights for all users in the system to the file. After that, git had no problem adding the file to version control.

answered Nov 16, 2011 at 23:51

anroots

2,0791 gold badge15 silver badges22 bronze badges

Collectives™ on Stack Overflow

How can I version-control my SQL Server database files with Git?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related