powerh-l digest, Vol 1 #597 - 1 msg

[Greig Morrison]

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