java - Can Linux and Windows data system co-exist -
planning have 2 system - linux (running java , databae posgrsql) , windows (running .net application , database ms sql) in parallel. of data residing in both database systems accessed both applications in linux , windows. so, can 2 system co-exists? can either of applications access , manipulate data?
in theory possible ... large degree. couple of things things think about:
if data duplicated across different databases in ad-hoc fashion, going have solve problem of keeping copies in step.
if system requires transactions read / update data in multiple databases, going need use distributed transactions going make things complicated. (really complicated if don't have overarching xopen/xa framework in system architecture.)
my advice try simplify technology base, , if can't try keep clean boundaries between respective databases. ideally, design architecture there application service tier separate / independent services each database. have clients talk application services rather talking directly database(s).