Guest Posted December 31, 2007 Report Share Posted December 31, 2007 Hello I downloaded your SCM product last night. I would like to know how I can move it from using the FireBird backend to a SQL Server backend? Regards, Simon Link to comment Share on other sites More sharing options...
Borja Posted December 31, 2007 Report Share Posted December 31, 2007 Hi Simon, Yes, it is very simple. - You need to have a SQL Server (2005 or higher) installed. - Then create a db.conf file in your Plastic server directory. - The file contents should be: <DbConfig> <ProviderName>sqlserver</ProviderName> <ConnectionString>SERVER=YOURSERVER;User Id=YOUR USER;Pwd=YOUR PASSWORD;DATABASE={0};</ConnectionString> <DatabasePath>OPTIONAL PATH</DatabasePath> </DbConfig> - Then just restart the server If you have any issues or questions, please don't hesitate to contact again. Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2007 Author Report Share Posted December 31, 2007 I see there are multiple databases created. Can one newly created database not be used? Link to comment Share on other sites More sharing options...
Borja Posted December 31, 2007 Report Share Posted December 31, 2007 Hi Simon, I don't really understand your question. You can remove them if they're not going to be used and restart from a blank situation... Please let me know. Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2007 Author Report Share Posted December 31, 2007 I mean can the system not store all the information into one database? Link to comment Share on other sites More sharing options...
Borja Posted December 31, 2007 Report Share Posted December 31, 2007 Hi again Simon, Yes, it creates one database per repository plus one for workspaces plus one for the "repositories" database. So it will create at least 3 databases. Is it a problem? Regards, Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2007 Author Report Share Posted December 31, 2007 It would be nice to keep each Respository into one. Easier to manage if you know what I mean. Link to comment Share on other sites More sharing options...
Borja Posted December 31, 2007 Report Share Posted December 31, 2007 Well, actually each repository is in a single database. The point is that Plastic keeps a list of all the existing repositories (which is another database) and also keeps track of the files you have on your local machine, which is the workspace database... Hope it is not a problem for you. Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2007 Author Report Share Posted December 31, 2007 No, actually not at all. I actually do a similar thing within our document management product. One more thing, do you have a doc re backing up PlasticSCM. How long does the eval last? Link to comment Share on other sites More sharing options...
Borja Posted December 31, 2007 Report Share Posted December 31, 2007 Hi again Simon, Yes, sure. You can take a look at the user guide, which should give you a good overview on the system. Also consider the following papers: http://www.plasticscm.com/opsupport2.aspx The evaluation lasts for 30 days and 5 users. If you need an extended period just let me know. Also, what's your team size? Your development environment? Of course, don't hesitate to write us if you have any questions. Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2007 Author Report Share Posted December 31, 2007 OK, cool. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.