Very Computer

We're using FOXPRO, and now want transfer data to SQLSERVER.
Can we doing this?
Where can I find out more solution?

Ag,

You should be able to use the Data Transformation Services (DTS) component of SQL Server to transfer FoxPro data to SQL Server. However, you might take a look at the section "Data Conversion and Transformation Considerations" (dtssql.chm::/dts_usage_3ayb.htm) in the SQL Server 2000 Books Online for some limitations.

Documentation on DTS can also be found in the SQL Server Books Online.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

Hello

Good point BP. about conversion considerations.  I am currently moving 6
FOXPRO sources to SQL Server and have been bitten a few times.  Mainly with
Numeric data and DateTime data.

Another problem I have come across is that some of my dbf files are dbase IV
and some are Foxpro when I need to create a driver connection.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: You should be able to use the Data Transformation Services (DTS) component
of SQL Server to
: transfer FoxPro data to SQL Server. However, you might take a look at the
section "Data Conversion
: and Transformation Considerations" (dtssql.chm::/dts_usage_3ayb.htm) in
the SQL Server 2000 Books
: Online for some limitations.

: Documentation on DTS can also be found in the SQL Server Books Online.

: -------------------------------------------
: BP Margolin
: Please reply only to the newsgroups.
: When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
: can be cut and pasted into Query Analyzer is appreciated.

      ---  Microsoft Outlook Express 6.00.2800.1106

Another important consideration is whether to include Fox deleted records,
which are not included by default. (This just came up elsewhere). The latest
Fox ODBC driver allows you to specify that deleted records be included. If
they are, there will be no way to distinguish them from any other records.

--
Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP

http://mdsn.microsoft.com/vfoxpro  http://foxcentral.net

You should be able to use the Data Transformation Services (DTS) component
of SQL Server to transfer FoxPro data to SQL Server. However, you might take
a look at the section "Data Conversion and Transformation Considerations"
(dtssql.chm::/dts_usage_3ayb.htm) in the SQL Server 2000 Books Online for
some limitations.

Quote:> We're using FOXPRO, and now want transfer data to SQLSERVER.