Database sharing

From Dragon Age Toolset Wiki
Revision as of 16:55, 2 July 2009 by BryanDerksen (Talk | contribs) (Category:Database)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

!!Note: This is just the initial start of documentation. I don't currently have a system set up to test this.!!

One of the major benefits of having designer resources stored in a database is that it allows multiple developers to more easily work on the same resources collaboratively. This is how the main Dragon Age single player campaign was developed internally.

Setting up a shared database server

You'll need to use one MS SQL Express database as the central repository and configure the contributing builders' toolsets to connect to it remotely over an internet connection. First you'll need to alter the configuration of the toolset's database to allow external connections:

Open the SQL Server Configuration Manager, which should be available from an entry in your Start menu. For the toolset database, you'll need to enable Named Pipes and TCP/IP to allow the database to be accessed from the outside world.

Enable named pipes and TCPIP.png

Once you've changed these settings you'll need to restart the database service to cause them to take effect. You could do this by restarting your computer, or you could go to the service manager in the Windows control panel to restart just the toolset's database service:

How to restart the service.png

You'll also need to set up an account name and password for the server to allow others to connect securely:

Setting account info.png

Connecting the toolset to a remote database

Run the "Configure Toolset" application to set which database the toolset interacts with to access resources. The database server is selected on the second tab.