The second way that comes to mind is to use Microsoft Host Integration Services. Host Integration Server allows you to connect, integrate and even Web-enable a variety of legacy applications, data and transaction environments with a variety of Microsoft products and technologies. This tool is outside my range of expertise, but it is a solution commonly used to support mission-critical mainframe-to-SQL Server data transfer processes.
You might also consider a third party tool such as Attunity.
Dig Deeper on SQL Server Interoperability
Related Q&A from Kevin Kline
Monitoring and Administration expert Kevin Kline discusses the obstacles of database administration when a publisher resides on a different domain. Continue Reading
A common SQL Mail error is addressed by monitoring and administration expert Kevin Kline. Continue Reading
Monitoring and Administration expert Kevin Kline discusses the installation of SQL Server client tools on Windows XP Pro. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.