Data Conversion

[Viet Nguyen]

Hi Mike & Greig,
	Thank you for the suggestions.  I have a question: Can I not
just move the raw data files and the dictionary from Unix and recompile
in Windows then read the files directly with PowerHouse and output them
into MS Sql tables?
Thanks in advance.
Viet.
 
-----Original Message-----
From: Greig Morrison [mailto:greig.morrison@sympatico.ca] 
Sent: Sunday, March 30, 2003 1:03 PM
To: powerh-l@cube.swau.edu
Subject: Re: powerh-l digest, Vol 1 #597 - 1 msg

A possible solution if you have PowerHouse on NT available.

One of the issues you probably have is that the MS SQL database will
have "_" underscore in
table and item names where "-" dashes may exists in the C-ISAM
dictionary definitions,
assuming that your new MS SQL database uses most of the same names.
Using PowerHouse to do
the data conversion, you can create a new dictionary from the existing
dictionary for your
C-ISAM files changing all the "-" dashes to "_" underscores. Compile
this new dictionary on
the Unix box, unload all the files to Portable subfiles with QUIZ or
QTP. Download the
subfiles via FTP using binary for the data component (.ps) and ASCII for
the dictionary
component (.psd) to a PC. You could use PowerHouse on NT or Axiant to
read the subfiles
directly, to load the MS SQL database, these products will read the
subfile dictionary and
use automatic initialization to load like named items from the subfiles
to the corresponding
MS SQL tables. Note: you need to manipulate any dates with "0" (zeroes)
to convert them to
Nulls etc.

Greig

powerh-l-request@cube.swau.edu wrote:

> Send powerh-l mailing list submissions to
>         powerh-l@lists.swau.edu
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://lists.swau.edu/mailman/listinfo/powerh-l
> or, via email, send a message with subject or body 'help' to
>         powerh-l-request@lists.swau.edu
>
> You can reach the person managing the list at
>         powerh-l-admin@lists.swau.edu
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of powerh-l digest..."
>
> Today's Topics:
>
>    1. RE:moving c-isam files to MS SQL (Viet Nguyen)
>
> --__--__--
>
> Message: 1
> Subject: RE: moving c-isam files to MS SQL
> Date: Fri, 28 Mar 2003 14:53:20 -0500
> From: "Viet Nguyen" <VNguyen@wsboces.org>
> To: <powerh-l@lists.swau.edu>
>
> Hi all, can someone show me how to move c-isam files to Microsoft SQL?
> We have c-isam on IBM AIX (Unix).
>
> --__--__--
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a
subscriber.
>
> End of powerh-l Digest

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.