CODEWITHSUNDEEP
sql-serversvn
PositiveGuy
PositiveGuy

Reputation: 47783

Subversion over SQL Server

Is it possible to store Subversion meta data in SQL Server? We want a SQL Server based Subversion.

Upvotes: 3

Views: 2497

Answers (4)

gbjbaanb
gbjbaanb

Reputation: 52689

Why use a backing store that you can so easily corrupt? Sure, you can corrupt the filesystem store, but most people have enough sense not to touch it.

As it is, future versions of SVN are looking to store revprop data in a sqlite db instead of files. If they do, then you should be able to access that in much the same way, but for the mutable revprops only. I'm not sure if they intend to restrict access to it to the svn libraries of allow any other process to read and write to it.

Of course, the biggest reason SQL server is not suitable for subversion is that it would completely break its ability to be cross-platform.

Upvotes: 0

James Avery
James Avery

Reputation: 3012

There isn't anyway to do that right now. Subversion lets you choose between FSFS and Berkeley DB, with FSFS being the better choice for most people. (Berkeley DB has some issues around getting corrupt).

Is there a reason you want to store the data in SQL Server?

Upvotes: 3

Matt
Matt

Reputation: 41832

I with James Avery - why do you want to store the data in an SQL Server? If you're wanting someway to interface with the underlying subversion data from a .NET library, check out SharpSVN: http://sharpsvn.open.collab.net/.

Upvotes: 3

trent
trent

Reputation: 282

Subversion used to have BDB (Berkley Database) as its core storage. Most people moved away from that because it was hard to back up and corruption sometimes became an issue. I wouldn't recommend it but I am sure you could go look at the BDB code and have it hook up to a SQL Server.

Upvotes: 1

Related Questions