Migrating to SQL Server

Migrating to SQL Server

Postby David77 » Wed 15 May 2013 20:17

Hi all,

We are currently using Dotconnect for Oracle in our application with success.
We are considering to switch to SQL Server databases system : would it be hard to do the move ?

The idea is to do the least code modification, thing that would have been easy with entity framework just by modyfing the mapping configuration.

I hope there is a way to do that starting from dotConnect ?
David77
 
Posts: 1
Joined: Wed 15 May 2013 14:58

Re: Migrating to SQL Server

Postby Shalex » Mon 20 May 2013 10:52

1. Assuming that you are using Devart Entity Model (*.edml) with DbContext template, and Entity Developer for Entity Framework (or Professional) is installed on your workstation:
set Fluent Mapping and Database Independent template's properties to True, and Metadata Artifact Processing model's property to Do Not Generate Mapping Files. Then set connection string to your SQL Server via Database Explorer, save the model. Run Update Database From Model Wizard with selected Regenerate storage option. Now the model can be used with SQL Server.

2. There is an example of using the same code with different databases (including Oracle and SQL Server): http://blogs.devart.com/dotconnect/entity-framework-code-first-support-for-oracle-mysql-postgresql-and-sqlite.html.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle