How can I change the db backend?

[Guest]

Hi!

I liked your product, specially the ability to decide which backend I'll be using.

And then: how can I switch to a SQL Server backend?

- Martin

[danipen]

Hello Martin

You can change database backend creating a server configuration file called db.conf in server installation directory (c:\Program Files\PlasticSCM\server by default)

When you perform a default installation, this file not exist, and the system is auto-configured to use Firebird databases.

So you can later create this file in order to use other supported database provider. By now, official supported database backends are Firebird and SQLServer 2005, but we are working to support MySQL and Postgress.

Here is a db.conf configuration example to use SQL Server 2005:

<DbConfig>
   <ProviderName>sqlserver</ProviderName>
   <ConnectionString>SERVER=YOURSERVER;USER ID=sa;PASSWORD=somepassw;DATABASE={0};</ConnectionString>
   <DatabasePath>c:\plasticdatabases\sqldatabases</DatabasePath>
</DbConfig>

- Provider name: Available values are [firebird, sqlserver]

- Connection string: Connection parameters to use database provider. (See example).

- DataBasePath: Path on disk where server will place database files. If this parameter is empty, server will place database files into server installation directory.

IMPORTANT: After place the db.conf file into server installation dir, you must restart server for changes take effect.

Regards,

Daniel.