sql-server-2005sql-server-2008silverlight-4.0entity-framework-4domaindatasource

Entity Framework Changing from SQL Server 2005 to 2008 R2


What changes do I need to make to get my entity data model to a new database instance on another server running SQL Server 2008 R2? I have changed the connection string in the Web.config and changed ProviderManifestToken="2008". If I try to refresh or make any changes I am given errors stating that nothing is mapped any more. Thank you for your help!


Solution

  • Just some general advice: first migrate the model with data from SQL Server 2005 to SQL Server 2008 R2 (use any approach, for example, this or this).
    After this create a brand new entity model on SQL Server 2008. Compare the models' XML, make necessary changes in the model created for SQL Server 2005 (maybe you made a mistake in the ProviderManifestToken spelling).
    Check that the data types are correspond, and actually that's all.