Search code examples
sql-server-cevistadb

Downgrade SQL CE from 4 to 3.5?


Does anyone know if it's possible to downgrade an existing SQL CE 4 database to 3.5? The reason I ask is because I'm looking to migrate from SQL CE to VistaDB...and VistaDB's data migration wizard only takes SQL CE 3.5 db's.


Solution

  • I actually just found an answer to my own question. Using Data Port Console, you can do an export of an existing SQL CE 4 database to a 3.5 db. Then using Vista DB's Data Migration Wizard, you can import that 3.5 version of the db. It seems to have worked amazingly well and took about 2 minutes.