Generate database script for Entity Framework only supports SQL Server

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
apolon
Posts: 6
Joined: Fri 10 Feb 2017 09:17

Generate database script for Entity Framework only supports SQL Server

Post by apolon » Fri 10 Feb 2017 09:20

The generate database script for a entity framework model only lists sql server variants as options.
Is there a way of generating a database script from the model for say Oracle, Postgres or sqlite?

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Generate database script for Entity Framework only supports SQL Server

Post by Shalex » Fri 10 Feb 2017 20:27

Yes, there is. For this, you should install the Professional edition of the corresponding dotConnect provider. The trials are available at
http://www.devart.com/dotconnect/oracle/download.html
http://www.devart.com/dotconnect/postgr ... nload.html
http://www.devart.com/dotconnect/sqlite/download.html

1. dotConnect is shipped with Entity Developer which can be used only with a particular database server.
2. After dotConnect is installed, you can migrate (e.g.: SQL Server -> Oracle) the existing model by changing connection string in Database Explorer, then right click the diagram surface > Regenerate Storage and Mapping.

Post Reply