locked
Error opening db project with ctp 16

    Question

  • I have a database project that was created under ctp 15.  I uninstalled ctp 15, ran the dbprorepair tool and then installed ctp 16.  When I try to open the db project I get the following error:

     

    Failed to create extension manager with DSP

    ‘Microsoft.VisualStudio.TeamSystem.Data.SqlDsp.Sql90DatabaseSchemaProvider.’

     

    When I click OK I get a message that says:

     

    The database schema provider with type ‘Microsoft.VisualStudio.TeamSystem.Data.SqlDsp.Sql90DatabaseSchemaProvider.’ is not valid.

     

    I don’t have the power tools installed.  (I think.  There are some Visual Studio Tools installed but nothing associated with the database professional edition.)

     

    I can create a new project without any problems.

     

    Anyone have any ideas?

     

    Bob

     

     

    Tuesday, August 26, 2008 8:34 PM

Answers

  • Greetings,

     

    From the readme file:-

     

    Known Issues and Limitations

    Failed to create extension manager with DSP

    Due to an Assembly namespace change Projects created using previous versions of the GDR cannot be loaded in the August CTP. You will receive the following error message when you load the Project

    ---------------------------

    Microsoft Visual Studio

    ---------------------------

    Failed to create extension manager with DSP 'Microsoft.VisualStudio.TeamSystem.Data.SqlDsp.Sql100DatabaseSchemaProvider'.

    ---------------------------

    OK  

    ---------------------------

     

    I'm guessing that your problem is related...

     

    Yes you can create a new project without any problems.

     

    Someone posted on how to manually "upgrade" your pre CTP 16 projects but I can't find the reference at the moment.

     

    --

    Regards,

    Neale NOON

     

    Wednesday, August 27, 2008 3:18 AM
  •  

    As noonie pointed out, you due to namespace change you need to recreate the project or update it manually.

     

    Change this

        <DSP>Microsoft.Data.Schema.Sql.SqlDsp.Sql90DatabaseSchemaProvider</DSP>


    And add this:

        <ProjectVersion>3.3</ProjectVersion>

    -GertD
    Wednesday, August 27, 2008 5:56 AM

All replies

  • Greetings,

     

    From the readme file:-

     

    Known Issues and Limitations

    Failed to create extension manager with DSP

    Due to an Assembly namespace change Projects created using previous versions of the GDR cannot be loaded in the August CTP. You will receive the following error message when you load the Project

    ---------------------------

    Microsoft Visual Studio

    ---------------------------

    Failed to create extension manager with DSP 'Microsoft.VisualStudio.TeamSystem.Data.SqlDsp.Sql100DatabaseSchemaProvider'.

    ---------------------------

    OK  

    ---------------------------

     

    I'm guessing that your problem is related...

     

    Yes you can create a new project without any problems.

     

    Someone posted on how to manually "upgrade" your pre CTP 16 projects but I can't find the reference at the moment.

     

    --

    Regards,

    Neale NOON

     

    Wednesday, August 27, 2008 3:18 AM
  •  

    As noonie pointed out, you due to namespace change you need to recreate the project or update it manually.

     

    Change this

        <DSP>Microsoft.Data.Schema.Sql.SqlDsp.Sql90DatabaseSchemaProvider</DSP>


    And add this:

        <ProjectVersion>3.3</ProjectVersion>

    -GertD
    Wednesday, August 27, 2008 5:56 AM
  • Thanks to both of you.  I remember seeing that entry in the readme but I guess I didn't read it closely enough.

     

    Where do I make these changes, in the project.dbschema file?

    Wednesday, August 27, 2008 12:34 PM