Something I've never had to do before, but need to get some data from a DB2 database into SQL Server 2008 and wondering which is the preferred way to do it. I'm sure there are many ways to do this so I was thinking of;
a) Using OpenRowset without using a Linked Server, via SQL query
b) Creating a linked server via sp_addlinkedserver on the SQL Server
c) Creating a connection via a SSIS package and using a Data Flow task to move data.
Which is the best method, or should I be looking at another method?
I'm concerned about testing this on the Test environment, and then not working on Prod so which woule be the most portable and least likely to fail?
TIA
a) Using OpenRowset without using a Linked Server, via SQL query
b) Creating a linked server via sp_addlinkedserver on the SQL Server
c) Creating a connection via a SSIS package and using a Data Flow task to move data.
Which is the best method, or should I be looking at another method?
I'm concerned about testing this on the Test environment, and then not working on Prod so which woule be the most portable and least likely to fail?
TIA
Comment