CODEWITHSUNDEEP
sqltransactions
asuppa
asuppa

Reputation: 571

SQL Transactions across multiple databases

so I am looking to set an upload service to move data from sql express to a full version. Due to the lack of agent on express I am writing the service myself in c#, I plan on using transactions to ensure data integrity.

Can i have a single transaction cover 2 databases...

meaning...

I want to read from express, insert into 2012 then update express showing "uploaded" status, since these are two separate databases, what is the best way to ensure data integrity between both sql instances.

if any of the 3 operations fail the entire transaction should be rolled back and tried again at a later time...

Upvotes: 0

Views: 259

Answers (1)

Bill Gregg
Bill Gregg

Reputation: 7147

Yes, you can use Distributed Transactions. See this article on TechNet. https://technet.microsoft.com/en-us/library/aa213077(v=sql.80).aspx,

Upvotes: 1

Related Questions