mapinfo, tab, data, import, sql server

Hello,
I have "mapinfo" street sample data in hands and the format is "tab". The purpose is to upload the data into sql server 2000 database.
At first, I have used mapinfo professional 7.0's easyloader tool through ODBC. But after pushing the "upload" button, the warning message gives to me that "the database does not supports 'point spatial' data type, therefore only the center X and Y informa
tion will be stored. But I want to save the full spatial information into database.
My question is:
1. Does sql server 2000 need to be configured to support the spatial datatype?
2. Could I use mapinfo's easyloader to do the task? If not, what's tools should I use?
Thank you for your attention.
kind regards
chenyu
Chenyu,
SQL Server does not support a native data type for geometries. However, you can use a product called MapInfo SpatialWare to acquire full support for geometries.
Regards,
Anand.
Disclaimer: I work for MapInfo, but the views are my own. I don't claim to speak for my employer.
"chenyu" wrote:

> Hello,
> I have "mapinfo" street sample data in hands and the format is "tab". The purpose is to upload the data into sql server 2000 database.
> At first, I have used mapinfo professional 7.0's easyloader tool through ODBC. But after pushing the "upload" button, the warning message gives to me that "the database does not supports 'point spatial' data type, therefore only the center X and Y infor
mation will be stored. But I want to save the full spatial information into database.
> My question is:
> 1. Does sql server 2000 need to be configured to support the spatial datatype?
> 2. Could I use mapinfo's easyloader to do the task? If not, what's tools should I use?
>
> Thank you for your attention.
> kind regards
> chenyu
|||Chenyu,
SQL Server does not support a native data type for geometries. However, you can use a product called MapInfo SpatialWare to acquire full support for geometries.
Regards,
Anand.
Disclaimer: I work for MapInfo, but the views are my own. I don't claim to speak for my employer.
"chenyu" wrote:

> Hello,
> I have "mapinfo" street sample data in hands and the format is "tab". The purpose is to upload the data into sql server 2000 database.
> At first, I have used mapinfo professional 7.0's easyloader tool through ODBC. But after pushing the "upload" button, the warning message gives to me that "the database does not supports 'point spatial' data type, therefore only the center X and Y infor
mation will be stored. But I want to save the full spatial information into database.
> My question is:
> 1. Does sql server 2000 need to be configured to support the spatial datatype?
> 2. Could I use mapinfo's easyloader to do the task? If not, what's tools should I use?
>
> Thank you for your attention.
> kind regards
> chenyu
sql