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?
Generate database script for Entity Framework only supports SQL Server
Re: Generate database script for Entity Framework only supports SQL Server
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.
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.