Is it possible to call a .sql file in a doctrine migration?

Question

Is it possible to call an .sql file in a migration class?

I could not find anything on that topic.

Answer 1

I know it's an old question, but it is still the only real hit when I googled for it. The above answer can be slightly improved. It's a simple thing, but you might not think of it. If you have a sql file that contains multiple queries divided by semicolon, you can explode the contents on semicolon.

<?php

foreach (explode(';', file_get_contents(__DIR__ . '/sql-dump.sql')) as $sql) {
    $this->addSql($sql);
}

Answer 2

Yes, just put that .sql file and refer it from you migration class.

$this->addSql(file_get_contents(__DIR__ . '/sql-dump.sql'));