I have a history database server and a production database server. I need to combine and export transactional data from the BOTH in a single file. I'm utilizing Powerbuilder 7 to connect and query the data.
Is it possible to query two databases across database servers?
If not, what's the best way to achieve this? How could I transfer the history data to a temp table in the production database?
Originally posted by coders4hire
Is CIS a standard component? Or add-on? I've been perusing the net and it pretty much looks like that's the only way to go unless I do export/import manually.
CIS is standard as of ASE 11.5, IIRC.
You need to add the remote server to the list of known servers with sp_addserver, and then you can create a proxy table on the local server that refers to the remote table, using the CREATE EXISTING TABLE command.