Downgrade SQL CE from 4 to 3.5?

Question

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.

score 3 · Answer 1 · answered Jan 21 '11 at 11:48

3

Yes, you can use my scripting tools to export the 4.0 file to a sql script, and create the 3.5 file from the script, as I describe here: http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html

answered Jan 21 '11 at 11:48

ErikEJ

40,951
5
75
115

score 2 · Answer 2 · answered May 16 '13 at 23:47

2

I downgraded it in 20 sec using SQL Server Compact Toolbox ,Thanks ErikEJ ,Thumb up.

answered May 16 '13 at 23:47

ali haider

333
3
13

score 2 · Accepted Answer · answered Jan 21 '11 at 19:29

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.

Downgrade SQL CE from 4 to 3.5?

3 Answers3

Linked