November 21, 2007 at 7:51 am
How do you do to the database in DEV box not to be mixed if they are being used by 2 developers? Dev box is refreshed daily.
Like 2 developers are using the same database for different projects.
solution:
- Creating 2 databases x and y database to have the same data. But if there are 10 developers working with the same data, I have to create 10 databases which is a bad idea.
Any ideas or comment will be greatly appreaciated.
November 26, 2007 at 10:41 am
A few possibilities. And if you like one or find another, write an article!!! 🙂
First, allow each developer to create objects in their own schema. So developer Bob would create Bob.MyProc, Bob.MyTable, etc. You have to then migrate/merge these together later, but it makes for separation in one db.
Two, use Personal edition on each development machine, let them build objects, test there (not necessarily refreshing every day), and then have one person responsible for migrating changes to the shared development box.
In any case, you should be using some Source Control system (SSC) like SourceSafe, CVS, something, to ensure two developers aren't changing the same object.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply