Hi

I am practicing database design and I have question about this:
* is it possible to use two database in a one application?
* is it possible to make a relationship between the two database? example: the primary key is in the ONE database and its foreign is in the TWO database?

if it is possible, then is it advisable to use two database?

Thanks....






http://www.johnalsopinsurance.com/

Any way you can access two separate database using two separate connections, but according to me you can not set relation across two databases.

urt

Help yourself by helping someone.

AFAIK, and as urt pointed out, you can not setup DRI between two sperate databases. You could use triggers, sort of a procedural integrity if you will, to overcome this. (The SQL Guru's may have a better suggestion)

Yes it is possible to create connections to 2 sepeate databases within an application.

hth.
-Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========