c# 4.0 - Copying schema and data using SqlServer SMO in C# within a transaction scope -


i have requirement copy database in c# code. purpose, have used sql server smo objects , tested in separate piece of code. working fine. however, when integrating code existing functionality wrapped in transaction scope, not able execute code inside existing transaction scope.

hence, created inner transaction scope had transactionscope option suppress inner transaction scope not part of outer scope. when tried again, transaction aborted exception.

kindly suggest or refer me using database copy functionality within transaction scope.


Comments