>>>>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 run 32 bit on one box and 64bit on another and have never had any issues moving backups. The databases themselves are not different.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.