SQL Structure / Database data

Hello,

When installing Proget, how exactly does it setup it's SQL DB? (Structure, data, etc.)

When I first installed Proget, it appears to work fine it terms of linking it with a local DB on the same PC that it was installed. However when trying to link it with a remote SQL instance by modifying the default connection strings, it does not appear to work out of the box.

I did manage to get it work after a few weeks of trial and errors and assistance from my DB administrators, but does it really need to be this complicated?

I'd like to get a better understanding of how Proget works with DB, how it builds it's structure etc?

If I install Proget and want to use a remote "newly created" SQL instance, what else must I do aside from changing the connection string? ... Will Proget automatically send all the structure info and data info required via the connection string info within the installation ??

Regards,

Product: ProGet
Version: 4.3.1

Please refer to the High-level Architecture Diagram to see the components of a ProGet installation.

The Database is a SQL Server database. The Web and Indexing Nodes are both .NET application that interact with the database using the standard SqlClient API. The connection string you specify in the configuration file is assigned to the ConnectionString property of that API.

All of this is very standard, but it's very likely that your DBA/Network Admins configured the SQL Server you wanted to use in such a way that a simple/intuitive connection string was not sufficient. Maybe they used a special port, security, etc.; they would be much better suited to answer your question about why it's so complicated :)

Also, please note that the ProGet Installer will create/update the tables and object in the database. ProGet itself does not modify (nor have the privileges to modify by default) the database structure. If you wish to install the database component outside of the installer, then you will need to follow the Manual Installation Instructions.