将BAK文件导入SQL Server测试容器

Question

在我的情况下，我需要在管道中自动化飞行迁移测试。

在开始执行数据库迁移的Flyway之前，我需要导入一个BAK文件来启动我的数据库结构，

如何将SQL Server备份文件导入Junit TestContainer？

这是我的代码：

@Testcontainers
@ActiveProfiles("test-containers-flyway")
class TestFlyway {
    
    @Container
    private static final MSSQLServerContainer MY_SQL_CONTAINER = new MSSQLServerContainer().acceptLicense();

    @BeforeAll
    static void before() {
        ClassicConfiguration configuration = new ClassicConfiguration();
        configuration.setDataSource(MY_SQL_CONTAINER.getJdbcUrl(), MY_SQL_CONTAINER.getUsername(), MY_SQL_CONTAINER.getPassword());
        configuration.setLocations(new Location("classpath:db/migration"));
        Flyway flyway = new Flyway(configuration);
        flyway.migrate();
    }

    @Test
    void test() throws Exception {
        assertTrue(MY_SQL_CONTAINER.isRunning());

        Connection connection = DriverManager.getConnection(MY_SQL_CONTAINER.getJdbcUrl(), MY_SQL_CONTAINER.getUsername(), MY_SQL_CONTAINER.getPassword());
        Statement statement = connection.createStatement();

        ResultSet result = statement.executeQuery("SELECT value FROM table");
        while (result.next()) {
            String value = result.getString("value");
            System.out.println(value);
        }
    }
}

• 我认为可以将一个解决方案作为SQL Flyway DB迁移创建一个备份文件，并将其作为版本1执行