开发者

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 bec开发者_运维百科ause I'm looking to migrate from SQL CE to VistaDB...and VistaDB's data migration wizard only takes SQL CE 3.5 db's.


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


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.


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜