Interfacing our code with SQL server etc.

AnyDayNow · Post by **AnyDayNow** » Wed Sep 22, 2004 1:27 pm

I have installed source vault.
In SourceVault, I understand that we will create the application folder in the current repository and will upload all our files there.

But, how will we connect to SQL Server Data Base for the web application we are building?

Once file is uploaded in a repository, how we will access it in a web browser, I mean what http URL ?

It would be nice to check source into Vault on our server and perform nightly builds on the source code. How do we set this up so that we can compile the source code and run it, even though it is in source vault.

lbauer · Post by **lbauer** » Fri Sep 24, 2004 11:37 am

When you add your files to Vault, they are stored in an MS SQL Server database. If you want to work on your source code projects, you would use a Vault Client to do a Checkout or Get to retrieve copies of the files from the SQL Server database to your machine.

To do this, you need to install a Vault GUI Client on your machine. The Vault Client connects to the Vault Server and the Vault Server communicates with the SQL Server database to get the files to the Vault Client.

The Vault Client integrates with Visual Studio, so you can use the GUI Client or IDE integration with VS.NET to get your files from the Vault database.

After you edit your files and check them into Vault, you can use a Vault Client on the build machine to get the latest files for your project and do the nightly build. Some users do the get with the Vault Command Line Client, which can be used in build scripts.