I have 2 databases, I want to share customer data between but both have 3rd party applications running over the top.
DB1, I can make full changes to the tables etc but DB2 is locked down and can't open but I can write to it via SQL or link the tables.
Any ideas how I can share this data with out changing either database design?
Thanks
DB1, I can make full changes to the tables etc but DB2 is locked down and can't open but I can write to it via SQL or link the tables.
Any ideas how I can share this data with out changing either database design?
Thanks