Home Forums SQL Server 2005 Development database design, your thoughts on an issue with developers RE: database design, your thoughts on an issue with developers

  • Thanks for the responses all.

    The argument came down to, when should a DBA (operations) need to know about the four databases. Development teams say it should be at the QA\staging phase once they are done developing. I feel it should be before development to make sure we know where the database will go once it reaches production. Developers want to create as many DBS as they want in Dev and once it goes to qa/staging then we can tell them where it goes. Only issue I have with this is that we have dedicated DEV\QA servers that mimic production. Why develop on the wrong server if eventually we might move it. Then cause more work for DBAs and devs to move the databases.

    We are meeting next week to go over the details on why they need 5 now seperate databases. It will be interesting meeting.

    P.S just an fyi, my department does not have strong SQL developers mostly Operations DBAs. This is one of the setbacks i have currently.