tag:blogger.com,1999:blog-10846234.post113734799807964061..comments2023-06-22T09:51:55.639+01:00Comments on BOBABLOG: Agile software development and Salesforce: We need space to developRob Bailliehttp://www.blogger.com/profile/06513796097645814224noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-10846234.post-1137419694775510982006-01-16T13:54:00.000+00:002006-01-16T13:54:00.000+00:00Cheers for the encouragement Wilfred, always nice ...Cheers for the encouragement Wilfred, always nice to know when my blathering is appreciated!<BR/><BR/>We also have an application that has multiple schemas and a few public synonyms. Thankfully we managed to create a dual mode build script that changes the public synonyms to private in the development environment.<BR/><BR/>I've got a plan to write up the structure soon as I think it may be of use as a generic approach to developing against legacy systems...<BR/><BR/>Anyway, I'm sure that there are situations where you simply can't avoid creating individual databases on developer workstations. However, it's not ideal when you pair program, and I think you generally end up with the DBA involved more often than if it was a central database:<BR/><BR/>'Mate, can you just take a look at my machine, I keep getting "failed to start dedicated server process".'<BR/><BR/>'Yeah, it's because you installed a shoddy copy of ## arcane product x ## and it's messed around with your PATH setting and your services. Give me half an hour...'<BR/><BR/>Like I say though, I'm sure there are situations where you can't avoid it!Rob Bailliehttps://www.blogger.com/profile/06513796097645814224noreply@blogger.comtag:blogger.com,1999:blog-10846234.post-1137396381157271632006-01-16T07:26:00.000+00:002006-01-16T07:26:00.000+00:00Hi Rob,I'm currently setting up version control an...Hi Rob,<BR/><BR/>I'm currently setting up version control and build automation at Eurotransplant. <BR/><BR/>We also decided to go for each developer having his/her own sandbox. However, I cannot manage this in one central database since our application consists of a number of schemas and rely on public synonym.<BR/><BR/>I used Ant to automate the process of setting up a whole new database. I'm doing that in our continuous integration with CruiseControl. A developer can once again use Ant to create a local database on his/her workstation by getting these files from the central build server.<BR/><BR/>This means the developer is running a database on a local workstation. I was lucky enough that we were replacing the workstations anyhow. We decided to invest an extra $300 per workstation for some extra memory and harddisk.<BR/><BR/>Keep up the good work. I got a lot of ideas from your blog in setting up our development process for about 22 Oracle developers.Anonymousnoreply@blogger.com