开发者

Downgrade SQL CE from 4 to 3.5?

开发者 https://www.devze.com 2023-02-06 01:24 出处:网络
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 mi

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

精彩评论

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

关注公众号