Importing ISAM data into SQLServer

Hello,
My company has some old ISAM datasets we need to resuscitate. We
would like to import the data into SQLServer. It looks like there are
some ISAM ODBC drivers available, but I was wondering how well it
works.
There would seem to be a step where you have to specify how the input
record is parsed into SQLServer columns. Is this easier in some
drivers than other?
Any input from people who have gone through this exercise would be
appreciated.
Bart
There are different types of ISAM files so it all depends.
The drivers can make a big difference in performance, ease
of use, etc.whenever you work with any other flavors of data
sources. I've done some that have been straightforward and
pretty easy. I've done others that have been painful. Most
of the vendors will give you trial versions - that's usually
the best way to find out what's going to work best for your
needs.
-Sue
On 8 May 2007 14:16:17 -0700, barthome1@.comcast.net wrote:

>Hello,
>My company has some old ISAM datasets we need to resuscitate. We
>would like to import the data into SQLServer. It looks like there are
>some ISAM ODBC drivers available, but I was wondering how well it
>works.
>There would seem to be a step where you have to specify how the input
>record is parsed into SQLServer columns. Is this easier in some
>drivers than other?
>Any input from people who have gone through this exercise would be
>appreciated.
>Bart

Importing ISAM data into SQLServer

Hello,
My company has some old ISAM datasets we need to resuscitate. We
would like to import the data into SQLServer. It looks like there are
some ISAM ODBC drivers available, but I was wondering how well it
works.
There would seem to be a step where you have to specify how the input
record is parsed into SQLServer columns. Is this easier in some
drivers than other?
Any input from people who have gone through this exercise would be
appreciated.
BartThere are different types of ISAM files so it all depends.
The drivers can make a big difference in performance, ease
of use, etc.whenever you work with any other flavors of data
sources. I've done some that have been straightforward and
pretty easy. I've done others that have been painful. Most
of the vendors will give you trial versions - that's usually
the best way to find out what's going to work best for your
needs.
-Sue
On 8 May 2007 14:16:17 -0700, barthome1@.comcast.net wrote:

>Hello,
>My company has some old ISAM datasets we need to resuscitate. We
>would like to import the data into SQLServer. It looks like there are
>some ISAM ODBC drivers available, but I was wondering how well it
>works.
>There would seem to be a step where you have to specify how the input
>record is parsed into SQLServer columns. Is this easier in some
>drivers than other?
>Any input from people who have gone through this exercise would be
>appreciated.
>Bartsql