Hi, my query is regarding data access accross numerous databases.
I need to implement a system of querying 25+ databases on the same SQLBase server (v7.6.1).
I don't want to have to logon to each database manually to export the view/table data.
For example, I would like to create a database called "Reporting" which would have stored procedures to pull data from tables in the other databases.
Is this possible?? Can somebody point me in the right direction to some sql/code examples of this.
Any help would be greatly appreciated,
Dels
I need to implement a system of querying 25+ databases on the same SQLBase server (v7.6.1).
I don't want to have to logon to each database manually to export the view/table data.
For example, I would like to create a database called "Reporting" which would have stored procedures to pull data from tables in the other databases.
Is this possible?? Can somebody point me in the right direction to some sql/code examples of this.
Any help would be greatly appreciated,
Dels