Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting DBF to SQL 2005
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Vista
Miscellaneous
Thread ID:
01210306
Message ID:
01210338
Views:
22
Greg,

It's simpler to do this from the SQL side. You can either:
1) use SQL Server Integration Services (the 2005 version of DTS) to convert the data through an OLE DB or ODBC connection; or
2) utilize SQL-SMO (the 2005 version of SQL-DMO) in a VFP module that handles the task; or
3) handle this manually with a sproc/query that accesses the VFP data through OLE DB using the OPENROWSET statement.

Check out the SQL Server 2005 Books Online for assistance with each of these, or you can message me privately for more info.

HTH.

>Hi All,
>
>We are looking to convert or clients VFP table (and database) to SQL Server 2005. The problem is that the Upsize Wizard converts the table to SQL Server version 6.5 compatibility. SQL Server has a problem reading 6.5 databases. Does anyone know a tool that can upsize VFP tables to SQL Server 2005?
>
>Thanks
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN

If a vegetarian eats vegetables, what does a humanitarian eat?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform