MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » April 2014

Re: SQL Connect to multiple databases



fixed

.. you can't join two tables on diffrent servers via DRDA. You would have to replicate some tables, so you would have them at the same server (MS SQL Server does thsi for linked server by the fly - slow sort of fly). From the performance perspective the fastest would be load/unload and transport as zipped streamfiles, followed by running multiple Jobs in parallel transferring single lightweight transactions, slowest would be select into with three part alias.

D*B





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact