>>>>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?
>
>Yes, I think it would be possible to re-install a 64 bit SQL Server after the conversion is complete.
>Yes, I'm wondering about that myself. Will a SQL backup made in a 32 bit SQL be compatible with a 64 SQL?

I believe the SQL Server version (32 bit or 64 bit) should not matter when restoring the backup.

So, you can install 32 bit for now and when the conversion will be completed, you should be able to switch to 64 bit version.