Migrating to SQL 2008 from 2005

  • I'm in the process of upgrading from SQL Server 2005 to 2008. I have a few CLR packages written in VB.NET 2005 that I need to migrate to my SQL 2008 server. The problem is I can't connect to the 2008 server from VS 2005 and when I try to open my VB.NET 2005 solution in Visual Studio 2008 it wants to run the conversion wizard. The conversion wizard runs and reports success. Then VS 2008 refuses to open the solution saying the project file type "vbproj" is not supported by this version of Visual Studio.

    Has anyone run into this before? If so how do you get around it?

  • kent.kester (9/22/2009)


    I'm in the process of upgrading from SQL Server 2005 to 2008. I have a few CLR packages written in VB.NET 2005 that I need to migrate to my SQL 2008 server. The problem is I can't connect to the 2008 server from VS 2005 and when I try to open my VB.NET 2005 solution in Visual Studio 2008 it wants to run the conversion wizard. The conversion wizard runs and reports success. Then VS 2008 refuses to open the solution saying the project file type "vbproj" is not supported by this version of Visual Studio.

    Has anyone run into this before? If so how do you get around it?

    Is your VS Studio 2008 a full install, try this link it might give you some ideas.

    http://social.msdn.microsoft.com/Forums/en-US/vbide/thread/52bc04f9-f086-4adf-ac17-b0ea9f433c39

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • Actually, that was my thought as well. I'm trying a full install of VS2008 now followed by SP1. I'll let you know how it goes.

  • That was the problem. It's all working now.

  • Pleased to hear it, I feel like I have achieved something today, well indirectly of course 😛

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

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

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