SQLServer Compact 4.0: develop on 32-bit, production on 64-bit-Collection of common programming errors

Hi All,

I’m new to SQLServer CE 4.0, and am wondering if it will fit my needs.

I’ve created a database on my 32-bit development machine, and am populating it with library data.  The production server, though, is 64-bit.

According to the SQLServer CE 4.0 specs, the 32-bit and 64-bit versions are not compatible.  Does this mean that I’m unable to xcopy and use this 32-bit database on the 64-bit production server?

Thanks for your help,

Brian S Boyd

p.s. I’m glad to see Microsoft creating these simple, cool, easy to use tools like IIS Express and SQLServer CE 4.0: they simplify development.