----- Original Message -----
From: "plomizos" <mssqldba-ezmlmshield-x16435700.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, November 29, 2007 12:42 AM
Subject: Fw: Cross-DB DDL Script Generation Tool


>
> ----- Original Message -----
> From: "Eisbrener John "
> <mssqldba-ezmlmshield-x35621798.[Email address protected]
> To: "LazyDBA Discussion" <[Email address protected]
> Sent: Wednesday, November 28, 2007 10:55 PM
> 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
>>
>
>
>
> ---------------------------------------------------------------------
> 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