SQL server 2000 and 2008 - Co exist and reffering..? RRS feed

  • Question

  • Hi We are planning to migrate SQL server 2000 to SQL server 2008, for safer side, the plan is to install SQL 2008 along side in the same machine, and migrate the DBs. After setting up 2008 successfully, uninstall SQL server 2000.

    So, after installing 2008, how my application will reffer SQL 2000 / SQL 2008.?

    Connection string has only the server name, How will i make my application to connect to SQL 2000 / SQL 2008.

    1. do I have to make some change in my connection string or any Set SQL server 2008 as default server.

    2. And will there be any issue if I uninstall SQL 2000, ie, SQL 2008 will not get disturbed right..?





    To Achive Success stay Relaxed, Not Stressed.
    Monday, November 21, 2011 9:43 PM


All replies