Hi there,
I have an C# WinForms app that have 2 sub system (Management and Marketing).
Both should have the ability to store small files as BLOBs in the database, and its already existing on the Management database.
Therefor I'm thinking about making a seperate database for the stored files, so I end up with 3 databases but on same server.
Example:
Database_A:
contains the [Management table]
Database_B:
contains the [Marketing table]
Database_C:
contains the [Files table]
Both the Marketing_Table and the Management_Table has a many-to-many relationship to the Files_Table.
But is it even possible to have a FK (foreinger key) from Database_A pointing to Database_C??
...
Go to the complete details ...