× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



A few tables? A lot of tables? Indexes? Views?

You can't "restore" the tables, but you can migrate the data either by
export (another posted mentioned CSV), or using linked servers.

I set up a linked server from SQL Server to i5/OS, created the tables
using corresponding data types (packed/zoned typically become decimal,
etc.), and wrote insert/select statements.

I only needed a few tables (less than 20) so didn't pursue a more
automated approach.

Some considerations:
* Since I used SQL Server as a "reporting" server (instead of
transactional), I chose to convert fake dates (numeric 8,0 yyyymmdd,
numeric 7,0 cyymmdd, etc) into real date data types. Be prepared to deal
with invalid/null values and adjust in the migration script.
* Our DB2 tables were generated by Synon so have gibberish field names
(CZAZCD = location). I chose to use meaningful names instead.
* If you are doing ongoing migration, set up a mechanism to remember
last key values copied. Several of our files are multi-million rows, and
are keyed using a surrogate number (similar to an identity field). We
have a table with the last surrogate copied, and after the first
migration, we can simply copy new surrogates.

--Loyd

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Ahmed.Hussain@xxxxxxxxxx
Sent: Tuesday, April 14, 2009 12:03 PM
To: midrange-l@xxxxxxxxxxxx
Subject: How to Restore AS400 data to SQl Server

Hi,

I have to restore some of AS./400 Physical files to SQL Server, and was
thinking that I can get good ideas from the group. Is there any ideas to

do that.


Thanks,

Ahmed Hussain
BPCS Support


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.