Moving database from named intance to default instance

  • Hi

    I'm currently working on moving a database from a named instance on SQL Server 2005 to a named instance on SQL Server 2008. Are there any issues or challanges I should be aware of before doing this? Or is this the same as moving from a named instance to another named instance?

    /Andy

  • After moving change the compatibility to 100

  • Akkare (1/25/2011)


    After moving change the compatibility to 100

    I wouldn't do this straight away without test that all the application code is compatible with level 100 first.

  • The application that uses the database in developed in house, and the database only has 4 columns. But 8 million rows.

    So is shouldn't be any issues with supporting 10.

    /Andy.l

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

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