Page 1 of 1
Generate database script for Entity Framework only supports SQL Server
Posted: Fri 10 Feb 2017 09:20
by apolon
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?
Re: Generate database script for Entity Framework only supports SQL Server
Posted: Fri 10 Feb 2017 20:27
by Shalex
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.