DBMigration with multiple DB

[Ivan Sebben]

Hi, I have a problem and I can't find solution on docs.

In my project I want to manage migration on two different database. 

I create two db connections with code like this:

val dataSourceConfigOne = DataSourceConfig()

dataSourceConfigOne.url = ...

val configOne = DatabaseConfig()

configOne.dataSourceConfig = dataSourceConfigOne

configOne.isDefaultServer = true

configOne.name= "firstdb"

val dbONE = DatabaseFactory.create(configOne)

val dataSourceConfigTWO = DataSourceConfig()

dataSourceConfigTWO.url = ...

val configTWO = DatabaseConfig()

configTWO.dataSourceConfig = dataSourceConfigTWO

configTWO.isDefaultServer = false

configTWO.name= "seconddb"

val dbTWO = DatabaseFactory.create(configTWO)

I have different table on dbOne and on dbTwo this:

@Entity(name="table_db_one")

open class TableDBOne(....)

@DbName("db_two")

@Entity(name="table_db_two")

open class TableDBTwo(....):Model("db_two)

Now i want generate the migration for eatch database. 

And for this reason I wrote a simple main function like this:

val dbMigration = DbMigration.create()

dbMigration.setPlatform(Platform.POSTGRES)

dbMigration.setMigrationPath("one") // or two

dbMigration.setServer(dbOne) //or dbtwo

dbMigration.generateMigration()

The result is that all entities regardless of the database are generated in each migration.

How can I split the migration for dbOne and dbTwo?

thx

[Rob Bygrave]

I suspect that all entities are registered with dbOne?  Is that the case / are you sure that TableDBTwo is NOT registered with dbOne? 

--

---
You received this message because you are subscribed to the Google Groups "Ebean ORM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ebean+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ebean/910d35f4-c91f-4d11-a208-853edfa71ed1n%40googlegroups.com.