Ok. thanks for your concern. But I still want to know if it is possible or not to make the databases be work online together? Maybe with triggers or procedures?

I am just searching a better solution in order not to make the new application sort all the millions and millions of data to find a hundered. So you have...

I want to develope a new application with the second database but also I need most of the data in the first database and I would like to update the...