this is the scenario, two different databases (A&B) are running, both contain similar data in some of the tables but with different table structure, if i want to do a periodic update for database A by using data from database B, what would be the best method to do?
thanks...