using migration with both System.Data.SqlClient and Devart.Data.Oracle
Posted: Tue 09 Dec 2014 09:38
Our product is tested using SqlServer, but for production it will be deployed on Oracle.
We use code first migrations, with automatic migrations disabled. We call new DbMigrator(config).Update() to initialize the database intially.
If I generate the initial migration targetting SqlServer it doesn't work on Oracle (complains about pending model changes) and if I generate the initial migration targetting Oracle it doesn't work on SqlServer.
The generated migration class contains only one difference (precision = 7 for a DateTime field).
Is there a way to create an initial migration that works with both System.Data.SqlClient and Devart.Data.Oracle ?
We use code first migrations, with automatic migrations disabled. We call new DbMigrator(config).Update() to initialize the database intially.
If I generate the initial migration targetting SqlServer it doesn't work on Oracle (complains about pending model changes) and if I generate the initial migration targetting Oracle it doesn't work on SqlServer.
The generated migration class contains only one difference (precision = 7 for a DateTime field).
Is there a way to create an initial migration that works with both System.Data.SqlClient and Devart.Data.Oracle ?