Click here to Skip to main content
15,742,011 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

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.

Many thanks.
Updated 29-Sep-10 1:42am

1 solution

Best practice would be to create a view in DB to include the required data from DA
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900