Topic: db:test:clone clone triggers from development db to test db

Hi,

I am writing some unit tests and try to clone my development db to my test db.

All tables, fields and indexes are cloned fine. But my database triggers are not being cloned.
I have tried db:test:clone and db:test:clone_structure to create the test db, but my triggers are not being cloned.

How would I go about doing this? Or is this not possible currently?

I am using JRuby 1.5.5 with rails version 2.3.8 and SQL Server.

Thanks for your help

Hans

Re: db:test:clone clone triggers from development db to test db

Well I don't think ActiveRedord do that, the migrations are restricted to tables, fields, indexes, etc. ... for table events Activerecord offers his Callbacks.

Making your app working in that way will give some troubles in test and I asume in deployment (for Example Heroku don't allowyou to really touch you database, Maybe EY but I'm not sure) ... the beauty is do "rake db:migrate" and that's all.

so if you can ... I recomend you to manage your event's trough callbacks