I am using two databases, DA and DB on the same server; I need to retrieve some data from DA to DB and I originally just cross referenced the DA in DB.
Someone said this is bad practice from a performance as well as a clear code writing point of view. If I don't cross reference the databases, I have to create a similar/same table in DB to store what's in DA already. Someone said data duplication is bad as well.
Please share your opinion about cross referencing databases.