Developer forum

Forum » Development » Database Management

Database Management

Alec Stubbs
Reply

Hi Guys,

 

I wonder if anyone could share with me the way they manage databases in a dev environment.

 

We have a number of developers and each one has a version of the DW database on their machine we also have a test server with a copy of the database. Our current setup is that the test servers database is where any CMS work that we do such as setting up pages or adding copy goes. We do backups of this db and developers restore it to their local machines when they want to get an up to date copy. 

 

This seems a bit clunky to me and made me wonder if anyone has a better way of managing their dev environment?

 

Cheers,

Alec


Replies

 
Nicolai Høeg Pedersen
Reply

Hi Alec

 

We see at a lot of our partners that the developers simply have the website on their local machines (Dynamicweb and /Files) and then simply connect to the database on the test/developer server. In that way all the installations share the same source.

 

Also they have the /Files in a version repository - i.e. Git or TFS and can check out from there also. A very simple and effective setup.

 

Hope this helps.

 

BR Nicolai

 
Alec Stubbs
Reply

Hi Nicolai,
Thanks for your reply. Having the db on a single server is certainly something we've considered and I can see how it could work for some setups. The reason I’d prefer each developer to have a local copy of db is that we should be free to experiment and even screw things up without impacting anyone else. If a change is required to a custom module using the db then a developer should be able to make the change and fully test it before it’s seeded to everyone else.
Cheers,
Alec

 

You must be logged in to post in the forum