schambers/fluentmigrator — pull request #250 by kieranmaine (2012-03-06 10:12:32+00:00)
Title: Migrations output to file invalid due to use of single line comments

When a migration calls Execute.Sql with a multi line string, invalid SQL will be generated when the migration is output to a file. However the migration will run successfully when applied directly to the database using the runner .

For example

```java
Execute.Sql(@"
INSERT INTO TestTable (Id, Value)
VALUES (1, 'Test value')");
```
will produce the following SQL in a file

```sql
-- ExecuteSqlStatement
INSERT INTO TestTable (Id, Value)
VALUES (1, 'Test value')

INSERT INTO TestTable (Id, Value)
VALUES (1, 'Test value')
```
If TestTable has a primary key constraint on the Id column an error will be thrown.

Modified TextWriterAnnouncer to use multi-line comments which are supported by all database engines that FM services. So the above statement should read:

```sql
/* ExecuteSqlStatement
INSERT INTO TestTable (Id, Value)
VALUES (1, 'Test value') */

INSERT INTO TestTable (Id, Value)
VALUES (1, 'Test value')
```