Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Question Unanswered: SQL Development Environment

    I have 3 developers who wil be working on one database. Is the following setup legit?

    One SQL Server 2000 on a Windows Server 2000 box
    Three clients with SQL Client Tools installed on Windows 2000
    All clients have access to the Server.

    Should I then just add another instance instead of using the default in order to keep my databases separate from the default ones (pubs, Northwind, etc.)?

    Thank you!

  2. #2
    Join Date
    Sep 2003
    Posts
    8
    If you are just looking to set up a development server, then that should be fine.

    As for your second question, I wouldn't bother setting up another instance, as there is no practical reason for doing so. Besides, when you set up another instance, another set of system databases will be created on the second instance. There is a master, pubs, northwind, tempdb, and msdb for each instance, and they cannot be used on any instance, other than that which they reside.
    Last edited by pinion; 09-30-03 at 19:17.

  3. #3
    Join Date
    Sep 2003
    Posts
    6
    Thank you! The database will be developed on the environment described and then ported to a production server where there will be a web front end (developed in Dreamweaver in the development environment). Sound good?

  4. #4
    Join Date
    Sep 2003
    Posts
    8
    Sounds good to me. Just take care when connecting development servers with production, as it can really cause some headaches. A lot of the places that I have worked for have development and production boxes on separate networks. It's not the best option for everyone, but you should have some security in place to keep accidents from happening. At the very least, make sure you have your backups on hand.

    Everything sounds good though, good luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •