Migration from SQLServer to dotConnect Oracle

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Posts: 1
Joined: Wed 12 Aug 2009 14:39

Migration from SQLServer to dotConnect Oracle

Post by Eyal » Wed 12 Aug 2009 14:47

Hi Guys,

I've downloaded the evaluation package of dotConnect, and I can generate a new EDMX from my Oracle DB, however, I already have a working EDMX with corresponding classes that I created for the MSSQL version and quite a bit of work I did.
I could not find in the documentation how to do the EF migration from the regular .NET provider with MSSQL to dotConnect with Oracle.
Does a recommended procedure on how to do such a migration exist?


Eyal Mey-Tal

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 13 Aug 2009 12:15

There is no automated wizard or any other simple way to migrate.
I recommend you to create an Oracle database objects structure duplicating the SQL Server structure
with the same names. Then generate a model from the Oracle database, take the SSDL part only
and replace the SQL Server model's SSDL part. Make the corrections if necessary.
As a result, you obtain the old conceptual model with new storage layer.

Post Reply