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.
Requires Free Membership to View
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 first published in August 2005
Join the conversationComment
Share
Comments
Results
Contribute to the conversation