mapinfo, tab, data, import, sql server

Hello,
I have "mapinfo" street sample data in hands and the format is "tab". The pu
rpose is to upload the data into sql server 2000 database.
At first, I have used mapinfo professional 7.0's easyloader tool through ODB
C. But after pushing the "upload" button, the warning message gives to me th
at "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 da
tabase.
My question is:
1. Does sql server 2000 need to be configured to support the spatial datatyp
e?
2. Could I use mapinfo's easyloader to do the task? If not, what's tools sho
uld I use?
Thank you for your attention.
kind regards
chenyuChenyu,
SQL Server does not support a native data type for geometries. However, you
can use a product called MapInfo SpatialWare to acquire full support fo
r geometries.
Regards,
Anand.
Disclaimer: I work for MapInfo, but the views are my own. I don't claim to s
peak 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 databa
se does not supports 'point spatial' data type, therefore only the center X and Y in
for
mation will be stored. But I want to save the full spatial information into database.seagreen">
> My question is:
> 1. Does sql server 2000 need to be configured to support the spatial datat
ype?
> 2. Could I use mapinfo's easyloader to do the task? If not, what's tools s
hould 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 fo
r geometries.
Regards,
Anand.
Disclaimer: I work for MapInfo, but the views are my own. I don't claim to s
peak 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 databa
se does not supports 'point spatial' data type, therefore only the center X and Y in
for
mation will be stored. But I want to save the full spatial information into database.seagreen">
> My question is:
> 1. Does sql server 2000 need to be configured to support the spatial datat
ype?
> 2. Could I use mapinfo's easyloader to do the task? If not, what's tools s
hould I use?
>
> Thank you for your attention.
> kind regards
> chenyu