minhphien / migratordotnet

Automatically exported from code.google.com/p/migratordotnet
0 stars 0 forks source link

Adding the ability to run a non-transactional Migration #173

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Execute non-query: "CREATE FULLTEXT CATALOG FULLTEXT_CATALOG AS DEFAULT;"

What is the expected output? What do you see instead?
I expect this to work, but it fails, because this command cannot be run inside 
of a transaction.

Please use labels and text to provide additional information.
My solution was to add a property to the MigrationAttribute:

[Migration(3, IsTransactional = false)]

Now, if IsTransactional is false, the migration will execute without a 
transaction.

Unfortunately, I'm not familiar with the unit test framework you are using, and 
couldn't get the tests to run as unit tests from VS.  It all compiles and works 
well, though...)

- Chris

Original issue reported on code.google.com by chris.da...@sparcedge.com on 28 May 2011 at 3:19

Attachments: