>As I asked Naomi, I'm wondering if we can install a 32 bit SQL to use VFP OLE DB with until we complete the entire migration to SQL and then make a db backup and then install a 64 bit SQL Server 2012 or even a 2014. Will a 32 bit db backup work on a 64 bit SQL?
We have done exactly the same, moved a backup from 32 bit to a 64 bit, without any problems. I think the database itself is not so much aware whether the SQL Server engine is 32 bit or 64 bit, so that is kind of expected.
Christian Isberner
Software Consultant