>>Yes, but also another example of Microsoft shifting towards more industry standards.
>>
>>>Another nail in the coffin.
>>>
>
>Ok, thanks. Regardless of the fact that OLE DB is being deprecated, we need a fairly robust SQL Server to handle a lot of requests (not HealthCare.gov quantity, but within our company with hundreds of users). We plan only to use FoxPro data via a linked server only in the interim while we port the entire thing completely to SQL Server.
>
>How much of a performance difference will we have in the end after the port is complete if we are stuck on a 32 SQL Server vs. 64 bit?
Once you completed the migration, would it be possible to re-install SQL Server from 32 bit to 64 bit?
If it's not broken, fix it until it is.
My Blog