Update from table of a database to another table of another database.
Posted on 2009-07-06
I have below situation.
I have 2 databases.
The user just input data using "Invoicing Menu" and press "Save" button.
I want to post the transaction into those database table.
TableSales in database Inventory.
TableJournal in databse Accounting.
I still want to use Transaction (Begin, Commit and Rollback) for both of them, in case something happened to one of them.
How could achieve this?