Enhancement: RunAfterCreateDatabase folder

Question

Enhancement: RunAfterCreateDatabase folder

ferventcoder opened this issue 13 years ago · 10 comments

This should have scripts that run only once, and only after a database is created. If you are hitting an existing database, these should not run.

ferventcoder commented 13 years ago

:D

Answer 1 · 2011-09-28T11:46:45.000Z

This will run just after the alter database statements. This will not run if the database is created during a restore.

Answer 2 · 2011-09-28T12:05:43.000Z

Fixed in 5ec9b4c

Answer 3 · 2011-09-28T12:19:08.000Z

Fixed sql 2000 here: a184588

Answer 4 · 2011-10-01T15:26:30.000Z

Oh excellent. This is exactly what I wanted for baseline work.

Answer 5 · 2013-06-12T15:34:57.000Z

Is it by design that this also doesn't run if you specify a custom script for CreateDatabaseCustomScript, for example?

/cds=%sql.files.directory%\custom_db_create.sql

Answer 6 · 2013-06-12T15:37:51.000Z

It doesn't if you do not return true that a db was created, this is true.

Answer 7 · 2013-06-19T11:19:57.000Z

Cheers Rob,

For the time being I've lumped the custom database create logic in with one of the scripts in the runAfterCreateDatabase folder and it does a load of ALTER DATABASE statements. It seems a bit clunky though. Is there a simple way for me to return true that a db was created when using -cds ?

Answer 8 · 2013-06-22T08:37:16.000Z

yeah, just take a look here at how we do it: https://github.com/chucknorris/roundhouse/blob/master/product/roundhouse.databases.sqlserver/SqlServerDatabase.cs#L145

Answer 9 · 2013-07-02T09:58:37.000Z

Worked perfectly, thanks @ferventcoder