how does scema split work for databases
i am using a databases having two physical data, for example one database consists of sales data and other database consistes of manufacturing, The schema of both the database is same. I am able to view sales data in sales database and not in manufuring database vise versa. But if i use scema split , i can connect to both the databases and see the data , any idea how it works, i am unsing MFG/PRO and it is working; but not able to figure out
i am using a databases having two physical data, for example one database consists of sales data and other database consistes of manufacturing, The schema of both the database is same. I am able to view sales data in sales database and not in manufuring database vise versa. But if i use scema split , i can connect to both the databases and see the data , any idea how it works, i am unsing MFG/PRO and it is working; but not able to figure out