SSIS will/can do it, but it depends how much extra donkey work you feel like doing to get it to convert DB2 datatypes to acceptable SQL datatypes.... It can get entertaining.... like pushing pencils into your eyes...

I've dragged data from an AS/400 DB2 using DTS, that was fun.... but it was a better alternative to the late 1990's version of Datamirror's Transformation Server that was being used at the time, which was God-awful! I think we used liberal amounts of ActiveX conversion scripts in our ETL from AS/400 to SQL 2000... but of course we don't have that in SSIS, we have better alternatives.

Or... use Toad or DBArtisan to extract the table scripts and make changes to the datatypes before submiting them up to the SQL Server... more donkey work.... especially if there are a large number of tables.

I have just done a similar thing with an Oracle table. Extracted the DDL for it using Toad, and then changed the datatypes to SQL Server acceptable types. Then used SSIS to copy data, the ASS/400 should follow similarily..... yeah right...

I'd go with SSIS and a large box of pencils...

Jeremy Greaves
Fenris Software Consulting, Inc
> To: [Email address protected] From: mssqldba-ezmlmshield-x35621798.[Email address protected] Date: Wed, 28 Nov 2007 15:55:11 -0600> Subject: Cross-DB DDL Script Generation Tool> > Does anyone know of a tool that can generate DDL scripts that are runnable on> SQL Server 2005 but generated based off a database that's in AS/400 DB2? I'm> looking for something that can script out the database and ideally also> transfer the data, and I'm not horrible confidant that SSIS will be able to> foot the bill on this.> > Let me know if SSIS can, in fact, handle this or if there is some 3rd-party> product out there that can do this.> > Thanks,> > John Eisbrener> SQL Database Administrator> Capitol Insurance Companies> > > > > > ---------------------------------------------------------------------> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY> To post a dba job: http://jobs.lazydba.com> To subscribe : http://www.LazyDBA.com> To unsubscribe: http://www.lazydba.com/unsubscribe.html>
MS Sql Server LazyDBA home page