In MS Access that would be possible. You would create a new database each of whose table would be a linked table to the a table in your diverse DBMS.
In SQL Server what you could to is link each one of your different databases to your server (right-click in the Security node in EM). Create a database and tables with a datastructure that corresponds to the one of the tables in the different DBMS. Then you would add data from those remote tables to your local table by any of the available methods, every certain period.
Or you could just connect to the server and directly query the tables in the linked servers.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.