RE: Migration of JDE data to SQL server on NT

["Holliday, Gary" <Gary.Holliday@xxxxxxxxxxxxxx>]

Armando wrote:
> Have any of you migrated data from JDE to SQL in NT? or 
> from JDE to "any" PC 
> format?

I might be misunderstanding what you are trying to do but here goes anyway!

We have GEAC System 21 on the AS/400 and SQL Server 7 on NT. We copy a large
number of the System 21 files onto the SQL Server each night for historical
reporting and decision support work.

We use Data Transformation Services in SQL to pull the data across, with
VBScripts to convert the 7 digit dates into datetime values. I create views
as required over the individual tables.

Last night's run took around 9 hours for 11,336,954 records.

Gary Holliday
----------------------------
Gary.Holliday@Smedleys.co.uk
Smedleys Foods
Wardentree Lane
Pinchbeck, Spalding
Lincs. PE11 3UY


This e:Mail and any files transmitted with it are confidential and intended
solely for the use of the individual to whom it is addressed.
If you have received this e-mail in error please contact Matthew Middleton
or Gary Holliday immediately by telephone on 01775 710789 or on e-mail at
Smedleys.IT@Smedleys.co.uk
Any views or opinions presented are solely those of the author and do not
necessarily represent those of Smedleys Foods.
Unauthorised publication, use, dissemination, forwarding, printing or
copying of this e-mail and its associated attachments is strictly
prohibited. 


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---