AS/400 DB2 TO SQL SERVER

I have created a database in AS/400 DB2 with 250 tables and
23GB data in the database, now I want to shift from DB2 to SQL Server.
How can import the database from AS/400 DB2 to SQL Server, without
corrupting any of the constraints and data. Can anyone explain in
detail. Data is very critical.ramkumar.nv@.gmail.com wrote:
> I have created a database in AS/400 DB2 with 250 tables and
> 23GB data in the database, now I want to shift from DB2 to SQL Server.
> How can import the database from AS/400 DB2 to SQL Server, without
> corrupting any of the constraints and data. Can anyone explain in
> detail. Data is very critical.
>
I'm not sure that you can get the constraints carried over, so that
might be manual work.
For the data, you can set up a linked server and then script the data
over or you can use DTS/Integration services.
Regards
Steen|||With db2lookup and db2move commands.I can create the script and ixf
files. Then should I run script for 250 tables manually.|||So if i create the tables manually by running the script then how to
port the data into the tables from ixf files. How to use the DTS
utility in SQL Server.|||ramkumar wrote:
> So if i create the tables manually by running the script then how to
> port the data into the tables from ixf files. How to use the DTS
> utility in SQL Server.
>
I know very little about the ixf format/files, so maybe somebody else
can add something on that part?
If you want to read about the DTS utility, you can look it up in Books
On Line. Another option is simply to use SELECT...INSERT to insert all
your data.
No matter how you do it, I think it will require quite a bit of work
to get every imported correctly...:-(.
Regards
Steen|||Thanq Steen for your response|||Ramkumar,
how did you create 250 tables? You must have had them scripted, right? If
not, remember, if any object is not in script, it's nowhere. Or script all
your tables on as/400 into script files. remember, as/400 is sql database
and one can derive sql compliant script out of it (not an expert here).
Adjust your scripts to sql server format and recreate them.
Define linked server against your as/4000, use information_schema and
regular character concatenation to create insert into sqltable ...select
from linkedserver.catalog.schema.table.
this should do it.
thanks
farmer
<ramkumar.nv@.gmail.com> wrote in message
news:1143783206.245490.202040@.e56g2000cwe.googlegroups.com...
> I have created a database in AS/400 DB2 with 250 tables and
> 23GB data in the database, now I want to shift from DB2 to SQL Server.
> How can import the database from AS/400 DB2 to SQL Server, without
> corrupting any of the constraints and data. Can anyone explain in
> detail. Data is very critical.
>