moving c-isam files to MS SQL

[Edis, Robert]

Use the SQL Server DTS tool (via the wizard if you like) to import the data
into the SQL database.

Create the database first.  Try to estimate the size (disk space in
megabytes) required and set the initial db size to that.  It is more
efficient than using auto-sizing.  Also you well know up front if you have
enough disk space before the DTS routine crashes on you.

The DTS routine will create the new tables for you based on the metadata
that can be interpreted by the ODBC utility.  You can change the table
names, column data types and sizes of the new objects as you like.

Save the DTS routine BEFORE you run it as if the tool crashes or freezes on
you or you just quit it you will have to restart from the beginning.

If the tables already exist in the DB make sure you set each table import to
delete existing rows before adding the imported ones or you'll get multiple
copies (assuming the task is run more than once).

Use the SQL Server On-Line Books to get examples.

Good luck 

Blue

-----Original Message-----
From: Viet Nguyen [mailto:VNguyen@wsboces.org]
Sent: Friday, March 28, 2003 1:53 PM
To: powerh-l@lists.swau.edu
Subject: RE: moving c-isam files to MS SQL




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.