What is the best way for a SQL Server database to receive data from a DB2 environment? Currently we receive feeds from mainframe people on another floor in the same building.
As far as I'm concerned this is inefficient since we have to have meetings and send emails back and forth to determine how these feeds are supposed to hold data. Seems to me we should be able to set something up where we can mirror their data to our own tables but they say it won't work.
FYI - We currently use SQL Server 2000 but rumor has it we'll be moving to 2008. We're still using VB 6 and the company is not planning on providing us .NET.
As far as I'm concerned this is inefficient since we have to have meetings and send emails back and forth to determine how these feeds are supposed to hold data. Seems to me we should be able to set something up where we can mirror their data to our own tables but they say it won't work.
FYI - We currently use SQL Server 2000 but rumor has it we'll be moving to 2008. We're still using VB 6 and the company is not planning on providing us .NET.