Q
Problem solve Get help with specific problems with your technologies, process and projects.

How can I transfer data from a SQL server to a mainframe without using FTP?

How can I transfer data from a SQL server to a mainframe without using FTP? I have an extremely large amount of data to transfer and FTP takes too long.

How can I transfer data from a SQL server to a mainframe without using FTP? I have an extremely large amount of data to transfer and FTP takes too long.
There are two main ways to tackle this challenge and probably a dozen less common approaches to solve this problem. The first way that comes to mind is to use DTS (on SQL Server 2000 or SSIS on SQL Server 2005) to create a data transfer job, assuming that DTS has a driver for your mainframe. (You didn't specify what type of mainframe you're working with.) With a little bit of top-level planning, you should be able to build a highly parallelized loading routine that will load the data in many simultaneous streams and, thus, outperform a batch transfer and FTP process.

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.

This was last published in August 2005

Dig Deeper on SQL Server Interoperability

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close