2008 & 2000 Developer edition on same machine

  • Hi

    Can the developer edition of both 2000 and 2008 run ok on the same machine.

    I have a xp box.

    I want to be able to run an app writing data to both databases, if I can't connect to one of the databases it uses the other until they both come back online then sync's.

    We currently use 2000 but im thinking of trying out 2008, But don't want to destroy my current setup.

    Cheers

    David

  • No problem.

    Just be aware of that only one instance can be DEFAULT instance.

    The other instance must be fully named in your connection string as [Computer]\[Instance]


    N 56°04'39.16"
    E 12°55'05.25"

  • Cheers

    I will give it a try.

    Dave

  • I've had 2000, 2005, 2008, and four different versions of Express all running at the same time on an XP box. No issues. Well, except that it's slow as hell with all that contention for resources.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply