>Greg,
>For 3rd suggestion check this one (better whole thread) as an example. Remember that SQL2005 surface configuration must be set to enable OpenRowSet for it to work (or from within SQL server):
>
>
Re: Upsizing GUID to UniqueIdentifier Thread #
1049183 Message #
1049327>
Re: Updating SQL Server table Thread #
994024 Message #
994067Thanks, I will look at these.
>
>Yet another cool way (if you have a chance to do so) is using .Net code with new SqlBulkCopy class.
I will discuss this with our .NET guys.
>Cetin
>
>>Thanks,
>>
>>I will do some investigating into your suggestion and may get back to you later.
>>
>>>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
Greg Reichert