Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Location
    Greenwood, IN
    Posts
    40

    Question Unanswered: Across databases on different servers

    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?

    Thanks
    Doug

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443

    Re: Across databases on different servers

    One option is to use CIS (Component Integration Services) which will enable proxy table usage.

  3. #3
    Join Date
    Dec 2003
    Location
    Greenwood, IN
    Posts
    40

    Re: Across databases on different servers

    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.
    Doug

  4. #4
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353

    Re: Across databases on different servers

    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.

    Look it up in the manuals for details.

    Michael

  5. #5
    Join Date
    Dec 2003
    Location
    Greenwood, IN
    Posts
    40

    Talking Thanks!

    Thanks for the info!
    Doug

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •