The question on the subject was asked by one of the Data Integration project developers, which is initiated to migrate a database from Oracle to SQL Server. The process of transactions should be handled from Application and when it comes to the data migration you have the tools such as SQL Server Migration Assistant (SSMA) for all other data sources. Just to the topic of data migration I would like to refer the resources to see how SSMA automates, streamlines, and simplifies data migration and helps...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2008/08/28/handlgin-pragma-autonomous-transaction-mode-within-sql-server.aspx